Go Premium for a chance to win a PS4. Enter to Win

x
?
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
Medium Priority
?
290 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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

877 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