Recent content by TomProff

Hey, thanks, I have looked at the format option. I'm not entirely sure how to and where to implement it into the code. Also i only want the new "barcode" numbers formatted in this way.

Hi all, I'm relatively new to vba in Access and would approctae any help anyone may be able to offer. I have the following vba code in my database, in order to add new records based on the last number in the table. Private Sub PopulateDataGen_Click() Dim barcodeLim As Long Dim...

No Worries Private Sub BarcodeMuseum_AfterUpdate() If DLookup("Barcode", "Data_Artifact", "Barcode = " & Me.BarcodeMuseum) = True Then DoCmd.OpenForm "Data_Artifact preview" End Sub

Thank you, the problem Im having is that the after update event is not firing. It works if i get it to open a MsgBox but as soon as any other code is in there nothing happens.

Hi all, I'm relatively new to this, so this might be a silly question. I have one table (Data Table). I have a form that it used to input some of the data into the table, in this form is an ID number. I need it so that when a user inputs an ID number into this form, it checks whether or not...