Search results for query: *

Hey, First off thanks for the reply. Unfortunately i'm not a programmer so pretty much all of what you posted went over my head. If you have time could you simplify that a bit for me..........maybe some sample code will make it clearer. Thanks again chris

Here is the situation i've encountered. Employees will be receiving calls from our agents and will be given case numbers. Each of these cases will be recorded in an access database for reporting purposes. The problem right now is that if agent "A" calls in with a case number of...

Hey Pwise, Pardon my ignorance but i've never heard of add mode. Could you give me a little explanation as to what it is and does? thanks

Hey Darrylle, Thanks for the quick reply. I did what you advised and filtered by date entered. It did show the records as not being there however when i clicked the filter button on the toolbar to turn it off they all re-appeared. The thing with that is are they still loading in the background...

Hey folks, Hopefully some of you will be able to help me with this. I have a form called "ResourcePhone" where employees go to log calls they take. Each employee may log as many as 100 calls per day in this form and it is all written back to the resource phone table. As it stands...

Heidi, Again thanks for the help. I'm going to go ahead and create the different tables then let you know how it goes. Later, Chris

First off thanks for the reply. The only part that i was unsure on what where you refrenced the row source as tblVideo etc. I have the video, motherboard etc logging issues all in one table. I was trying to reference the column in the coding like this: If Me!cboIssueClass1.Column(2, 4) Then...

Here is the situation folks, hopefully one of you will be able to help me out. I have two combo boxes, cboIssueClass1 and cboIssueClass2. I have a list of issues in the first box based on a table called IssueClass1. That table has 2 columns, the ID field and the issue class field. In the issue...

This is most likely a simple question for those that have used Access for a while but here goes. I what to make a button appear depressed when clicked and normal when slicked again. I have a button now that filters records by a field on that form and just what ensure they now they clicked the...

Hey guys, right now i have an mdw file setup for my DB so when the users click on the link it brings up their logon box for them to enter their credentials. Is there any way i can have the main menu open so that it already has a Username box and Password box on it? What i want to avoid is the...

Thanks for the reply Jim. I also thought of the default value option but each employee may have a different value in their txtDaysWorked field. If you work Mon-Fri you have XMTWTFX but if you work WED-SUN you have SXXWTFS. What i want to have happen is when i load the attendance form and the...

I am not a programmer by trade so i'm hoping some of you will be able to give me a hand. I have a text field called txtdaysworked. In this field the workers weekly schedule is as follows XMTWTFX and so on depending on what days they have off. Apart from this there is a series of 7 text boxes...

Hey folks, I am not a programmer by trade so i'm hoping some of you will be able to give me a hand. I have a text field called txtdaysworked. In this field the workers weekly schedule is as follows XMTWTFX and so on depending on what days they have off. Apart from this there is a series of 7...

Hey, I did that and it's still doing the same thing. Here is an example of the coding for the OnCurrent and OnOpen events for the form itself: If Me!optLine1 = True Then Me!txtTeamID2.Visible = True Me!txtSunHours2.Visible = True Me!txtMonHours2.Visible = True Me!txtTueHours2.Visible...

Here is the situation folks. I have a section of text boxes where people can enter their hours worked from sunday to saturday, so there are obviously 7 boxes. If they take a sick day another row of text would appear based on the user clicking on an option button. The fields are on the form but...

Robert, Thanks for your help...........i really appreciate it. Chris

Hey Folks, I have hidden fields on a form which are activated when an option button is clicked, turning their visible property to true. The problem is when i go to a new record the fields i made visible in the previous form are still visible when they shouldn't be. Is there code i can put on...

Other than code is there any other way of modifying the MSysObjects table? Thanks

Thanks, I think this will help. However, I may just be having a bad day with this headcold and all but is there any reason why I may not be able to see the MySyObjects folder? I could swear I saw those tables there last week. Perhaps it is the .mdw file I am connected to or maybe it is...

Hi there, I'll start out by outlining the directory structure we currently have the database stored in. On the network there is a drive mapped as G. On this drive we created a folder called SupDB. Within that folder we have a file called supdbdata.mdb that just houses the tables and...