Text box string

[Jerry (the latin men)]

How do I set a string in my text box.
I have a unbound form where I place two text boxes. I need to setup a string
for each one and then place them in my query parameter.
Also, I need to know how to put this parameters in my query.

Thanks in advance

 

[KARL DEWEY]

Just create the textboxes, no string function required.
In the query refer to the textboxes like this --
[Forms]![YourFormName]![TextBoxName]
If you are entering a date in the text box then do this --
CVDate([Forms]![YourFormName]![TextBoxName])

 

[Jerry (the latin men)]

Thanks it worked.
Now I have another issue. I have another field on my queries named
"trasaction type". On that field under criteria I have
"[Forms]![Main_Form]![TTYPE]" Is there any way to tell access that whenever I
leave blank my texbox [TTYPE] to show me all the records in this field.

Just create the textboxes, no string function required.
In the query refer to the textboxes like this --
[Forms]![YourFormName]![TextBoxName]
If you are entering a date in the text box then do this --
CVDate([Forms]![YourFormName]![TextBoxName])

--
KARL DEWEY
Build a little - Test a little

How do I set a string in my text box.
I have a unbound form where I place two text boxes. I need to setup a string
for each one and then place them in my query parameter.
Also, I need to know how to put this parameters in my query.

Thanks in advance

 

[KARL DEWEY]

Try this --
Like [Forms]![Main_Form]![TTYPE] & "*"
--
KARL DEWEY
Build a little - Test a little

Thanks it worked.
Now I have another issue. I have another field on my queries named
"trasaction type". On that field under criteria I have
"[Forms]![Main_Form]![TTYPE]" Is there any way to tell access that whenever I
leave blank my texbox [TTYPE] to show me all the records in this field.

Just create the textboxes, no string function required.
In the query refer to the textboxes like this --
[Forms]![YourFormName]![TextBoxName]
If you are entering a date in the text box then do this --
CVDate([Forms]![YourFormName]![TextBoxName])

--
KARL DEWEY
Build a little - Test a little

How do I set a string in my text box.
I have a unbound form where I place two text boxes. I need to setup a string
for each one and then place them in my query parameter.
Also, I need to know how to put this parameters in my query.

Thanks in advance

 

[John W. Vinson]

Thanks it worked.
Now I have another issue. I have another field on my queries named
"trasaction type". On that field under criteria I have
"[Forms]![Main_Form]![TTYPE]" Is there any way to tell access that whenever I
leave blank my texbox [TTYPE] to show me all the records in this field.

=[Forms]![Main_Form]![TTYPE] OR [Forms]![Main_Form]![TTYPE] IS NULL

will work too.

 

[Jerry (the latin men)]

IT WORKED!! You are a life saver.
Thanks a lot!!!

Try this --
Like [Forms]![Main_Form]![TTYPE] & "*"
--
KARL DEWEY
Build a little - Test a little

Thanks it worked.
Now I have another issue. I have another field on my queries named
"trasaction type". On that field under criteria I have
"[Forms]![Main_Form]![TTYPE]" Is there any way to tell access that whenever I
leave blank my texbox [TTYPE] to show me all the records in this field.

Just create the textboxes, no string function required.
In the query refer to the textboxes like this --
[Forms]![YourFormName]![TextBoxName]
If you are entering a date in the text box then do this --
CVDate([Forms]![YourFormName]![TextBoxName])

--
KARL DEWEY
Build a little - Test a little


:

How do I set a string in my text box.
I have a unbound form where I place two text boxes. I need to setup a string
for each one and then place them in my query parameter.
Also, I need to know how to put this parameters in my query.

Thanks in advance