J
Joe
Hi, I am trying to create a label printing database for my company,
and I've run into problems.
I have a text box on a form that I am tying to a query, that will
eventually run into a report. The database I am pulling from looks
like this:
Vendor No. Item No. DESC1
DESC2 UM WH
1 10203 1 1/4" I.S. DIA PIPE LF 1
MISC 83390 STAY WARM HEAT PACK (PACK OF 3)
PK 1
MISC 84807 5 IN 1 PAINTRS TOOL PAINTERS TOOL (5BX)
EA 1
MISC 169154 OIL DRY 40#
BAG BG 1
I will be entering numbers into the text box, and pulling from the
"Item No." fields (which is set as a "text" field because some of the
item numbers contain letters). I want to be able to enter "10203
83390" (either spaces or commas delimiting) and have the final report
display both entries. I am very rusty at Access and Visual Basic atm,
but I know this can be done. Any ideas?
Also, if I had a command button that was going to do something
differently depending on an option group button that was checked, is
there a way to do that without hand-coding "If/Then"s for the button?
and I've run into problems.
I have a text box on a form that I am tying to a query, that will
eventually run into a report. The database I am pulling from looks
like this:
Vendor No. Item No. DESC1
DESC2 UM WH
1 10203 1 1/4" I.S. DIA PIPE LF 1
MISC 83390 STAY WARM HEAT PACK (PACK OF 3)
PK 1
MISC 84807 5 IN 1 PAINTRS TOOL PAINTERS TOOL (5BX)
EA 1
MISC 169154 OIL DRY 40#
BAG BG 1
I will be entering numbers into the text box, and pulling from the
"Item No." fields (which is set as a "text" field because some of the
item numbers contain letters). I want to be able to enter "10203
83390" (either spaces or commas delimiting) and have the final report
display both entries. I am very rusty at Access and Visual Basic atm,
but I know this can be done. Any ideas?
Also, if I had a command button that was going to do something
differently depending on an option group button that was checked, is
there a way to do that without hand-coding "If/Then"s for the button?