 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / December 2007Notepad Records
How do I pull records from Notepad...for example, pull records from notepad where field criteria matches a selection from a form list so I can see a shot of a total amount before selecting another criteria from the listbox.  SignatureGator Assuming your Notepad file is arranged in columns so it can import correctly, use the TransferText method. SignatureDave Hargis, Microsoft Access MVP > How do I pull records from Notepad...for example, pull records from notepad > where field criteria matches a selection from a form list so I can see a shot > of a total amount before selecting another criteria from the listbox. I'm not sure how to do this...any help? "For a fixed-width text file, you must either specify an argument or use a schema.ini file, which must be stored in the same folder as the imported, linked, or exported text file. To create a schema file, you can use the text import/export wizard to create the file." SignatureGator > Assuming your Notepad file is arranged in columns so it can import correctly, > use the TransferText method. > > > How do I pull records from Notepad...for example, pull records from notepad > > where field criteria matches a selection from a form list so I can see a shot > > of a total amount before selecting another criteria from the listbox. Yes, you use the Import/Export wizard. It would be File, Get External Data, Import. When you get the file dialog, select Text Files and navigate to the file. When the Import wizard opens, click on advanced. There you can choose the columns to import, set their data types, and choose whether to import each column. When that is done, click on Save As and save it with a name. Then in the TransferText method, you identify the specification name. Once that is done, you can code the TransferText and use the spec name. SignatureDave Hargis, Microsoft Access MVP > I'm not sure how to do this...any help? > [quoted text clipped - 9 lines] > > > where field criteria matches a selection from a form list so I can see a shot > > > of a total amount before selecting another criteria from the listbox. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.