Search results

passwords Graham, find attached a popup password form. I have used this as a basis for entering a database and for allowing access to protected forms. you will need to create a table containing user ID and password details. The advantage of this method is that its easy to add additional...

Ross I did this by adding some code to check a users status ie read only. If the person only had read only access i set a global variable to 1. On opening each form I ran some code to check the variable. If it was 1 the form opened in read only mode and if not 1 then data entry and editing...

Correct event Pat, Thanx for pointing out the correct place for the code. Its been a while since ive done any real coding but am getting back into it. its good to see that while trying to help someone out I can still learn things. cheers ian

networking Digby, nice one. best of luck setting it up. just to let you know my database is networked in another public sector. Granted the distance from the server to the local machine isnt any more than about 25 miles. The only problems I have encountered with performance are at those...

scores try the following in the on exit event and see if that works if isnull(Me.Score2) = True then MsgBox "please enter Score2" DoCmd.cancelevent exit sub else If Me.Score2 <> Me.Score1 then Msgbox "Score 1 and Score 2 must match!" Me.Score2="" DoCmd.CancelEvent DoCmd.GotoContol (Me.Score2)...

query Joe Like [Enter Specialist Last Name Only] & "*" will return whatever the user types in and the wild card bit will also return anything else after that. eg. if you have a specialist named smith,one named smithers and one named smithy all three will be returned if you enter smith. If you...

text box hooby1, In design view open the properties box for your textbox. Click on the tab that says Data. The ControlSource is where you enter the details of what you want to bind the control to. To select the bit you want click on the "..." to open the expression builder then work your way...

additional code Joe, could you please post the code that includes the additions you ohave pasted into it. It would also help you could identify highlight the line of code that is causing the problem. cheers Ian

Joe, Its normally due to a variable expecting 1 type of data but receiving another. eg an interger receiving text etc. It could also be the code requires compiling or one of the references are missing. If you could post a copy of your code or database Ill have a look at it and see if i can...

networking Digby, I guess its now down to what you feel comfortable working with. in the situation you have I cant see any real problems as such. From your last post I assume that your current setup is working fine. If this is the case, and due to the limited updateing, I am reminded of...

password code Joe, sorry for the delay getting back to you I have attached a copy of a basic password form. i have made some remarks for each part of the coding. I hope you find it useful. You may also want to have a look at the properties of the password textbox for the correct formatting...

Digby, My understanding of your situation is that you want the data to be dynamic and available to other users as soon as its been updated. If your copying from a master, updating the data then pasting it back the data other users see may not be as upto date as possible. Additionally i can...

password query Joe, I assume you have used the query to compare the data entered by the user. As you have found it can cause problems. Stick with the VBA code and pop up form as you can format the text boxes so "*" is seen instead of the actual letters. regards Ian

password Joe, Basically you use will have a couple of unbound text boxes on the pop up window with a command button to enter the page, databse or whatever. On clicking this it will open up the relevant table and check to see if the persons ID matches the password. If it doesnt it wont let em...

dates Saros, For what its worth I had this problem which resulted in errors validating entered dates. I found this wasnt a problem with access or the coding i used, as it didnt happen with all computers the db was on. It turned out to be the regional settings of the individual computers...

Digby, Im not sure how the citrix network works but i have networked my database over a standard netwrok with no problem. I created a backend to hold the data, which is kept in a netwrok folder that has the correct permissions for people to access. Each front end is loaded locally and then...

password Joe, For the amount of users how about having a seperate table with the users ID and passwords stored. I have done this in the past. When clicking the button to open the protected form use a pop up form 1st. Here you can prompt the user to enter their ID and password and if correct...

Pat, Thanks again for the information. I have had a play with update queries today. Much easier than the coding I was trying to remember. cheers. ian

Pat, Thanks for the information. I forgot to include the fact that i would be updating multiple tables and the number of records to be updated would range from 1 to about 15. would the update query still be a viable option in this case? regards ian

thanks for the prompt reply. I dont have a problem using VBA to actually update the records. i just cant seem to remember how to select the individual records, directly, using VBA code. eg. if i want to update the records of the employee IDs 8888, 9999, 1010,1212, etc how can i go directly to...