Recent content by spet

  1. S

    Writing a query to a text file

    Thank you all for your help! I sure do find this site helpful! @Pat Hartman, I hope I don't have to either. Yes, this is very custom and what is being requested.
  2. S

    Writing a query to a text file

    Here is a screen shot. So you can see on my Header records, I want position 01 to consist of "01". On my Detail Records I want Position 0 - 3 to consist of "FirstName" and positions 4-9 to consist of "LastName". I hope I'm making sense here.
  3. S

    Writing a query to a text file

    More like this: (My Header Records and Control Records will be different) BUT, my detail will be the same. So, I'm think creating 3 different queries to populate the information. EX: 01 123 XXX 456 YYY 01 234 FFF 789 XXX John Smith 0123456789 01 987654321 Bob Marley 2345678912 12...
  4. S

    Writing a query to a text file

    ****My queries don't all consist of the same amount of fields or the same data****
  5. S

    Writing a query to a text file

    So I've created the export spec to use with the TransferText. See below: strFile = "C:\TestFile.Txt" DoCmd.TransferText acExportFixed, "specACHFileHeaderRecord", "NACHAFileHeaderRecord", strFile BUT I have multiple header records that need to be wrote (that are produced off of different...
  6. S

    Writing a query to a text file

    Also, I have multiple queries I want to send to that file. Is there anyway to open it and append after creating?
  7. S

    Writing a query to a text file

    Oh man, this is way easier than what I was trying to do. Is there anyway to export the results with fixed width to keep my current formatting? Another program will be reading and uploading this information? Thank you both!
  8. S

    Writing a query to a text file

    Good Morning, I am looking to write the results of a query to a text file (first creating the text file) I have never done this before and am very confused with some of the stuff I'm finding online. Can anyone help me with the basic format of this? Thank you in advance
  9. S

    Make table query to format fields

    Thank you @theDBguy worked like a charm! :)
  10. S

    Make table query to format fields

    Hello, I have a make table query that formats data to a table so I can export it to a text file. Currently I am formatting [Field1] like this: Format([Field1]*10,"00000000") outputs: -00030000. I need this field to only be 8 characters long including the negative(-) sign. Is there a correct way...
  11. S

    Make table query and then using export specs to export the table to text file.

    Thank you so much theDBguy! Worked like a charm, exactly what I as looking for.
  12. S

    Make table query and then using export specs to export the table to text file.

    I will just multiply my fields by 10 in my make table query. Still not sure how to get a spaces in front of these during the output to text file.
  13. S

    Make table query and then using export specs to export the table to text file.

    I will represent my blank spaces in the expected output of the text file with S, so I would like my output to be. Field 1 pulling from my table as 14.25 and Field 2 pulling from the table as .25. I hope this makes sense? S1425SSSS25
  14. S

    Make table query and then using export specs to export the table to text file.

    Hello, I have a make table query that I then created a specification to export it to a text file. Some of the fields contain decimal places, but the business I am creating the text file for would like to elimanate all decimals and right align the numeric values. Thank you in advance! Example...
  15. S

    Mark fields in a report with an * based on certain criteria.

    Thank you all! txtNumber was actually intNumber and the error I was receiving was trying to convert the integer to a string. I went ahead as June suggested to create a seperate textbox and it works great! Thank you :)
Top Bottom