Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / June 2006

Tip: Looking for answers? Try searching our database.

Seeking simplest, most straightforward process for creating & populating a database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MLH - 02 Jun 2006 22:38 GMT
Would like to create a database named 20060602Data.mdb
and populate it with the data in 31 local tables in the current
running database. I would like to do it all with a single button
click. Was wondering if someone knew of suitable sample
code in A97 HELP.
rkc - 02 Jun 2006 23:19 GMT
> Would like to create a database named 20060602Data.mdb
> and populate it with the data in 31 local tables in the current
> running database. I would like to do it all with a single button
> click. Was wondering if someone knew of suitable sample
> code in A97 HELP.

Suitable sample code?

Open the Object Browser.
Select All Libraries from the top combo.
Type TransferDatabase in the textbox below it.
Hit the search button.
Select TransferDatabase from the right hand column.
Hit F1.
Read.

Repeat for CreateDatabase.
MLH - 03 Jun 2006 00:58 GMT
>Suitable sample code?
>
[quoted text clipped - 7 lines]
>
>Repeat for CreateDatabase.
Oops. I don't know how to bring up the object
browser icon on my toolbar. I can see in HELP
what its supposed to look like - its just not showing
in my toolbar.
rkc - 03 Jun 2006 02:08 GMT
>>Suitable sample code?
>>
[quoted text clipped - 12 lines]
> what its supposed to look like - its just not showing
> in my toolbar.

Open a code module. Hit F2.
MLH - 03 Jun 2006 21:59 GMT
Thx. Great examples & instructs.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.