G
Guest
Okay, I'm pasting here something from the post downunder. Following it is
another post. If anyone can help me with this, I'd be greatly appreciative
and it'll keep me from losing my hair before I turn 26!
Sprinks, you may be my only hope!!
POST NUMERO UNO::::
SPPPPRRRIIIINNNKKKS! I'm at like 80% where I hoped to be!!
Ok I did EXACTLY as you said. Now, when I open the form and select my line
and click the button, it pops up a little box called "Enter Parameter Value"
and the text says "Forms!frmReportCriteria!cboLineNumber" and it has a box
for me to type in. Now, let's say I put in "2" for line 2.
I click ok and BOOM, there it is...the highly coveted report that I could
only dream about before I met you, hahaha...it fills me with insane energy
and laughter and my assistant, in her lovable and laffable computer
illiteratedness looks at me oddly...it's there and it's so beautiful, it
makes a guy wanna cry.
Now, I close the report and the form and go to a table called LineName. In
it there are only two fields: LineID and LineName. Both are the same--
LineID's first record is 1 with a 1 in the LineName spot. Like this:
LINEID LINENAME
1 1
2 2
etc etc, you get the point.
Ok, when I do the above form thingy to get my report, whatever line I typed
in that Parameter box--in this case, 2--it adds a new record at the
beginnning of the table and puts a "2" under LINEID and nothing under
LINENAME.
Now, this is not a big problem--that table was ONLY used to be the control
source
for the list box that let the person choose the line they wanted. However,
it does overwrite the first record in that table. Therefore, if it looked
like this:
LINEID LINENAME
1 1
2 2
3 3
it now looks like this instead:
LINEID LINENAME
2
2 2
3 3
So that will be a problem later unless I go into the table after every time
and modify that record to be back to it's original self.
Now...how do I get rid of that pesky (much like my assistant) Parameter box
and how do I keep it from corrupting (so to put it) my records in that table?
Other than that, the query/report thing is the answer to my prayer! I bless
you, Sprinks, and all your offspring and their offspring, heck, and theirs,
too!!!!!!!! May the Computer Crash gods look kindly on you and save you from
their wrath!!! THANKS for your help!!!
LATER THAT NIGHT...I WROTE THIS!
aka
POST NUMERO DOS:::
Shazammmmm...ok I disassociated the Control Source of the form from the
table--I deleted "LineID" table from control source, so it no longer wants to
update my table.
Okay, so the only obstacle in my way is that pesky parameter value box
thing. Let's assume I'm making this form for a person of a lower mental
capacity and that parameter value box thing will confuse them, which it will.
How can I make that go away like disco in the 80's?
another post. If anyone can help me with this, I'd be greatly appreciative
and it'll keep me from losing my hair before I turn 26!
Sprinks, you may be my only hope!!
POST NUMERO UNO::::
SPPPPRRRIIIINNNKKKS! I'm at like 80% where I hoped to be!!
Ok I did EXACTLY as you said. Now, when I open the form and select my line
and click the button, it pops up a little box called "Enter Parameter Value"
and the text says "Forms!frmReportCriteria!cboLineNumber" and it has a box
for me to type in. Now, let's say I put in "2" for line 2.
I click ok and BOOM, there it is...the highly coveted report that I could
only dream about before I met you, hahaha...it fills me with insane energy
and laughter and my assistant, in her lovable and laffable computer
illiteratedness looks at me oddly...it's there and it's so beautiful, it
makes a guy wanna cry.
Now, I close the report and the form and go to a table called LineName. In
it there are only two fields: LineID and LineName. Both are the same--
LineID's first record is 1 with a 1 in the LineName spot. Like this:
LINEID LINENAME
1 1
2 2
etc etc, you get the point.
Ok, when I do the above form thingy to get my report, whatever line I typed
in that Parameter box--in this case, 2--it adds a new record at the
beginnning of the table and puts a "2" under LINEID and nothing under
LINENAME.
Now, this is not a big problem--that table was ONLY used to be the control
source
for the list box that let the person choose the line they wanted. However,
it does overwrite the first record in that table. Therefore, if it looked
like this:
LINEID LINENAME
1 1
2 2
3 3
it now looks like this instead:
LINEID LINENAME
2
2 2
3 3
So that will be a problem later unless I go into the table after every time
and modify that record to be back to it's original self.
Now...how do I get rid of that pesky (much like my assistant) Parameter box
and how do I keep it from corrupting (so to put it) my records in that table?
Other than that, the query/report thing is the answer to my prayer! I bless
you, Sprinks, and all your offspring and their offspring, heck, and theirs,
too!!!!!!!! May the Computer Crash gods look kindly on you and save you from
their wrath!!! THANKS for your help!!!
LATER THAT NIGHT...I WROTE THIS!
aka
POST NUMERO DOS:::
Shazammmmm...ok I disassociated the Control Source of the form from the
table--I deleted "LineID" table from control source, so it no longer wants to
update my table.
Okay, so the only obstacle in my way is that pesky parameter value box
thing. Let's assume I'm making this form for a person of a lower mental
capacity and that parameter value box thing will confuse them, which it will.
How can I make that go away like disco in the 80's?