Andy,
What's the error? My guess is that you have a broken reference in VBA.
Jim.
-----Original Message-----
From: profoxtech-bounces AT leafe .D.O.T com [mailto:profoxtech-bounces@leafe.com] On
Behalf Of Andy Davies
Sent: Friday, September 29, 2006 7:42 AM
To: profoxtech AT leafe .D.O.T com
Subject: Re: [NF] Access and the Null Blues
--- Access and the Access blues!!!
A user has a problem with Access which I traced to an expression in a query
(probably bad data but...) -
so I tried to verify the expression a step at a time - can anyone verify
this:
open Access (2003) -> vba window -> in the Immediate window type:
ax = "asdf g"
? instr(ax, " ")
vba falls over and calls Redmond - wtf?
Andrew Davies MBCS CITP
- AndyD 8-)#
**********************************************************************
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
Please contact internet.administrators@manchester.gov.uk with any queries.
**********************************************************************
[excessive quoting removed by server]
©2006 Jim Dettman |
