Search results

Sure jdraw, but it was a code found on the internet, here it goes but first create a table named as 'tblAudit' with fields as: Audit_ID User DateTime UniqID_Field UniqID Form Field Prev_Value New_Value Action Reason DelValues **UniqID is your primary key and UniqID_Field is your name of the...

Nope, I can't remember I fixed it, but I'm using another code now for Audit

Raghu, here is the db. Sub Form : HEX_BF_AllChanges Parent Navigation form : HEX_BF_Navigation Form the code from fontstuff's Martin Green is working perfect when I run the sub form 'HEX_BF_AllChanges' on stand alone but when this same form is run from the navigation form 'HEX_BF_Navigation...

Hello Raghu, sorry to post this old thread, I'm a just a beginner in Access, could you pls explain me or help how to solve this problem? :banghead: I have the same issue, code working as a single form but not when I use it in a navigation form. by the way I use MS Access 2013. I just went...

Thanks Markk for your reply!! I tried but I get an error when I compile for the code Call AuditChanges(Me , "EDIT") as "Argument not optional"

Hello, lets say I have three forms - Form1,Form2 and Form3 linked to a navigation form with Navigation buttons. I have separate VBA codes under each Before update event of these forms, Form1,Form2 and Form3 to call a VBA module to track the changes performed by the users(Like an Audit Trail) in...

'Put this in your routine to force close the application 'oMsgBox.PopUp "Testing...closing in ten seconds.", 10, "Force Closed", vbInformation oMsgBox.PopUp "Your copy of the XXXX program will be closed in thirty seconds. The data tables in the XXXX program are being updated or the XXXX...

Hello, lets say I have a table with five tasks for five employees and each employee's data type is with 'Yes or No'. I need to have a desired result to check 1.if all the employees have completed that particular task then the result should be 'YES' 2.if anyone employee has not completed that...

Not working either way!!

No,Its always closed and I also tried after checking your post by closing the form (frmlogin) and running the main form but still i'm getting the error :banghead:

Yes,I do and that is the reason why I came here ;)

Hello, could anyone pls help me on this? I am trying to create a login form and end up with this error below, I am just a beginner and I used this code which was already available in the internet. Run-Time error '2450': Microsoft Access cannot find the referenced 'frmlogin'. the code...

Hi, is there an option to add a button on a form so that if i click the button all the values displaying on the form will be exported and viewed/edited in excel.I don't want to export the file to my drive also. i knew the "Tools -> Office Links -> Analyze it with Excel" option. The problem is...

Hi, I already created a Macros to run a query and export the query in an excel format to a specified location in my local drive but now i want also the same file to be sent as an attachment to a person's mail id,when the macros is run on autoexec. can anyone help me pls?