Recent content by eddie_j_derbys

Hi All, Please can someone help - I'm trying to get an external application (MapInfo workspace) to open when I start up an access database. I understand this can be initiated using an AutoExec macro, however I'm unsure what code to use. Thanks, Ed.

I also get the same error despite being the same to Irish634's attachment.

Two questions; 1. I'm only required to audit the date of changes made to my data so I've selected 'date/time' for the data type of my audittrail column. This works fine, however it doesn’t overwrite with the latest date when subsequent changes are made. Can anyone suggest how I can get the...

You're right, I dont want users to decide whether to record the audit trail or not. I just want to incorporate the save changes prompt box with the audit trail when moving to the next record or closing the form. Sorry im new to this, where is the vbYes operation?

Hi, I'd like to combine the audit trail code with the following which also uses the BeforeUpdate preceedure. Anyone done this/know how to do it? Private Sub Form_BeforeUpdate(Cancel As Integer) ' This procedure checks to see if the data on the form has ' changed. If the data has changed, the...