Search results for query: *

I did try this in the testing process. I noticed if one user tried to type when the other user was just leaving the record, the item would become corrupt. I think it has to do with the compay running a older release of Access 2000. Thanks for your response

I have a small database which will only be shared by a couple of users. It will be a very rare case when two users will be editing the same record at the same time. However, I tested the situation anyway. The default access box has an option to save user one changes and disregard user 2 changes...

Is there any way to insert a label after certain records have been printed? I had a strange user request asking if when a report reaches record 50 and 100 on an Access 2000 report, to insert a line which just has a label on it.(Each break would have a deifferent label text) I experimented with...

Is there any way to set MS explorwer5's warning alerts to false? I have a simple SQL VB script code which will close a MS Access 2000 Data access page if the backend needs updated. My codes works fine, but I have to click ok on a MS explorer message box to confirm if I want to close the...

I am hoping this is a easy question. One of the areas I work with just wants a basic Access 2000 data access page with the ability to search for records. It appears the wizards do not support the search record feature (The wizard only supports move next/previous operations.). I was going to try...

I am trying to embed an access report which I converted to an Adobe Acrobat format in a table for historical purposes for my manager. I am able to place Word and Excel docs with no problems. I am unable to open up any Acrobat files once I place them in the database. I recieve a general...

I have an Access database I would like to spilt and secure. I would still like to secure the application to manage data conflicts. (This should be rare in this department where the app will be deployed but I would still like to manage them. I would also like to continue to use a procedure I...

Thanks!. The re-compile solved the last issue!!!

Thanks! I am having one last issue. When I try to open the form to run the code, I am getting a "type mismatch" error on the open record set command. (Set rs = db.OpenRecordset(strSQL, dbOpenDynaset) I did double check my table. I do have the log start and end fields as date data...

I had this procedure working in a database that my boss deleted by accident! I recreated the procedure. However, I am getting a bad syntax error in my SQL portion of the code. Below is the code I have in my module. strSQL = "select * from logout where applicationname = " _ &...

Should I use a "d lookup" function to use in the timer event on the form to look up the values in the table? Thank-you for your help. By any chance, do you have any samples you could send me. The other solutions I heard of was logging users out through NT functions or having admin...

Is there any way to log out users in a VBA program. I know how to obtain a list of available users through VBA, but I was wondering if users could be log out through code. Is the only way to log out users in an Access database is to use the security wizard?

I am having a very odd error in a shared database today. There is a basic search button on aform which siimply uses the Access field search box to find an account number. When the item is not found, I am reciving a invalid bookmark error instead of the usually unable to find the selected item...

I am trying to pull a "True" random sample from a basic Access table. I am currently using a SQL Top function in the report. I read in an Access tip book the Top function will not generate a "true" random sample. Is there any other functions which will select a random sample...