I found the problem. I was initially looking through the queries trying to
determine where the null CustomerID was 'hiding', but it was in the vba code
that I was using to set the value of CustomerID when the form was open. I'm
not sure why I did it, but I placed a table prefix on that line of code
referring to the CustomerID and the form could not dind it, so it was
obviously asking me for that information.
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of David Tolson
Sent: Monday, September 12, 2011 11:10 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Form is asking for parameter value
Oops Duane, I failed to compile the code after copying the objects that was
needed for this DB. I have corrected it. Those were references to Steven
Laban's calendar that I use, but they have been removed and the code
compiled. Thanks for brining that to my attention.
r/David
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Duane
Hookom
Sent: Monday, September 12, 2011 9:55 PM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Form is asking for parameter value
What's all the clsMonthCal stuff? Your application doesn't compile because
of references to this.
Duane Hookom
MS Access MVP
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
From: drtolson@verizon.net <mailto:drtolson%40verizon.net>
Date: Mon, 12 Sep 2011 23:12:39 +0000
Subject: [MS_AccessPros] Form is asking for parameter value
Great Day, I am trying to create an estimate for a customer that is having
repair work done to his/her vehicle. When I click the customer's vehicle
which the estimate is for, Access is requesting a parameter value for
CustomerID. I know this sounds like a broken record from programmers of my
skill level, but I've looked at every query and field name on the forms, but
have been unable to discover why there is a CustomerID that does not have a
value.
I have uploaded a copy of the db with the following instructions:
Click on frmCustomerContactData
highlight vehicle to be serviced
click "Repair Order" button
Thanks in advance for your assistance.
r/David
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Selasa, 13 September 2011
RE: [MS_AccessPros] Form is asking for parameter value
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar