Search results

Apologies for the long wait for a response and thanks for all the tips and fixes. The database is now live. Admittedly the code was harvested from the existing original database which threw a wobbly and my fixes holding it together (cue many frowns). That database was built in 2005 long before...

Many Thanks for your helpful comments. By commentating out the line On Err I have managed to debug and fix most of the code. and it is now checking for null values throughout Now there is a check for unique values in the UserName if this is not met it throws up a MsgBox asking for a different...

Ok heres the code behind the button to add a record it checks all the fields are populated correctly and if one field is unique (UserName) it lets the user know this record has been added. If not it tells them were they went wrong. No compile errors brilliant I thought However on clicking this...

As is customary with forums it's time to introduce myself before i start seeking advice Although i use Access day to day i am quite a noob (for want of a better word) when it comes to actaully building a Access database as im sure your'll see over the coming days/weeks/months