One Click to Create a New Database
- From: "Michael" <Michael@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 18 Apr 2005 14:37:01 -0700
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 is open.
I've included all the important names (I think) in hopes someone can provide
me with some sample starter code. Any ideas?
.
- Follow-Ups:
- Re: One Click to Create a New Database
- From: John Nurick
- Re: One Click to Create a New Database
- Prev by Date: Re: Function HELP!
- Next by Date: Re: How to transfer my access query result .xls file to a FTP Serv
- Previous by thread: Function HELP!
- Next by thread: Re: One Click to Create a New Database
- Index(es):