[AccessD] weird action in access query's

Amazing. It worked. After a coupe hours working on trying to pass some
parameters in VBA code that won't work as examples say it should it
broke those rounding formula's.  Thought it had really messed up the
formula's.
Thanks Jim.

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

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 

 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com