Max Wanadoo
max.wanadoo at gmail.com
Wed Feb 11 16:17:42 CST 2009
That is good to hear. I started smoking at the age of 55 - really! I stopped a year ago last week - really! Why I ever started heaven knows but I am no better off - the divorce lawyers just hold their hands out (bastards!). I do not drink TOO much, but sometimes I do. Maybe once or twice a week but never daily and don't need it, just like it. Not like cigs - there were bloody addictive. They are drugs no doubt about it. Should be outlawed - ha! See what you're doing to me! I am dropping into the Western Lingo...<g> > I am thrilled that "it is working GREAT"! That is what I work for. Me too. The best kick I get at work is when I hear "thanks Max that's really great". So are you. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: 11 February 2009 22:04 To: Access Developers discussion and problem solving Subject: Re: [AccessD] IMPORT THE FORM > 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. >>> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com