Search results

rhett7660: Do any of the computers have access runtime 2007 installed? Bruce: Speaking only for the ones that I use, no, none of them have runtime 2007. I'm just using Access 2003. What I thought an hour ago is yet even more restrictive and complicated now. To allow user changes in only...

I'm not celebrating yet, because what I found may be a big pain in the rear to circumvent, but here is what I think I have determined: To lock some but not all fields in a subform in datasheet view, you have to set the Main Form property "Allow Edits" to "Yes" as well as setting the subform...

Thanks for all the attention. I took this beast home again last night. I'm using Access 2003 SP2 at home, so now at least two of us know first-hand that it isn't SP3 that is causing the problem. I also created new forms, and based them off similar data, using SP2. I think my subform worked...

Wow! Yes, I am using MS Access 2003 SP3 (11.8166.8172). I just installed updates a couple weeks ago. If you think that the version is the problem, I guarantee I would never have discovered it on my own... I must be using the same version at home also. ... Now comes the obvious question...

I created a new database, copied over the relevant objects, and sanitized the employee list. I confirmed the problem is still there. As you will see, there is no apparent Child/Master link between the "MyRecords" form and the "TimeOutOfOffice" form. When demonstrating to yourself, you'll...

This thread came closest to the problem I am having. I'm trying to develop a small database to manage vacation requests. On the initial form, a user selects him/herself from drop-downs for department and name, and clicks a command button. Upon the click event, the user sees another form...

In Sub Command2_Click() you Dimmed strEmmployee As String but you set strEmployee = "Like '*'". I recommend setting Option Explicit to find mis-spelled variable problems like this. However ,this is NOT the cause of your trouble... I could easily be wrong, and am mostly guessing, but I believe...