[AccessD] IMPORT THE FORM

jwcolby jwcolby at colbyconsulting.com
Wed Feb 11 16:03:34 CST 2009


 > Ha! I am on my 3rd, you?

I had to quit.  Let me see... Cinco de Mayo 1986.  No more nothin, including tobacco.  I am a 
caffein kinda guy now.

I am thrilled that "it is working GREAT"!  That is what I work for.

John W. Colby
www.ColbyConsulting.com


Max Wanadoo wrote:
> 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.
>>>



More information about the AccessD mailing list