Recent content by Stigm@t@

Hey MStef Thanks for the demo and advice. Will give it a try night. Regards Stigm@t@

:confused: Hi I have done a lot of reading on the site and tried everything i could find that i thought would work, but with no luck. Here is my problem. I have a single report that based on a selection of a form will print the report for the selected machine. So what i am wanting to do is...

Got a problem trying to reference a global variable in the control source of a text box. If i do a DLookup when the form opens and have the text box value = the result it works fine ie Private Sub Form_Open(Cancel As Integer) Text2.Value = DLookup("UserName", "Users", "[UserID]= " & MyUserID)...

I have found that when closing a form and changes have been made to the fields, these changes will be saved. I would like to know if there it is posible to only save the changes when a command button is pressed and not when if you close the form any other way.

Hey Ion Please can you pass the information that you spoke of to me. I think that if i can get my hands on as much information as possible, it may help me understand the Access Security. Tanks

Ghudson Hey I am trying to get hold of Ghudson. How can i do this. I tried to message but the message box is full.

Thanks Bee But i have already read that thread. I just read something else that makes me think that i will not be able to do what i would like to. Would the following statement be true? When you start a DB up you are prompted to logon. Once you have, you will not be able to change who is...

Hey Doc I have been looking through the threads and have found a lot of information regarding security. However i have not found anything that is quite what i am looking for. I think that a good start for what i need to do, can be done using the Disable Shift Key function that Ghudson posted...

Hey statsman That sounds good, but if the DB is then moved to another PC that does not have this second .mdw file, will anyone be able to open or will it not open as it does not have the specified .mdw file. This security part of access is new to me, i have never had a need for it before until...

Hey I am looking for a way to secure a single DB. I would like to be able to use the DB on other PC, but still have user control. I have found that when using the MS Access User and Ground way will only secure DB's used on the PC it was set on. If i take the DB to my home PC i am not promted...