Search results

Hi Pat, thank you for having a look at my database and for the informative response, I really appreciate that :) I would still want the save and maybe a cancel button but i'm unsure on how to add the save button since when I used: Private Sub Save_Record_Button_Click() DoCmd.RunCommand...

Hi, This is my database, I have removed the Macro to disable F5 and left in the macro changes that check if the textboxes are empty once the add record button is pressed. To reproduce the issue simply enter data into one of the textboxes in the form and press f5. This creates a record in the...

I used the Access wizards to create the form and the new item button so I don't know where the broken code might have come from :/ Is there a known problem with the wizards for either of the above functions?

Hi Pat, Everything else works fine, my button to create new entries works perfectly. It's just this f5 business that seems to sidestep my button and the logic behind it and create the record itself. I didn't know about f5 until my colleagued pressed it accidentally to reload the form and it...

Hi, does anyone know how to stop F5 reloading the form as its also adding an incomplete entry into the database? I have a seperate button to add records and dont want this functionality. Been at this problem for the last couple of hours :banghead: Kind regards!

Thank you both for your help and patience. As you can tell im still very new to Access and never liked VBA (much better with PowerShell :banghead: ) This is what I ended up with just encase its useful for anyone down the line: Private Sub Serial_Number_textbox_BeforeUpdate(Cancel As Integer)...

Sorry to continue being a pain. My table is called "Asset Database", my field name is "Serial Number" and my textbox name is "Serial Number textbox". Here is my code: Private Sub Serial_Number_BeforeUpdate(Cancel As Integer) If DCount("1", "Asset Database", "Serial Number=""" & [serial...

Hi arnelgp, thanks for your quick reply. I have tried adding the code you have supplied but am a little confused. I get the following error: Run-Time error 3075. Syntax error (missing operator) in query expression "fieldname=Serial Number'. I don't know what to put for the fieldname since...

Hi Guys, first time posting in this forum so let me know if im breaking any etiquette :) I have created an Access for to add new entries into a the main Access database. We have a filed that requires a unique value, but when I test this by trying to add an entry using the form and the same...