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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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…

839 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