[AccessD] IMPORT THE FORM

MACE, Terry terry.mace at baesystems.com
Wed Feb 11 19:08:25 CST 2009


It appears that Access97 doesn't support this method of saving or
importing forms. It tries to create a copy of the form with ASCII
characters. 

Fortunately I also have Access2003 on my computer which is only supposed
to be for a specific application, so I'll switch over to that where the
import does work.

Regards
 
Terry Mace
Logistics Support Officer & Maintenance Supervisor
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Thursday, 12 February 2009 11:30 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] IMPORT THE FORM

Trying editing the first two lines to a lower Version Number:

Version =xx
VersionRequired =xx

JC's form uses 19, I don't know what number would be required for
Access97 because this 
is not the Access Version Number.  


On 12 Feb 2009 at 10:47, MACE, Terry wrote:

> JC,
> 
> It doesn't work for me. I am using Access97 here at work and get the
> following error:
> 
> "Error encountered at line 2.
> This object was created with a newer version of |9 than you are
> currently running."
> 
> Regards
>  
> Terry Mace
> Logistics Support Officer & Maintenance Supervisor
>  
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Thursday, 12 February 2009 8:13 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] IMPORT THE FORM
> 
> I need someone to verify that they successfully imported the form
using
> this methodology.  I did it 
> myself, but that means nothing as we all know.
> 
> Thanks,
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> 
> jwcolby wrote:
> > This email will document how to import a form into your database
that
> I provide to you.  WARNING! 
> > If you have modified frmDemoCtls to be the way you want it, rename
the
> form before performing the 
> > following.
> > 
> > *	Cut and paste the form definition from the email with that stuff
> into a text file that you can 
> > deal with.  As an example I used the path 
> >
>
"c:\Users\jwcolby\Documents\ClassesAndEventsDemo\frmDemoCtlsImport.txt".
> > *	In your database click Insert / Module and immediately save it
> as basImportForm.
> > *	Insert the following code into the module:
> > 
> > Function ExportForm(strFrmName As String, strExportPath As String)
> >      Application.SaveAsText acForm, strFrmName, strExportPath
> > End Function
> > 
> > Function ImportForm(strFrmName As String, strImportPath As String)
> >      Application.LoadFromText acForm, strFrmName, strImportPath
> > End Function
> > 
> > These functions are just wrappers to VBA code that allows importing
> and exporting forms to / froim 
> > text files.
> > 
> > *	Compile and save basImportform.
> > *	In the debug window cut and paste or type in the following
> (modifying the path to your own) and 
> > then hit enter:
> > 
> > ImportForm "frmDemoCtls",
>
"c:\Users\jwcolby\Documents\ClassesAndEventsDemo\frmDemoCtlsImport.txt"
> > 
> > *	Click on the form tab of the database and open frmDemoCtls.
> > *	Notice that the form probably looks different than your old
> form.
> > *	Tab through the form and notice that the text and combo controls
> change color as they gain / lose 
> > the focus.
> > 
> > I will use this method of feeding you forms in the future.  If you
> have any questions or something 
> > does not work as planned, let me know.
> > 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> "Warning:
> The information contained in this email and any attached files is
> confidential to BAE Systems Australia. If you are not the intended
> recipient, any use, disclosure or copying of this email or any
> attachments is expressly prohibited.  If you have received this email
> in error, please notify us immediately. VIRUS: Every care has been
> taken to ensure this email and its attachments are virus free,
> however, any loss or damage incurred in using this email is not the
> sender's responsibility.  It is your responsibility to ensure virus
> checks are completed before installing any data sent in this email to
> your computer."
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
"Warning:
The information contained in this email and any attached files is
confidential to BAE Systems Australia. If you are not the intended
recipient, any use, disclosure or copying of this email or any
attachments is expressly prohibited.  If you have received this email
in error, please notify us immediately. VIRUS: Every care has been
taken to ensure this email and its attachments are virus free,
however, any loss or damage incurred in using this email is not the
sender's responsibility.  It is your responsibility to ensure virus
checks are completed before installing any data sent in this email to
your computer."






More information about the AccessD mailing list