Search results

: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 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...