Missing Records due to Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a simple select query to refine a list of records. One of the
parameters i am using to refine the list of records is a date. On one PC when
i run the query all the appropriate records are returned by the query, on
another PC only records where the date is greater then todays date are
returned although all the parameters are the same. Both machines are using
the same version of Access etc. Are there any setting that can account for
this???

Very confused now !
 
I am using a simple select query to refine a list of records. One of the
parameters i am using to refine the list of records is a date. On one PC when
i run the query all the appropriate records are returned by the query, on
another PC only records where the date is greater then todays date are
returned although all the parameters are the same. Both machines are using
the same version of Access etc. Are there any setting that can account for
this???

Very confused now !
Click to expand...

Would you copy and paste into a reply message the exact Where clause
of the query SQL from the PC that is returning the incorrect records.
 
I am using a simple select query to refine a list of records. One of the
parameters i am using to refine the list of records is a date. On one PC when
i run the query all the appropriate records are returned by the query, on
another PC only records where the date is greater then todays date are
returned although all the parameters are the same. Both machines are using
the same version of Access etc. Are there any setting that can account for
this???

Very confused now !
Click to expand...

The fact that it's working on one machine and not on the other
suggests that either the two machines in fact have different
databases, or that the References are missing on one of them. Try
opening the VBA editor in each database (type Ctrl-G for example), and
select Tools... References. If any are marked MISSING, note which one
it is; uncheck that reference; close and open the VBA editor; scroll
down and find it and recheck it; select Debug... Compile <your
database>; close VBA, compact and see if that fixes it.

John W. Vinson[MVP]
 
Back
Top