[AccessD] IMPORT THE FORM

Ha! And who is the one who has been drinking.
I had NO error.  Did you read somebody elses posting and then replied to me?
It all went a dream.  Worked fine.  Did NOT "open with an error" - not my
words....oh, yes they were, weren't they...sorry, meant to say "without an
error"  grin...big grin...I take it all back...it is working GREAT.


Ha! I am on my 3rd, you?

Ps. Creating Tables in code...
http://msdn.microsoft.com/en-us/library/aa258255(SQL.80).aspx

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: 11 February 2009 21:37
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] IMPORT THE FORM

ROTFL.  And you are sure the error is not drink related?

8~o

"Opened with an error" is kind of nebulous though.  I have intentionally
left out the error handling 
so as to not obscure the good stuff and also because without an error
handler, the code stops on the 
exact error line.

What is the error line and what is the module?

John W. Colby
www.ColbyConsulting.com


Max Wanadoo wrote:
> Yeah,
> 
> All worked fine John.  I didn't change anything.  Right as you put.  Used
> the import routine from the IW and had the path set up the same as yours
so
> didn't have to change a thing. Once I had renamed my clsCtlCbo module it
> compiled straight off and the form opened with an error.
> 
> Dont know what to do next but as the next drink will be my third and it is
> getting late I wont be doing much more tonight except skulking and
replying.
> 
> Cheers
> 
> Max
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: 11 February 2009 21:13
> 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