[Text Entry] and Macros

  • Thread starter Thread starter Gaijintendo
  • Start date Start date
G

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!
 
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] & "*"
 
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


KARL DEWEY said:
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


Gaijintendo said:
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!
Click to expand...
Click to expand...
 
Check out macro - transferspreadsheet
--
KARL DEWEY
Build a little - Test a little


Gaijintendo said:
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


KARL DEWEY said:
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


Gaijintendo said:
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!
Click to expand...
Click to expand...
Click to expand...
 
Karl,

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

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


Gaijintendo said:
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


KARL DEWEY said:
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!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top