Access Database problem - Urgent

[Andy Poobar]

I have an access database that has 1 table in it and 1 form.

On the form I have a button to duplicate the record which is now duplicating everything on the form.
The problem I have, is that when I duplicate the record the date/time field to change to the current date/time and not be a duplicate of the last record.

I have attached a rar file of the database with 1 record in to show how it's bee done.

Any help will be very greatfully received.

Many thanks in advance.

Andy

[Andy Poobar]

Sorry, just read what I need again and missed a bit.

Also, in the picture part of the database I need to paste whatever is in the clipboard of the computer when I hit duplicate record.

Any help, please!!

[keifster]

Sorry - can't see the attachment because apparently I've been a bit of a naughty boy so I will have to go off what you've posted so far....

Clipboard: Access doesn't give much support for the clipboard object so you might have to use the sendkeys command to send a paste key sequence.
eg SendKeys "+{INSERT}"
will send SHIFT+INSERT to the control on the form (same as paste)

If you post the code which you have behind the duplicate button I will see what else there is to do.

[Andy Poobar]

The code at the back shows nothing about the paste, as this is a new piece of functionality that I want to add.

The sendkeys sounds like a good road to go down, my only problem, is how do I make sure that what I copy goes into the right bit. ie, the ole object bit??? and not a text box etc.

[keifster]

Before the SendKeys you should do a setfocus on the control

eg If you OLE Object control is called Pic then your code will look like this

Pic.SetFocus
SendKeys "+{INSERT}"

I would also put a DoEvents after the Sendkeys command otherwise you may find that your NumLock will be deactivated.