0

All,

I have an issues form in a database (MS Daily log) and when you fill in the form it save the data into an issues table. Everytime you do this it gives each issue an ID number (auto number).
Basically I want to fill in the form then before clicking next I would put another button on the form and when clicked it copied the data I just added to a table in another database (Helpdesk Log). The I can click next and goto the next record and carry on.

Any ideas please as its driving me mad.

Thanks

MArtin

3
Contributors
9
Replies
10
Views
9 Years
Discussion Span
Last Post by mrugeshm
0

it is kind of. I dont want every entry I make into the form to be copied across to 2 databases. I want it so that I can choose after I fill in the form whether I want to copy to to the other database or not. Thanks

0

the form is just an access form and im doing the whole database in access 2003.
Does my first post above help?
Thanks

0

i would suggest to post in the access forum then

also what trouble are you having? you can't insert into your database then another database as well?

0

I can insert into the database the form is on but its the copying that record then to the other database

0

Hi all ,

i need help transfer data from one database to another databse, by using query in vb.net application. help me here to solve this problem

mrugesh

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.