quality mate
i dont get how i can intergrate that into my database
i have a form that loads on startup
But if i use your solution wouldnt it just load this form and then close the database?
I have found the exact same problem
The database is locked
User opens it
Holds down shift
The toolbar appears
he chooses startup optins
ticks all the boxes
re-opens the database and hes straight into the backend
hmpht
Hi
Im trying to use this but every time my form opens it comes up with the debugger highlighting the onload event
Call FosUsername()
Any ideas people
Using access 200
I have searched for this and have not come up with an answer as yet.
I have query that is accessed by entering criteria in a text box and then the user can click a button which will use the criteria entered in the query and then export it to an excel file.
Is there any way i can get the option...
I could try that but the field the users enter would be for example
28/11/05 for the date installed
I want to run a query which shows all the computers installed in january
from a combo box which just lists all the months
I have a database about when computers have been installed
I have a form
It has a drop down list with Januray through to December
I want the user to select a month and a year and then click the command button and it will run a query displaying all the computers installed in the month of that...
Could you take a look at this
http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=11532
and show me how to incoporate the subforms into the audit trail
Sorry mate. which notes would these be?
Also i cant really see how this works
On my sub form
i add in on before update
Private Sub Form_BeforeUpdate(Cancel As Integer)
On Error GoTo Form_BeforeUpdate_Err
Call Audit_Trail(Me)
Form_BeforeUpdate_Exit:
Exit Sub...
Erm well i think i get what it is saying
Have tried to implment it but still cant get it working.
I have read through the link you suggested on page 6 and am still none the wiser
is there any examples of it working online?