By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,488 Members | 2,545 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,488 IT Pros & Developers. It's quick & easy.

TransferText Problem

P: 47
Hello Everyone,

Right now I have a macro set up to use a parameterized query with a transferText function. So when the user clicks on a button on the form they are prompted to enter a Stocking section. When they enter the section they would like and click ok, a csv file is generated for them.

Is there some way to have the user make a selection from a list box and click the export button and have the parameter automatically filled in for them using their selection from the list box and have that data exported?

Thanks.
Jul 16 '07 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,597
Hello Everyone,

Right now I have a macro set up to use a parameterized query with a transferText function. So when the user clicks on a button on the form they are prompted to enter a Stocking section. When they enter the section they would like and click ok, a csv file is generated for them.

Is there some way to have the user make a selection from a list box and click the export button and have the parameter automatically filled in for them using their selection from the list box and have that data exported?

Thanks.
  1. Replace the actual Parameter in the Criteria Row of the Query with the Absolute Path to a List Box on your Form as in:
    Expand|Select|Wrap|Line Numbers
    1. Forms![Your Form]![List Box Name]
  2. In the AfterUpdate() Event of the List Box, run the TransferText Method.
Jul 16 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.