We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

MS Access 2007 Runtime Form Views

Mike_Schnobrich
on
Medium Priority
626 Views
Last Modified: 2013-11-28
I know that the Access 2007 Runtime disables the Design View, but does it also disable the Layout View.  In the Layout View, different filters can be done on the columns. I would like to do the filtering that way if possible.
Comment
Watch Question

Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
Layout view is just a different version of Design view, and all Design options are disabled when using the Runtime so no, you cannot use the Layout view in the Runtime.

I'm not aware of any "different filters" ... can you explain that further?

Author

Commented:
The problem I have is there are several columns that are informational only during data entry but are used to filter records at one point or another during data entry. In the runtime, I can filter and sort on the enabled columns but not the others. I guess the layout view allows for all columns to be sorted and filtered.

Since I have to have some sort criteria on the data enter form, what do you think is the best aproach, a macro like Requey or a VBA subroutine  where can I find some examples? The form is based on a query.
Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thank you, that worked like a charm!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.