Search results for query: *

Thanks Bill The relationships I had established between my tables were "indeterminate". This was a result of setting up the correct primary keys, etc. I have made the adjustment and all is well. Cheers Nick

Hi there I have a form bound to a query. When it loads (the form) I assign the the name of the query to the Record Source property of the form. If I try edit the results of the query, I then get the error 'recordset not updateable' The recordset is a dynaset. The query is nothing complicated...

I'll have a go with that, Ryan. I'm sure it will work. Thanks a lot Nick

I'm trying to carry out a specific function that will only run if members from a particular user group log on to the database. Does anyone know if there is a similar function to CurrentUser(), but one where an entire group of users can be referenced (eg Accounts), not just one user at a time...

Very well Thanks Mike. I will have another look at my book and try see what I missed. Cheers Nick

Hi Michael By going through Explorer, they are by-passing the switch within the shortcut to the workgroup information file that contains all the user names and passwords. The switch looks like this: ("C:\Program Files\Microsoft Office\Office\MSACCESS.EXE&quot...

Hello all I would like to set up my database such that users cannot access it by going through Windows Explorer. Rather, they must use the shortcut I have set up on the their desktops. By using the shortcut they are switched onto the workgroup file and prompted to enter username and password...

I would like to set up simple transaction log to see who does what with my data. I say "simple" as I am a relativly new user. Any help would be great. Also, does someone have some code to help me keep track of who is currently busy in the database?

UnckeJack, that code which you and Seaport have been discussing: would it be possible to mail it to me? I am also looking for a way to check who it using the database. My address is nachandler@hotmail.com I am also looking for a simple way to set up a transaction log to keep track of who does...

Thanks Terry Not all the strings contain semi-colons, but that will certainly help reduce the result set. It's a pity that there isn't a simpler way Nick

I am trying to create a query to search a field and retrieve records that contain specific characters within a string. The obvious answer is to use wildcards. But let me try and elaborate: Below are 3 records in a dataset. All of these records contain the character combination “14”. Record 1...