[AccessD] weird action in access query's

Jim Dettman jimdettman at verizon.net
Wed Oct 8 10:19:46 CDT 2008


Steve,

  Sounds like a reference is broken.

  Open the app and then a module.  Click tools/references.  Look for any
that are shown as MISSING or BROKEN.  If any are, they'll need to be fixed.

  If none are, then check any unchecked reference (note which).  Close the
app and Access, re-open and uncheck the reference just checked.  Then do a
compile and save.  Try the query again.  If that doesn't fix it, then we'd
need to dig further.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Turner
Sent: Wednesday, October 08, 2008 10:29 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] weird action in access query's

  

Helo list,

I have a couple of querys that calculate a total by date range. They
were pretty complicated but they were working until I went in and
changed the date criteria trying to get the date exported to a VBA
parameters query. The formula had a 

Round(formula,2). Worked fine for a while but I changed the date
criteria to a GetValue() and when I went back in to change the date
criteria again it gave me a compile error and showed the SQL code and I
couldn't get to the Datasheet View. Finally found that the round
function was the problem. Deleted the round reference and it would let
me save it. Tried to go back and add it but It won't let me now.

Anyone know of such a problem?

 

Steve A. Turner
Controller
Mid-South Engineering Co. Inc
P.O. Box 1399
Hot Springs, AR 71902
E-Mail: sturner at mseco.com and saturner at mseco.com
Phone:(501)321-2276
Fax:     (501)321-4750 

 





More information about the AccessD mailing list