Don Elliker
delliker at hotmail.com
Thu Sep 4 09:07:49 CDT 2003
I am trying to link to Word docs on-the-fly (these are screen captures and documents related to the main report data item). The process is; 1.) The user captures something they want to associate to the data item and saves in a folder as a .doc 2.) At that time, I save the path to the doc in a table along with the data item identifier. 3.) The user runs a report and I check the table to see if there are any related docs. 4.) If there are, I create a new ,temporary, report with an unbound OLE frame control that uses the path from the table to link to the doc. 1 control each, for as many docs as there are. Doesn't work...everything is fine until I try to use the Control.Action = AcOLELinked on the control I just created. Access tells me "2771- The Bound or Unbound Object you tried to edit does not contain an OLE object." Well...No Sh#T!! that's kind of the point of all this stinkin' code! The knowledge base says I can do this and does it just the way I'm doing it, with the exception that I am creating the report and the control on-the-fly. TIAM, _D Por Favor Senor,Que Paso?? "Things are only free to the extent that you don't pay for them".-Don Elliker >From: "Erwin Craps" <Erwin.Craps at ithelps.be> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "Access Developers discussion and problem >solving"<accessd at databaseadvisors.com> >Subject: RE: [AccessD] Automating excel >Date: Thu, 4 Sep 2003 07:53:40 +0200 > >You could open the file in excel from Access and read/evaluate line by >line from Access. >Saving to CSV will not help your datatype property. >Erwin > >-----Oorspronkelijk bericht----- >Van: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] Namens Charlotte Foust >Verzonden: woensdag 3 september 2003 22:09 >Aan: Access Developers discussion and problem solving >Onderwerp: RE: [AccessD] Automating excel > > >I'm not even sure you can do that, John. Excel has a nasty habit of >changing datatypes no matter what you want it to do. > >Charlotte Foust > >-----Original Message----- >From: John Colby [mailto:jcolby at colbyconsulting.com] >Sent: Wednesday, September 03, 2003 11:56 AM >To: AccessD >Subject: [AccessD] Automating excel > > >Has anyone ever automated Excel to save a spreadsheet as TRUE comma >delimited text? My issue is that a client's client sends them data. It >was comma delimited text. Now it's a spreadsheet. Spreadsheets SUCK >for data import since it is possible that the data will change datatypes >down the spreadsheet and that causes the import to fail without any >warning. > >If I can automate excel to export that same spreadsheet, I suspect that >the result would just be text in all cases and so that "datatype change" >issue would disappear. > >Has anyone ever done this? > >John W. Colby >www.colbyconsulting.com > > >_______________________________________________ >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 >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es