Coutts, Welford L.
COUTTSW at rjrt.com
Thu Sep 25 10:47:50 CDT 2003
No "IF" statements; both the Main and the called forms are unbound.
The Main form primarily has a number of command buttons for the user
to select where they want to go next.
The called form has a combo box that lists the states from a table.
The controls are hidden because there are a large number of them and
they would make the form very cluttered for the user and would display a lot
of data that are of no use to the user.
Welford
-----Original Message-----
From: Jim Hewson [mailto:JHewson at karta.com]
Sent: Thursday, September 25, 2003 11:01 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] SAVING DATA ON FORM
Do you have an "IF" statement in the opening form/report's query criteria? If so, is it working correctly?
Just out of curiosity, why do you have hidden controls on the main form?
-----Original Message-----
From: Coutts, Welford L. [mailto:COUTTSW at rjrt.com]
Sent: Thursday, September 25, 2003 9:38 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] SAVING DATA ON FORM
Jim,
txtID is going to be a state abbreviation after the user makes a selection, like NC, FL, MA, etc.
As a default, I am trying to put * in it until the user makes his choice.
I tried changing strID to Integer, as you suggested, and set it equal to 2. It worked fine up until
the " Forms!frmMain!txtID = strID " statement, when it failed as before.
And don't stop giving me things to try, I've exhausted my list!
TIA
Welford
-----Original Message-----
From: Jim Hewson [mailto:JHewson at karta.com]
Sent: Thursday, September 25, 2003 9:42 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] SAVING DATA ON FORM
What data is txtID matched with?
Yep, same problem I had. The form I was opening, couldn't use the data.
The control was text, I was feeding it text, the form I was opening was using numeric.
Two other thoughts.
1. Check the object of the form/report your opening. Check its data type.
2. As a test -- change As String to As Integer and see what happens.
I know, I sound like a broken record... but I spent way too much time (hours) running through a similar problem.
I'll keep quiet now.
Jim
-----Original Message-----
From: Coutts, Welford L. [mailto:COUTTSW at rjrt.com]
Sent: Thursday, September 25, 2003 8:16 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] SAVING DATA ON FORM
Jim,
Thanks for taking time to reply. However, they are text boxes.
For testing, I have pared the code down to this :
Dim strID As String
strID = "*"
Forms!frmMain!txtID = strID
which fails as I described.
Any other ideas?
Thanks,
Welford
-----Original Message-----
From: Jim Hewson [mailto:JHewson at karta.com]
Sent: Thursday, September 25, 2003 8:54 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] SAVING DATA ON FORM
Check the data type for your "hidden text boxes."
I spent a lot of time tracking down the same thing recently. I was trying to pass a text value to the query, when in fact it was
numeric!
HTH
Jim
-----Original Message-----
From: Coutts, Welford L. [mailto:COUTTSW at rjrt.com]
Sent: Thursday, September 25, 2003 7:37 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] SAVING DATA ON FORM
I have a Main form from which I call numerous other forms and reports.
I have a number of hidden text boxes on this form which I use to pass data between
other forms and to reports. I have done this in dozens of applications. But this week
it won't work! I get : "Run-time error '438' Object doesn't support this property or method"
I am using Access 2000 with all the latest revs applied. I have tried all kinds of changes to
try to get around this error, including using a class module to save on the main form instead
of saving from another form, and including any additional References that seemed to be
related in any way. Nothing helped.
If someone could tell me what I have missed, I would appreciate it.
Welford Coutts
_____
CONFIDENTIALITY NOTE: This e-mail message, including any
attachment(s), contains information that may be confidential,
protected by the attorney-client or other legal privileges, and/or
proprietary non-public information. If you are not an intended
recipient of this message or an authorized assistant to an intended
recipient, please notify the sender by replying to this message and
then delete it from your system. Use, dissemination, distribution,
or reproduction of this message and/or any of its attachments (if
any) by unintended recipients is not authorized and may be unlawful.
_____
CONFIDENTIALITY NOTE: This e-mail message, including any
attachment(s), contains information that may be confidential,
protected by the attorney-client or other legal privileges, and/or
proprietary non-public information. If you are not an intended
recipient of this message or an authorized assistant to an intended
recipient, please notify the sender by replying to this message and
then delete it from your system. Use, dissemination, distribution,
or reproduction of this message and/or any of its attachments (if
any) by unintended recipients is not authorized and may be unlawful.
_____
CONFIDENTIALITY NOTE: This e-mail message, including any
attachment(s), contains information that may be confidential,
protected by the attorney-client or other legal privileges, and/or
proprietary non-public information. If you are not an intended
recipient of this message or an authorized assistant to an intended
recipient, please notify the sender by replying to this message and
then delete it from your system. Use, dissemination, distribution,
or reproduction of this message and/or any of its attachments (if
any) by unintended recipients is not authorized and may be unlawful.
-----------------------------------------
CONFIDENTIALITY NOTE: This e-mail message, including any
attachment(s), contains information that may be confidential,
protected by the attorney-client or other legal privileges, and/or
proprietary non-public information. If you are not an intended
recipient of this message or an authorized assistant to an intended
recipient, please notify the sender by replying to this message and
then delete it from your system. Use, dissemination, distribution,
or reproduction of this message and/or any of its attachments (if
any) by unintended recipients is not authorized and may be unlawful.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030925/005ec3af/attachment-0001.html>