G
Guest
Okay, I have a table. It has many fields, including EmployeeID, Department,
etc.
I made a form that I call my "View History." On it are two things: a text
box in which you enter the EmpID number, and an "OK" button. You punch in
the dude's # and click OK and BOOM, it opens a report based on a query based
on the table and tells me everything I've charged dude with. The purpose of
this is to verify if an employee has already been charged with something,
because if not, dude's gotta pay, comprende? NO PROBLEMS TO THIS POINT.
I make a second form, exactly like the first except it has a combo instead
of a text box. The field values for this combo are "Charged, Exempt,
ToBePaid". The purpose of this form is so that I can see who all is exempt
(based on one of those above 3 values in the "Exemption Status" field). Now,
that's not a problem. It pulls up all my data just fine and dandy---except
where it should have their employee ID listed, it says E+04 for EVERY
employee record. Let's say I click on the combo box, and click on "ToBePaid"
because I want to run a report (still based on a query based on the table) of
who all owes me money. EVERYTHING on both these forms works JUST fine,
except in this second form it won't show their EmployeeID numbers, just that
E+04 thingy.
Now, this form is EXACTLY like the previous; the macro, query, report and
table are almost identical; I just changed out the necessary info needed to
make it pull up the right data.
So why do I get the E+04 thing?
etc.
I made a form that I call my "View History." On it are two things: a text
box in which you enter the EmpID number, and an "OK" button. You punch in
the dude's # and click OK and BOOM, it opens a report based on a query based
on the table and tells me everything I've charged dude with. The purpose of
this is to verify if an employee has already been charged with something,
because if not, dude's gotta pay, comprende? NO PROBLEMS TO THIS POINT.
I make a second form, exactly like the first except it has a combo instead
of a text box. The field values for this combo are "Charged, Exempt,
ToBePaid". The purpose of this form is so that I can see who all is exempt
(based on one of those above 3 values in the "Exemption Status" field). Now,
that's not a problem. It pulls up all my data just fine and dandy---except
where it should have their employee ID listed, it says E+04 for EVERY
employee record. Let's say I click on the combo box, and click on "ToBePaid"
because I want to run a report (still based on a query based on the table) of
who all owes me money. EVERYTHING on both these forms works JUST fine,
except in this second form it won't show their EmployeeID numbers, just that
E+04 thingy.
Now, this form is EXACTLY like the previous; the macro, query, report and
table are almost identical; I just changed out the necessary info needed to
make it pull up the right data.
So why do I get the E+04 thing?