Need to take 1 column of data from a report and export to a text file (notepad)

[KingOf206]

I have a picture of a report that I generate on a daily basis. I need to extract only 1 column of data from it. The far right column of data (the AVID #'s) is what i need to extract and I need it sent directly to a text file (sent to notepad).

Right now the only work around I have i sending the entire report to excel, then copying the avID #s and only then can i paste them into a notepad. this is a hastle of a work around, when i feel like there is some easy way I am missing.

Is anyone familr with how ot do this? Please help! Thanks again!

[JoeM]

Is your Report based on a query or a table?
How I would approach it is to create a new query that uses the same Data Source as your Report, but only lists/shows the one column you want. Then do the export from the query, not the report.

[KingOf206]

I have this report based off a query (that includeds criteria, the criteria I have to enter is listed at the top of the report). The issue I have though Is that I need to generate the text file from this report. the reson so is because I have this dataase setup for users to work on. I only give them access to reorts and forms. so I would have to have it generate form one of the 2.

Ideas?

[JoeM]

You can create a command button on a Form that will export the data you want.

I have done stuff like you have said. If you use a Selection Form, where they enter their criteria there, you can "bind" those criteria selections to a table, and make use of that table in your other queries (so that they run based off of the same criteria).
Or alternatively, you could use their Criteria selection to build the SQL code for your queries on-the-fly, and apply the SQL code to pre-existing queries you have set up.

[KingOf206]

Is it possible to put this "command button" on the report it self? And if it is, what command would I use? I hav enot been able to do it thus far...

You can create a command button on a Form that will export the data you want.

I have done stuff like you have said. If you use a Selection Form, where they enter their criteria there, you can "bind" those criteria selections to a table, and make use of that table in your other queries (so that they run based off of the same criteria).
Or alternatively, you could use their Criteria selection to build the SQL code for your queries on-the-fly, and apply the SQL code to pre-existing queries you have set up.

[JoeM]

How are they entering the Criteria for the Report? You cannot make entries directly on your report, right?
As far as making the command button, take a look at the Macros section, and you can create a Macro to export a query/table to Excel using the Transferspreadsheet command. You just create the Macro or VBA to do that, and have the command button run that Macro or VBA code.

[KingOf206]

Correct. I have the Report based of a query that asks for the informaiton that is pictured at the top of the report. No, entries cannot be made directly on the report. I do not know VBA. I have tried doing in using a macro but have not been able to. do i need to base it off a new query?

[JoeM]

I have the Report based of a query that asks for the informaiton that is pictured at the top of the report.

Create a bound from that asks that for information. Since that criteria information would then be stored in a table, you can use it in other queries, reports, forms, etc.
So you could have them fill out the criteria, and then click a single command button which would then run a report and export a query.

[KingOf206]

What I have done is create another button on the report that will run a different query that uses the same criteria as the report. However, when I do export that data it goes to a text file but it has all these "extra" formatting lines. SEE ATTACHED IMAGE.

I want to export it so it shows DATA only, so that the numbers are the only thing on the page (if possible I would also like the Header to NOT appear, but I can deal with that, just not all the other ofmratting lines.)

[JoeM]

Are you exporting the query or a report?
Are you using the TransferSpreadsheet or TransferText action?

[KingOf206]

aT FIRST i WAS EXPORTING FROM THE query. I now have a report that is generated from a query, I am SOOOOoooo close. but it is still not right. I have got rid of all the formatting lines but now I have all these random spaces in the note pad. Is there some other formatting changes I can do to make things linear?

right now I have this:

But I want my data to export like this:

[JoeM]

Can you post all the arguments you are using in your Macro?

[KingOf206]

I am not using a macro. I created a 2nd queary that uses the same criteria as the current report I use, however the only informaiont that I have to "appear" (show) is the AV ID #'s then i have created a 2nd report (AV-ID list) that is based of that same queary that just generates the numbers. I added a button to the Report 1 (the one which I currently use) so that it runs the AVI ID list report and sends that data to a text file. That is when all the formatting gets screwed up like the picutrres above. DId that answer your question? if not please let m eknow so that i cna clearify.

[JoeM]

I added a button to the Report 1 (the one which I currently use) so that it runs the AVI ID list report and sends that data to a text file. That is when all the formatting gets screwed up like the picutrres above. DId that answer your question? if not please let m eknow so that i cna clearify.

Behind every button, there is a Macro or VBA code. What is the code/Macro that the button is running?

[KingOf206]

yes you are right. Here is what I have.