Search results

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.

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.

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...

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

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...

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

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!

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

Thank you @theDBguy worked like a charm! :)

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...

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

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.

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

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...

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 :)

Hello, I understand I can highlight a field with conditional formatting but I am looking to asterisk fields based on criteria of the field. Ex. I have a text box txtNumber If txtNumber <> between 3 and 5, then I would like to display the Number with an * next to it, otherwise just the number...

So, I'm trying to take the information from that Totals query....and update the CheckStub record. Thoughts on how to do that?

So, I'm trying to take the information from that Totals query....and update the CheckStub record. Thoughts on how to do that?

I have the following query that I am trying to get a sum of deductions for a PayPeriod and update the CheckStub record with the totals. I am receiving the error: "Operation must use udatable query" when executing the following query. Any help would be much appreciated! UPDATE CheckStubInfo...

Thank you so very much! I've been starring at this code for hours! DUHHHHHHHHH moment for me!