Hi Susie,
Sorry, I didn't get around to checking the newsgroup in the last couple of days for any
replies....
In your last answer to JB, you stated:
"The query is empty only on her machine. This is really
strange. I've decide that I am going to try to create a
new report and see if that works. So we'll see......"
Creating a new report will not help in this situation. The problem lies in determining why the
query is empty on her machine. Queries are designed to supply a set of records (ie. a
"recordset") to forms, reports, etc. If a query is not returning any records, then there is no
way that the report can display what it doesn't have available.
Question for you:
When you ran this query, did you have the form named "ChooseRegionSEE" open, with a valid
selection made in the combo box named combo3? This form needs to be open whenever the report is
run, and the underlying query is executed.
I was thinking that there was the possibility that your query used the current system date & time
as part of the criteria (WHERE clause) for the query. If this was the case, and this user's PC
clock was not set correctly, this could explain the empty recordset. However, upon examining the
SQL statement, I do not see any such criteria.
The next thing I'd try doing is selecting the Tables tab, and open the CAV_Combo_SEE_Stage table.
Okay, I'm assuming that this is a table--it could also be another query. Open this object. Can
you can see any records on this user's PC? In your original message, you stated: "The tables are
linked via an ODBC connection". There is certainly the possibility of a problem with this ODBC
connection. If you are able to open CAV_Combo_SEE_Stage, and see records returned, then this
should rule out a connection problem.
If CAV_Combo_SEE_Stage happens to be a query, do you see any reference to a system date & time?
Is the PC's clock correct on this user's machine?
Apparently, there is one field named DATE in CAV_Combo_SEE_Stage. Although this should not cause
any immediate problems, I recommend for your future database development efforts to avoid the use
of reserved words in Access. Date is a reserved word.
http://support.microsoft.com/?id=209187
Tom
_______________________________________
The following is the SQL from the query linked to the
report. Maybe you can find something odd.
SELECT CAV_Combo_SEE_Stage.Event_Key,
CAV_Combo_SEE_Stage.Event_Location,
CAV_Combo_SEE_Stage.Event_End_Date_Time,
CAV_Combo_SEE_Stage.Date,
CAV_Combo_SEE_Stage.Event_Status,
CAV_Combo_SEE_Stage.Category, CAV_Combo_SEE_Stage.AV,
CAV_Combo_SEE_Stage.Cater, CAV_Combo_SEE_Stage.Region,
[start date] AS Start, [end date] AS [End]
FROM CAV_Combo_SEE_Stage
WHERE (((CAV_Combo_SEE_Stage.Region)=[Forms]!
[ChooseRegionSEE]![combo3]));
____________________________________________
Please post the SQL statement for the report's
recordsource. Open the report in design view.
Click on View > Properties to display the properties
dialog. Select the Data tab. Make sure that
this user doesn't have any filters applied (Filter on =
no). Click the build button (the button
with the three dots) on the recordsource. This should
open up a query builder. In query design,
click on View > SQL View. Copy the resulting SQL
statement and paste it into a new post, so that
we can take a look at it. Then close out the query
builder and close the report. Don't accept
any changes.
Tom
__________________________________________
[email protected]> wrote in message
Thanks for the guesses, any help is truely appreciated. We have checked the Regional Settings,
and they are the same. We're thinking it isn't related to the dates because there are other very
similar reports that have date criteria that she is able to run. We are really stumped by this
one, so if you have any other suggestions, please pass them on. Thank you!!
__________________________________________
In Control Panel you'll find Regional Settings, make sure the date format is set as you expect
(and cross-check this with the machines on which the report runs correctly)
It's only a guess!
Good luck
James
__________________________________________
[email protected]> wrote in message
Sorry to be dense, but what do I need to check. Thanks for helping.....
__________________________________________
What about Regional Settings?
__________________________________________
I have a database (in XP) that is used by multiple users. The tables are linked via an ODBC
connection. I don't know if that is pertinent info, but you never know. I have a user that is
running a report and the results return the report headings with no detail info. If she runs any
other reports, they are fine. We have tried running the same report on many other workstations,
with exact criteria and have no problems with the report. I have never run into something like
this before. I have had her re-boot her computer, with no luck. The report calls for date
criteria, so I have made sure that she is entering the correct date format. It's just really odd
that she is the only user that is having this problem.
Any suggestions would be greatly appreciated.
Thanks for your help.
