Search results

Visit http://www.vb123.com/toolshed/00_access/auditrecords.htm This is where I got the Inof From

So is this an add-in I need to do or is this a programming function

What do you mean added the function ?

I found this awhile back Alternatives From Garry Rather than saving the full record to another table, you can add 2 fields to the current table such as SystemUsername (text 50) and RecordChanged (date) and log the person who made the last change to that record. In the before update event...

BTW Username and RecordChanged are both fields in a single table

I have created the following code to put the date and username into a table to track any changes made to a record. All I am interested is when the change was made and by who. When I change a record the Now() command works fine and puts the date and time but the Username = User_FX does not grab...

Here is my SQL Query that the report uses. I want the user to be able to enter the CustID#, that is a unique # to each order. SELECT tblCustomers.CustID, tblCustomers.gilesCompanyName, tblCustomers.CompanyName, tblCustomers.BillingAddress, tblCustomers.BilltoCity, tblCustomers.BilltoState...

I have a form (entry screen to enter data) I then created a report in the layout I need for my order form. I want to creat a button that a user can press and it will print the current record to the report (order form layout) Here is my current code for the print button on the form page: Private...

Thanks that worked, I knew there had to be a way

I am trying to make a layout just like the attached file. Is this possible in Access ? There is 6 fields in the table each of the boxes is a day so the layout is in a week at a time view on legal paper. this is done in excel right now. Thanks for the help:confused:

Whoops I ment This makes no sense Sorry...........

his makes no sense. If i use the following code. The recoed gets deleted. but if I use the second code it dont. Private Sub cmdDelete_Click() On Error GoTo Err_cmdDelete_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, ...

I tried both choices and neither works Here is my updated code Private Sub cmdDeleteRec_Click() On Error GoTo Err_cmdDeleteRec_Click If MsgBox("Are you sure you want to delete this record?", vbYesNo, "Warning.........") = vbYes Then DoCmd.SetWarnings False DoCmd.RunCommand acCmdDeleteRecord...

I am trying to create a button to delete record, I have used the wizard and it works fine but now I want to have a confiirmation message to confirm that they really want to delete this record. below is my code. The prompt works but the record never deletes. Any Idea's Private Sub...

I would like to use yours but DCX693 seems easier ?

DCX693 I have tried this and now my report prompts me twice to enter the date. Any Idea ?

To make things a little more complicated, What happens if a record is deleted, then the audit trail for that reord is gone also. Can the audittrial field be in a seperate table so it does not get deleted ? Great job on this BTW

ok Thanks for the help

I think I got it figured out, I had to copy the FE to each users home dir so they con run seperate instanceses of the FE db, But my question now is when I make a change to a form or report etc , do I need to copy that file over to each users home dir and overwrite the copy thats already there...

Still need some help on this issue Anyone have any Ideas