DataBase - Can you export a form from a database
Asked By Bob H
21-Nov-09 12:09 PM
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
LoadFromText
(1)
Database
(1)
DougSteele
(1)
February
(1)
Formand
(1)
Linkage
(1)
fredg replied to Bob H
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
Bob H replied to fredg
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
Douglas J. Steele replied to Bob H
There is 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 replied to Bob H
Update: I found out how to do it now.
Bob H wrote:
reference application object of mdb opened with OpenDatabase DataBase I am looping through all access mdb's in a directory and changing all of of Macros but I cannot figure out how to reference the application object of the database I just opened. This code works fine for the current database if I add it a module and run it. How do I reference the application object of another database without creating a new app instance? Sub FixPathInMacros() Dim obj As AccessObject, dbs As Object obj.Name, "C: \ Temp \ " _ & obj.Name & ".txt" 'FixPath "C: \ Temp \ " & obj.Name & ".txt", _ 'LoadFromText acMacro, obj.Name, "C: \ Temp \ " & _ obj.Name & ".txt" End If Next obj End Sub to avoid creating a new app instance. - - Doug Steele, Microsoft Access MVP http: / / I.Am / DougSteele (no e-mails, please!) A DAO database object, such as is returned by the OpenDatabase method, does not *have* an Application object. it is just a representation of the database, with no Access application associated with it. I do not know if you can get
Corrupt Form - very complicated form - how to recreate. DataBase Office 2003 on Vista now - was Office on XP previously. On XP this form has it from the beginning is a monumental task. - - Regards Tom Access Forms Coding Discussions Application.LoadFromText (1) Application.SaveAsText (1) Office 2003 (1) Vista (1) XP (1) VB (1) MyFormName (1 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) On Mon, 2 Feb 2009 13:50:01 -0800, ThomasAJ Application.SaveAsText acForm, "MyFormName", "C: \ SomePath \ MyFormName.txt" Delete the form. Compact and repair the database to clean out any rubbish; it probably would help to decompile and compact again. Then again in the immediate window do Application.LoadFromText acForm, "MyFormName", "C: \ SomePath \ MyFormName.txt" Compile, compact again, and see if it gets a
Run report in one database from another database DataBase Is there a way to run a report that was built in one database from another database? I have created a fairly complex report in one database that the users of another database need to view, however, there is other functionality in the database with the report that these users should not have access to. I don't want
Link to Database - Password DataBase HI, I have two database in two different folder. One (Database A) of the folder contains all the tables only. Other one is where I use the database (Database B) everyday and the database is linking the other database that has all the tables only. I set the Database B linking to Database A