943,865 Members | Top Members by Rank

Web Development > Databases > MS Access and FileMaker Pro > Office XP/2002 Access not filtering
Ad:
Permalink
Jul 19th, 2004
0

Office XP/2002 Access not filtering

Expand Post »
hello, I am trying to help Jennifer who uses Access. The MS office is XP/2002.

When she keys in the information she needs it bring up all the data and not just the data she is asking for, so it's not filtering.

When she views SQL an astericks * shows up on one of the lines and it shouldn't.

I tried uninstalling and re-installing. Does anyone have any suggestions?

Also I asked when she used to have this problem. She statest she got the laptop in May and all worked well it had 2003 office then. But our company rolled back to 2002 b/c of compatibility issues, it was then the her issue occured.

thanks in adavance
Similar Threads
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
ArtChess is offline Offline
90 posts
since Jun 2004
Permalink
Jul 19th, 2004
0

Re: Office XP/2002 Access not filtering

Can you post the enitre SQL? Maybe give us a better idea about what she's entering, and what type of results you want?

If it's a WHERE sql clause, change the * to a 'whatever'.
Moderator
Reputation Points: 322
Solved Threads: 28
The C# Man, Myth, Legend
Tekmaven is offline Offline
914 posts
since Feb 2002
Permalink
Jul 19th, 2004
0

Re: Office XP/2002 Access not filtering

Select Dbo_customer.cust_nbr, Dbo_customer.cust_name, Dbo_ires_branch_daily.invoice_date, Dbo_ires_branch_daily.new_compl, Dbo_ires_branch_daily.used_compl, Dbo_ires_branch_daily.rental_income, Dbo_customer.br_code, *
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
ArtChess is offline Offline
90 posts
since Jun 2004
Permalink
Jul 19th, 2004
0

Re: Office XP/2002 Access not filtering

Quote originally posted by ArtChess ...
Select Dbo_customer.cust_nbr, Dbo_customer.cust_name, Dbo_ires_branch_daily.invoice_date, Dbo_ires_branch_daily.new_compl, Dbo_ires_branch_daily.used_compl, Dbo_ires_branch_daily.rental_income, Dbo_customer.br_code, *

Tek Maven the SQL is above:
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
ArtChess is offline Offline
90 posts
since Jun 2004
Permalink
Jul 19th, 2004
0

Re: Office XP/2002 Access not filtering

I still don't understand what you are trying to acomplish..?
Moderator
Reputation Points: 322
Solved Threads: 28
The C# Man, Myth, Legend
Tekmaven is offline Offline
914 posts
since Feb 2002
Permalink
Jul 19th, 2004
0

Re: Office XP/2002 Access not filtering

Quote originally posted by Tekmaven™ ...
I still don't understand what you are trying to acomplish..?
True. I am limited, as far as my experience and understanding of Access.. but the point of the matter is that a user used to be able to query a database and do filters so that it generates a list/report that she wants to see. She has been able to do so in the past using Office 2003, but when she reverted back to Office 2002 she is unable to.
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
ArtChess is offline Offline
90 posts
since Jun 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Next Thread in MS Access and FileMaker Pro Forum Timeline: Does Anyone Else Here Prefer SOT Office 2003 Over MS Office?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC