Recent content by wmdavidwynn

KevCri response Here's what I found out. The TransferText method does not let you use STORED PROCEDUREs or QUERIES as the stDocName.... it accepts only tables. If you working in an Access project (.adp), as am I, you're stuck. Here's what I did. I split the actions into 2 parts. I created an...

The exact messages If I associate the name of the stored procedure in the 'Transfer Text' method, the message is "Microsoft Access can't find the object 'File Submittal'. If I put in the name of the table, the query doesn't select the required and the 'Transfer Text' method creates an output...

Still having difficulties Scott, thanks for your reply. I changed the criteria in the query to '=Forms!Text_File_Out!invoicedate' and '=Forms!Text_File_Out!contractnumber' which are my selection columns. I have a Create Output File control that calls the query after I accept the input values in...

This question refers to an Access 2003 project. I'm trying to create a fixed length text file as a result of a query using the 'Transfer Text' method. I have a query that prompts for two input parameters. These will select the records that I want to output. As it displays the correct records on...

Can you direct me to a good document that explains what those input mask characters really do in the situation? The instructions within Access really stink and are not very helpful for troubleshooting.

I want a quick-n-dirty method of filling char or numeric fields on a form with leading zeros. Can I do that without VBA?