[Text Entry] and Macros

[Gaijintendo]

I have been using square brackets to prompt users for text entry e.g. [Enter
Thing Name:], in my queries.

Now I am hoping to combine a few queries in a macro and would like to know
if there is a way to use a single point of text entry for multiple queries.

I have tried searching for answers, but I don't know what the use of square
brackets is called.

Edit: I realised I had been pretty ignorant posting this in the General
area, any help appreciated!

 

[KARL DEWEY]

Use an unbound form with unbound textboxes for entry.
NOTE - The form must be open and data in the textboxes.

Refer to the textboxes in the queries like this --
[Forms]![YourFormName]![TextBoxName]
Or
Like "*" & [Forms]![YourFormName]![TextBoxName] & "*"

 

[Gaijintendo]

Thanks Karl,

So I can use that form to run several queries.
Can I just ask, is there a way to make it directly create excel files?
I can do DoCmd.OpenQuery as an event for the button, do you know how I would
then export an Excel file?

Sorry to pile on the questions.

Neil

Use an unbound form with unbound textboxes for entry.
NOTE - The form must be open and data in the textboxes.

Refer to the textboxes in the queries like this --
[Forms]![YourFormName]![TextBoxName]
Or
Like "*" & [Forms]![YourFormName]![TextBoxName] & "*"
--
KARL DEWEY
Build a little - Test a little

I have been using square brackets to prompt users for text entry e.g. [Enter
Thing Name:], in my queries.

Now I am hoping to combine a few queries in a macro and would like to know
if there is a way to use a single point of text entry for multiple queries.

I have tried searching for answers, but I don't know what the use of square
brackets is called.

Edit: I realised I had been pretty ignorant posting this in the General
area, any help appreciated!

 

[KARL DEWEY]

Check out macro - transferspreadsheet
--
KARL DEWEY
Build a little - Test a little

Thanks Karl,

So I can use that form to run several queries.
Can I just ask, is there a way to make it directly create excel files?
I can do DoCmd.OpenQuery as an event for the button, do you know how I would
then export an Excel file?

Sorry to pile on the questions.

Neil

Use an unbound form with unbound textboxes for entry.
NOTE - The form must be open and data in the textboxes.

Refer to the textboxes in the queries like this --
[Forms]![YourFormName]![TextBoxName]
Or
Like "*" & [Forms]![YourFormName]![TextBoxName] & "*"
--
KARL DEWEY
Build a little - Test a little

I have been using square brackets to prompt users for text entry e.g. [Enter
Thing Name:], in my queries.

Now I am hoping to combine a few queries in a macro and would like to know
if there is a way to use a single point of text entry for multiple queries.

I have tried searching for answers, but I don't know what the use of square
brackets is called.

Edit: I realised I had been pretty ignorant posting this in the General
area, any help appreciated!

 

[Gaijintendo]

Karl,

Thanks for all the help, and the advice on "commenting out" on the other
thread will be useful too!

Check out macro - transferspreadsheet
--
KARL DEWEY
Build a little - Test a little

Thanks Karl,

So I can use that form to run several queries.
Can I just ask, is there a way to make it directly create excel files?
I can do DoCmd.OpenQuery as an event for the button, do you know how I would
then export an Excel file?

Sorry to pile on the questions.

Neil

Use an unbound form with unbound textboxes for entry.
NOTE - The form must be open and data in the textboxes.

Refer to the textboxes in the queries like this --
[Forms]![YourFormName]![TextBoxName]
Or
Like "*" & [Forms]![YourFormName]![TextBoxName] & "*"
--
KARL DEWEY
Build a little - Test a little


:

I have been using square brackets to prompt users for text entry e.g. [Enter
Thing Name:], in my queries.

Now I am hoping to combine a few queries in a macro and would like to know
if there is a way to use a single point of text entry for multiple queries.

I have tried searching for answers, but I don't know what the use of square
brackets is called.

Edit: I realised I had been pretty ignorant posting this in the General
area, any help appreciated!