As macropod suggests, this would be a lot easier to do as a mail merge.

FWIW, your code has obvious errors which cause compilation errors but I can't test to iron out any other issues related to the things we can't see there.

DefaultTableBehaivor is not spelt correctly and needs to say DefaultTableBehavior
strPassword -InputBox("Password Please?", "Lock Forms Password") should have an equals sign instead of the minus

Add Dim strEmps As String, strPath As String to the start of the Sub Connect macro



Public connEmp As ADODB.Connection - this line fails to compile because you haven't added a reference to one of the Microsoft ActiveX Data Object x.x Library

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Hi macropod I'm required to do it the hard way with code
Guessed I made the changes you suggested the code doesn't give me that error any more but now I get the following error:
Run Time error 91 Do you have anymore advice?? I have attach the word document with the changes and the access database as well. Thank you

here are the files

Attached Files

243CCA04.zip (47.8 KB, 10 views)