Search results

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?

can you upload an example of this mate sounds a pretty good solution

That doesnt help when the user holds shift and goes into the toolbar? Could you elaborate more please

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

How exactly would i implement this Could you upload an example please?

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?

I have tried this but it is still not working It says cannot find tbaudittrail please help i have atached the db

Could someone explain this to me please as i cant work out how to use it in my database to incorperate subforms within a form within the audit trail

Aha Nice one found it shift and f2 How do i include subforms which are also on the main form duder?

Right Here is the latest The append and update queries do not work unless all the fields that are being appended and updated are being filled in. Any ideas how i can get it too work even if just one field is filled in and the rest are blank FAO Ghudson your audit trail one. How do i get it to...

Dude I got your audit trail function working It doesnt store it in a table though? where does it store it? i got an audit trail field set as the data source But when i view the actual table there is nothing in there

Brian This is an audit trail yes.. Where are the links. will have a quick search see if i can find them Other fields specified within the queries have combo boxes and yet they do not need to be fille din

Brian Many THanks for that Is their any reasons why it doesnt work if the site and department havent been filled in?

Brian Could you elaborate on that a bit more please. or upload an example as i am failiing to grasp what you mean many thanks