[AccessD] SAVING DATA ON FORM

Jim Hewson JHewson at karta.com
Thu Sep 25 10:01:26 CDT 2003


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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030925/c9cd53e8/attachment-0001.html>


More information about the AccessD mailing list