Navigation form replacement suggestion (1 Viewer)

[mhakim]

Dears
Good Day

are there any replacement for Navigation Forms

i need to collect all my forms in one place with out changing
for example Critreia & parameters in my Queries

from
[Forms]![AccountingReports]![datefrom]

to
[Forms]![MainForm]![NavigationSubform].[Form]!

i have many Queries so i need more flixeble option

 

[isladogs]

You can create your own emulated navigation forms which are more flexible than the built in Accession version.
See the example app supplied with my article

Automatic Form Resizing 1

Use automatic form resizing (AFR) to ensure that forms and their controls are automatically resized and repositioned for any screen size & resolution. It can also be used to add a zoom feature to Access forms

www.isladogs.co.uk

 

[Pat Hartman]

By definition, a navigation form whether it is the built in one or one you create yourself, makes ALL forms into subforms and therefore you need to change your criteria to include the mainform. Here are several example switchboards that might solve your problem. The example with the security is completely custom and has the most flexibility, especially if you also use the security.

Replacement Switchboard

This Switchboard form is based on the last VBA version which I think was A2k. I expanded it to allow for 12 items rather than 8 and you can easily change it to do more. I've included directions. This updated version has two switchboards. One more traditional and the other is big buttons...

www.access-programmers.co.uk

Switchboard with simple security

This is a custom switchboard. It expands on the Switchboard Items table to add four additional columns to define view/edit/add/delete security levels for switchboard items and forms/reports referenced by them. It includes tables to manage users and also to assign them security levels. The user...

www.access-programmers.co.uk