Recent content by db777

Two Access files with the same name can't exist in the same directory. You'll need to create a new directory or rename one of the files.

Maybe this.... Hi elliot315, Database attached that generates security codes that are only valid for the hour that they were created on the day they were created. Also checks to see if the database is being copied to multiple locations and requires a validation code for each computer the...

Thanks RuralGuy. All your help is much appreciated.

Thanks again RuralGuy. Amended the code as per your suggestion (error handling to come later - just proof of concept right now ;)). What I have noticed though is that if I create a new record via the form, then go back and edit the record the BeforeUpdate event triggers again creating duplicate...

Thanks RuralGuy. Was coming at it from the wrong angle - the BeforeUpdate suggestion did the trick. For anyone following along the code below sorted the problem (replace the [text] with your own tables/fields/forms): 'Declare variables Dim db As DAO.Database Dim rs As DAO.Recordset 'Open...

Hello all, I've scoured the forum for this, but none of the items seem to be what I'm after (or I can't quite understand them so don't realise they are what I am after!). I'll outline my problem and what I think I need to do. I have a parent form that contains a subform (displayed as a...