Search results for query: *

Thanks. I noticed that the Microsoft Office 9.0 Object was missing on most of the machines. Apparently, Office was not completed install and the DLL that it references is not out there. So... I deleted and it works fine. I only need the OLE Automation, VBA, Access 9.0 and DAO library...

I need help ASAP. I am getting the above message. It happens only occasionally. I have a form that is basically a login form to identified who this person is. Some people can get into it, but others can't. It gives them this message Undefined funtion 'trim' in expression. I can copy my...

Sorry for being so ignorant, but where does that syntax go? Thanks

Hi. I have a form (frmmasterform) that has a sub form (frmerror) and works as a 0ne to Many Relationship. On my master form, I have a field that is text that simply indicates whether the record has a related error in the subform. Right now the field is manually entered, but I would like to...

Everyone uses a windows logon in our company. Once they long on, I would like to set security on the controls rather then the whole form. Below is example:] Private Sub protect_control() If windowslogon = "cbrown" then fix_date.locked = true End If The thing I am not sure of...

I need help with a form. I want to create a form that has 10 controls. 5 controls I want one department to see (or change and update), the other 5 I want a different department to see. Is there a way to do a if...then... statement to allow the controls to be updated based on Windows Logon? I...

I have created a database that has many links to Oracle. The problem is when I add a new record, neither Access or Oracle allows for the primary key to be an auto number. So... I was able to create a macro that before update looks at a form, takes the max number and adds one, then set the...