Recent content by cgmckenzie

I solved it.... I just put Access2000 on all the computers made it simple thanks for the help. Chris

I have 4 computers on a network. 3 have access2000 one has access97 the one with 97 can't open the the shared documents with 2000 database fills.

I would like for the data in a field to have the first letter of each word to be capital. How can I do this. Thanks For your help Chris

Thanks for the help travis

This problem stems from me trying to make a database with sharing capabilites. As of now two people can not open the same form at the same time. I know this is because both users are opening the database in exclusive mode because this is an default permision for admins. I used the user level...

Doc man has got the right idea i tried to set up the users and so forth when i opened the db it asked me for my password. When another computer opened it did not ask for a logon. when the next computer tried it said it did not have permission from me to open it. However when i logged in and...

This thing is horrible I am so confused now. I printed it out the stuff looks like this User Name Groups that the user Belongs to admin Admins,Users CGM Users cgmckenzie Users...

Doc man I appreciate it i am going to try it now. I have the default setting set to open in sharing mode and not exclusive, it is wierd because when you go to set the database password it says you have to open in exclusive mode, then you turn around at the same time and try to open a form that...

I am using windows xp and the Access2000, I just took the db and set in the network folder for shared documents on my computer. When you open the database a file is created with a lock on it. I quess its the locking file. Dont let me come off the wrong way i really appreciate the help i...

network I have changed the Record setting to all three choices and still get the same message. Could not lock to table because it is in use by another person. I have changed the setting to shared and not exclusive and still get the same thing. More than one person should be able to open the...

I have a simple database I stick in the my shared documents folder so 2 other people can use it and the the forms and everything else works as long as only one person uses it. if another person tries to open the same for it gives me that stupid Could not lock onto Database error. The default...

Worked like a charm thank you for your help

How can make the focus go to the next field when I select a record from the combo box. right now you select a trucking company from the combo box and the focus stays on the combo box. Quick question can u change the backcolor a unenabled field from grey thanks for all your help...

On a form i am going to have a check box for each U.S. state abbrevations. In my table i am going to have a field called StatesServiced. I would like it to work like this, Lets say you check the boxes for nc,sc,ga,fl, it shows in the field stateservice such, "NCSCGAFL". Remember each state...

right now i am not using any buttons just a control box. The query runs perfect when i have Docmd.openquery "LoadMcQuery" on the "on enter" control of the box. The problem is instead of opening the query seperately i would like to have a subreport at the botton of the form with the query...