Selasa, 13 September 2011

RE: [MS_AccessPros] Form is asking for parameter value

 

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]

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.


A bad score is 598. A bad idea is not checking yours, at freecreditscore.com.
.

__,_._,___

Tidak ada komentar:

Posting Komentar