Text box string

  • Thread starter Thread starter Jerry (the latin men)
  • Start date Start date
J

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
 
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])
 
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.

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


Jerry (the latin men) said:
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
Click to expand...
Click to expand...
 
Try this --
Like [Forms]![Main_Form]![TTYPE] & "*"
--
KARL DEWEY
Build a little - Test a little


Jerry (the latin men) said:
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.

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


Jerry (the latin men) said:
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
Click to expand...
Click to expand...
Click to expand...
 
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.
Click to expand...

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

will work too.
 
IT WORKED!! You are a life saver.
Thanks a lot!!!

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


Jerry (the latin men) said:
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.

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