Solved

I am having trouble with a data access page using a group filter. I just want filter a set of records by a drop down. The drop down list is the listing of each record in the table based on one field.

Posted on 2006-07-06
5
282 Views
Last Modified: 2008-01-09
I have a Table or query that I want to use a group filter. I have a good example from an access book but whenever I try it I get the error "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another" Then "Can't filter records. The field name specified in the GroupFilterField property must contain values that have the same or a compatiable data type as the values in the group filter control".
I have looked at this every way I know how. I have an exact example from some code in an access book and even a sample dbase that works like I want this to work. I just can't seem to get past this error.
0
Comment
Question by:jpateusa
5 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 17078639
jpateusa,

Are your samples based on Data Access Pages or Forms?
0
 

Author Comment

by:jpateusa
ID: 17086604
It is based on data access pages. Here is a little more information to go on. I have a query which pulls information from three seperate tables. Two of the tables are related to one another and the third is not (lookup values based on data in one table to the other). I can elevate the main id from one table and make it into group header that has a plus sign on it. That will work fine, but if I elevate the same field to another header and make it a group filter control it won't work and gives me the error above. I could email you exact tables, forms, data access pages, etc if it would help. It  works like it is but isn't what I want. I want to display a record from a table using a drop down box to do the filter. There is some code in the book I have to do a find command on a data access page using VB Script but I have not tried that yet. I do appreciate your help and I hope you have a great week.

Jason Pate
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 17088265
jpateusa,

Thanks, but the only reson I asked was in case you meant "Form"

All I know is that usually the Web team hadles things like this, not the DBA.

The web team can usually do this easilly in Frontpage, ASP or Dreamweaver.
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 17461521
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
    PAQ with points refunded

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

jjafferr
EE Cleanup Volunteer
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 17489640
PAQ / Refund
ee ai construct, community support moderator
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now