A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can you export a form from a database



 
 
Thread Tools Display Modes
  #1  
Old November 21st, 2009, 05:09 PM posted to microsoft.public.access.forms
Bob H[_4_]
external usenet poster
 
Posts: 161
Default Can you export a form from a database

I have an updated form with tabs for multiple forms in a database on 1
pc, which I would like to use on the same database on another pc. I know
you can export tables, but what about forms.

Thanks
  #2  
Old November 21st, 2009, 05:37 PM posted to microsoft.public.access.forms
fredg
external usenet poster
 
Posts: 4,386
Default Can you export a form from a database

On Sat, 21 Nov 2009 17:09:28 +0000, Bob H wrote:

I have an updated form with tabs for multiple forms in a database on 1
pc, which I would like to use on the same database on another pc. I know
you can export tables, but what about forms.

Thanks


If there is no linkage between the 2 PC's, why not just copy the form
and burn it to a CD, then transfer the CD to the 2nd PC and copy it
into the new database? Remember to then un-check the Form's Read only
Attribute.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
  #3  
Old November 21st, 2009, 07:00 PM posted to microsoft.public.access.forms
Bob H[_4_]
external usenet poster
 
Posts: 161
Default Can you export a form from a database

Yes I could do that if I knew how to get the form out of the existing
dbase. I know you can export tables, but can you export forms?

Thanks


fredg wrote:
On Sat, 21 Nov 2009 17:09:28 +0000, Bob H wrote:

I have an updated form with tabs for multiple forms in a database on 1
pc, which I would like to use on the same database on another pc. I know
you can export tables, but what about forms.

Thanks


If there is no linkage between the 2 PC's, why not just copy the form
and burn it to a CD, then transfer the CD to the 2nd PC and copy it
into the new database? Remember to then un-check the Form's Read only
Attribute.

  #4  
Old November 21st, 2009, 07:39 PM posted to microsoft.public.access.forms
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default Can you export a form from a database

There's an undocumented SaveAsText method (and a corresponding LoadFromText
method)

I talked about them in my February, 2005 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample
database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Bob H" wrote in message
...
I have an updated form with tabs for multiple forms in a database on 1 pc,
which I would like to use on the same database on another pc. I know you
can export tables, but what about forms.

Thanks



  #5  
Old November 21st, 2009, 07:44 PM posted to microsoft.public.access.forms
Bob H[_4_]
external usenet poster
 
Posts: 161
Default Can you export a form from a database

Update: I found out how to do it now.
Bob H wrote:
Yes I could do that if I knew how to get the form out of the existing
dbase. I know you can export tables, but can you export forms?

Thanks


fredg wrote:
On Sat, 21 Nov 2009 17:09:28 +0000, Bob H wrote:

I have an updated form with tabs for multiple forms in a database on
1 pc, which I would like to use on the same database on another pc. I
know you can export tables, but what about forms.

Thanks


If there is no linkage between the 2 PC's, why not just copy the form
and burn it to a CD, then transfer the CD to the 2nd PC and copy it
into the new database? Remember to then un-check the Form's Read only
Attribute.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:40 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.