[AccessD] SAVING DATA ON FORM

Coutts, Welford L. COUTTSW at rjrt.com
Thu Sep 25 08:15:30 CDT 2003


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030925/e0ef2bab/attachment-0001.html>


More information about the AccessD mailing list