Re: transferspreadsheet

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Create a form that has a text box on it.

Change your 4 queries to point to that text box. You do this by using
Forms!NameOfForm!NameOfTextBox instead whatever you've currently got inside
the square brackets as the criteria.

Have a button on your form that uses TransferSpread*** 4 times.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"janschutz@xxxxxxxxxxxxxxxxxxx"
<janschutzmarinetraveliftcom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:51206BAA-E88D-400D-B9B9-FFEB3B5FD585@xxxxxxxxxxxxxxxx
1. I have a four separate Access queries that have an ask
parameter.

2. I created a macro that takes each query and exports it to one
Excel file with four tabs.

3. I use the transferspread*** in Access for the macro.



The question I have is this I have seen were you suggested to a user
asking
that the user that is trying to run the macro not to have to answer the
parameter four separate times. Could you explain the steps?





.

Quantcast