Search results

Please help. I've inherited a database which uses staff numbers as the primary key. Having had these numbers for 30 plus years it was figured that this was a pretty good unique identifier. That was until 1st April (no it wasn't an April Fools prank) when all the finacial systems changed and we...

I have written a database to track Errors, New Requirements and Requirement changes in the software code our programmers develop. I have secured the database using the in-built Security Level Wizard using the "Full Permissions" group for those I trust not to fiddle and the "Full Data Users" for...

This Forum is a God Send and everyone is so helpful. Ghudson's Audit Trail code saved me many hours of hair pulling :) Anyone out there who may be able to help with my Audit Trail Query? Anyway, I've been developing a database for the last 2 weeks (night & day it seems!) to track "bugs" found...

This probably should be really easy but I can't get it to work. My main form has a number of fields which are Combo boxes drawing their values from tables. In event that the required value is not available I need to be able to DblClick on the field to open the source table to add the new value...

re. ghudson's audit trail code... Absolutely brilliant, thanks. DOH! It would help if I included the code I was using! Function AuditTrail() On Error GoTo Err_Handler Dim MyForm As Form, C As Control, xName As String Set MyForm = Screen.ActiveForm 'Set date and current user...

Help! Very Very new to VBA & totally out of my depth!!!! I have an automatically generated reference field (text box) within the main data entry form of my database. AR/2008/### which is generated by the code below. The 'AR' is constant for every record, the '2008' is generated from the...