Search results

Everything sounds good so far. However, without seeing the table structure, it is difficult to comment (40 tables sounds high). Check Out - Suggested Readings

See Attached

http://www.mvps.org/access/queries/qry0001.htm

Dave (dcobau) – you are correct if page level locking is being used (good point). Dave (Dragn73) – at each users workstation select Tool > Options from the menubar in MS Access. From the Advanced tab make sure the checkbox “Open database using record level locking” IS checked.

Dave - jonamua1971 is on a thin client – so there is no local hard drive. You can create a folder for the application in each user’s home directory (usually my documents) and place the FE there.

tmercier - Just a couple of suggestions. Post all your code for a procedure – seeing only part of it makes it difficult to offer assistance. I have no idea what data type your variables are and when you are setting the strCriteria value. Also, where are you using the SQL variable? We need to...

Is you network platform Microsoft of Novell? Are there memo fields in your data entry form – if so how many? Does your query contain 2 or more tables with a one to many relationship? If so, a Main Form / Subform approach should be used. Look at the design view of each of your Forms, Reports...

Ruud - You are welcome.

You are welcome – glad you were able to get it working. It is a very useful function. Make sure to save it for future projects,

By default, Intellectual Property belongs to the creator. If the person is employed – the company that employs him/her is the owner. So if Company ABC hires a programmer from Company XYZ. Company XYZ is the owner. I am almost certain this is internationally supported. Company ABC has an...

Right click on a toolbar and select customize from the shortcut menu. Display your custom shortcut menu. Then Click File from the Menu Bar. Holding the Ctrl Key – click and drag the Print command from the File Menu to your custom shortcut menu (this will copy the button). Close out of...

Check out: http://support.microsoft.com/default.aspx?scid=kb;en-us;231801&Product=acc

Just an FYI – I don’t know how this applies to Scotland – but in the US – software created by a third party is their intellectual property. Cracking source code passwords is illegal if the software is not your property. You may want to look into this, before going too far.

"having periodic lock ups where they go to enter a new record " Sounds like you may have a Primary Key issue - are you using an AutoNumber as your PK? http://www.microsoft.com/technet/prodtechnol/office/office2000/proddocs/opg/part3/ch16.mspx...

The security is intact regardless of the workgroup file. However, the username and permissions would be missing, which could prevent users from accessing the application. If I gave you a mdb file with User Level Security set up, but not the mdw file – you would be limited in what you could...

The first step is to create the login form. Once you have the username you can store it the table and filter the records based on the username. http://www.databasedev.co.uk/filter_current_user.html

http://www.google.com/search?hl=en&q=crack+Microsoft+Access+VBA+password&btnG=Google+Search

Try making the Admin user part of the Admins group. Then when you are finished with the wizard you can switch back the account (make sure at least 1 user is in the Admins group).

From the Menu Bar in the VB Editor select Tools > References. Scroll down until you locate “Microsoft Outlook Object Library” and select the check box next to it. Select Debug > Compile from the menu bar to compile your code.

Example: http://www.databasedev.co.uk/login.html