Stuart McLachlan
stuart at lexacorp.com.pg
Wed Feb 11 18:29:34 CST 2009
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