Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Can I copy a Form?
0 views
Skip to first unread message
Pat
Feb 26, 2003, 10:30:06 AM2/26/03
to
Have another database - same layout - can I copy a Form (that I spent much
time on) and use it on a new Table?
time on) and use it on a new Table?
Thank you.
Roger Carlson
Feb 26, 2003, 10:59:00 AM2/26/03
to
Sure, in the new database, go to File>Get External Data> Import and browse
to your old database. Select the form you want, and it will import it to
the new database. If the form is based on a query, you should import the
query as well. If the table in the new database is different, you will have
to modify the record source for the new table name.
to your old database. Select the form you want, and it will import it to
the new database. If the form is based on a query, you should import the
query as well. If the table in the new database is different, you will have
to modify the record source for the new table name.
--
Roger Carlson
www.rogersaccesslibrary.com
"Pat" <pjo...@bicycling.com> wrote in message
news:O6yV3va3...@TK2MSFTNGP09.phx.gbl...
Tom Ross
Feb 26, 2003, 5:02:14 PM2/26/03
to
If your form contains any embedded VBA code it can get corrupted and cause
you headaches with a 'may have lost network connection'error
you headaches with a 'may have lost network connection'error
To avoid this do one of two things
AS SOON AS you import the form, COMPILE your database. DO NOT open the
form (or anything for that matter) until you have compiled your data base
or
Remove the code before you import the form (cut it and paste it into a
notepad document). Then paste it into the imported form. then COMPILE just
to be sure.
Make a backup of the new database before you do it just in case.
"Roger Carlson" <Roger....@spectru-health.org> wrote in message
news:eHpQ6$a3CHA...@TK2MSFTNGP10.phx.gbl...
0 new messages