By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,669 Members | 2,203 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,669 IT Pros & Developers. It's quick & easy.

Datasheet View

P: 14
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.
Nov 17 '06 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Nov 17 '06 #2

nico5038
Expert 2.5K+
P: 3,072
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)
Nov 18 '06 #3

PEB
Expert 100+
P: 1,418
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.
Nov 18 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.