Hi guy's, how do i open another database and add data to a table but have the 2nd database not visible ?
db1 to open db2 and add data to to a table with the same field names thn close the database from a message box ie:
rsdb1 = etc etc
rsdb2 = etc etc
Do Until rsdb1.EOF
rsdb2 = rsdb1.Fields etc etc
If Msgbox("You have sucessfully updated db2, Do You want to view the updates or close db2 ?") = vbNo Then
DoCmd.cancel
Else
close db2
End IF
I haven't actually coded this yet but hoping to very shortly
much appreciated