Recent content by faradhi

This is not necessarly true. There are often instances that someone needs two versions of Access installed. In which case, it is necessary that the absolute path be used rather than depending on the windows path statement. ;)

Break it up in several queries. Run an Append to the new table and a delete query from the old table.

What do you want to do with the set of records? Do you want to display or process etc....

I the problem may be with the line criteria = "[User] = """ & Forms![Login]!user & """" THe line should be criteria = "[User] = '" & Forms![Login]!user & "'"

Another way to handle this is login scripts if you can talk your systems admin to allow you to add a snippet of code. You can test for the database on the users system and then use robocopy or xcopy to overwrite the local copy if there is a change.

Well that didn't work either. States that the object doesn't support this property or method. Any other suggestions???

Thanks SJ I knew it was something stupidly simply. I just could not remember how.

I have this function code that I know will not work. What I hope to accomplish is that the function is passed the property name and it returns a propery value. Function GetProp(StrPropName As String, StrLDAP As String) Dim Objuser As Object 'Opens the LDAP object for the active...

That is what I thought. Thanks for the confirmation and quick reply. Bryan

I have an Access Database for that aids in Parking Management for a small college. In the Database I have two tables. The first is table tblLots, which holds the Lots that are managed, has the following fields: LotID LotDesc The Second Table tblCustType, which holds a type of customer, has...

I have a table called tlbAsset that has the following fields. tagid (primary Key) Make Model UserId SerialNum I have another table called tblproducts that has the following Make (primary key) Model (primary key) Type I would like to set the validation rule in tblAsset to only allow...

You Could just copy what is in the field to be updated OnEnter.

I have an Append Query that updates an external database. Since it is possible that the Destination DB may Move I would like to change the Query property "Destination DB" with VBA. Can Anyone tell me how to do this. :confused: