Datasheet View

[Bface]

Hello,

I tried looking through some of the postings to see if anyone asked these questions before but I didn’t find any. I have 3 questions and I hope someone can help me out. I will write post them separately so it’s not that long.

First I have a main form which is pulling its data from [QryDepartments]. On this form I created a command button on the form based on [QryDepartment]; this allows people to view the query in datasheet view. I know access has its own datasheet view on the menu but I wanted to create my own. The problem I am having is if I do a filter on the form and then click on the command button to see it in datasheet view, it does not show the filter. I thought since it’s based on the same query it would work. Can someone please tell me what I need to do to get this to work.

[MMcCarthy]

Hello,

I tried looking through some of the postings to see if anyone asked these questions before but I didn’t find any. I have 3 questions and I hope someone can help me out. I will write post them separately so it’s not that long.

First I have a main form which is pulling its data from [QryDepartments]. On this form I created a command button on the form based on [QryDepartment]; this allows people to view the query in datasheet view. I know access has its own datasheet view on the menu but I wanted to create my own. The problem I am having is if I do a filter on the form and then click on the command button to see it in datasheet view, it does not show the filter. I thought since it’s based on the same query it would work. Can someone please tell me what I need to do to get this to work.

I know some of our other experts will have views on the solution to this.

However, essentially by using the forms filter features you are losing them when the form view changes to datasheet. Access probably preforms a refresh by default.

One solution would be to create your filter using code.

[nico5038]

Hi Bface,

I have a hard time to envision the working of the filter on your form.
Personally I use an unbound (not table related) mainform and add a datasheet subform to allow my users to filter.
Check my sample at
http://www.geocities.com/nico5038/Sa...tAction-97.zip
The datasheet hold in the OnCurrent event a statement to move the applied filter on the subform to the mainform making it visible for the user.

Getting the idea ?

Nic;o)

[PEB]

The proposal of Nico is good, but the default datasheet view from query also has a lot of advantages than using a form

All of my views are visualized by queries... Users do filters without problems and for them it is the best way, using datasheet /coz it is like Excel :)/

Maybe you don't want queriees coz u think that the user can see and modify the structure of your query?

I'm sure the user can't if you defend the buil-in functions in Access!

For me the query has more advantages than a form... There is advantages that i'm learning just now..

Hello,

I tried looking through some of the postings to see if anyone asked these questions before but I didn’t find any. I have 3 questions and I hope someone can help me out. I will write post them separately so it’s not that long.

First I have a main form which is pulling its data from [QryDepartments]. On this form I created a command button on the form based on [QryDepartment]; this allows people to view the query in datasheet view. I know access has its own datasheet view on the menu but I wanted to create my own. The problem I am having is if I do a filter on the form and then click on the command button to see it in datasheet view, it does not show the filter. I thought since it’s based on the same query it would work. Can someone please tell me what I need to do to get this to work.