I have an Access 2003 database (All Employees.mdb) that I’m working on. It has a table (Employee List) with 3 fields (Name, User Name, Password) and a record for each employee in the office. There is also a form (Employee Info) which displays this information for the user. On the form is a button (Create Profile).
What I am trying to accomplish using VBA/ADO is that when the user clicks the Create Profile command button from the Employee Info form Access creates a new database (Employee Profile.mdb) in a different folder (C:\profile\) with a single table (User Profile) with the same 3 fields as the Employee List table (Name, User Name, Password) but containing only the current record selected/displayed on the Employee Info form at the time the button is clicked. I don't want it to open the new database nor do I want it to close the one that's already open.
Any help?
What I am trying to accomplish using VBA/ADO is that when the user clicks the Create Profile command button from the Employee Info form Access creates a new database (Employee Profile.mdb) in a different folder (C:\profile\) with a single table (User Profile) with the same 3 fields as the Employee List table (Name, User Name, Password) but containing only the current record selected/displayed on the Employee Info form at the time the button is clicked. I don't want it to open the new database nor do I want it to close the one that's already open.
Any help?
