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
283 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

821 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