ACCESS FEED: RE: [MS_AccessPros] Navigation Form

Rabu, 20 Juli 2011

RE: [MS_AccessPros] Navigation Form

Well, your other post gives you a clue.

Queries:
SELECT MSysObjects.[Name]
FROM MSysObjectsWHERE (((MSysObjects.[Flags])=0) AND ((MSysObjects.[Type])=5))
ORDER BY MSysObjects.[Name];

Forms:
SELECT MSysObjects.[Name]
FROM MSysObjectsWHERE (((MSysObjects.[Flags])=0) AND ((MSysObjects.[Type])=-32768))
ORDER BY MSysObjects.[Name];

Reports:
SELECT MSysObjects.[Name]
FROM MSysObjectsWHERE (((MSysObjects.[Flags])=0) AND ((MSysObjects.[Type])=-32764))
ORDER BY MSysObjects.[Name];

Use those queries as the Row Source for list boxes on your three tabs or as the Record Source for three subforms.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of MEL
Sent: Wednesday, July 20, 2011 7:42 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Navigation Form

All forms, reports and queriesThanks.

--- On Wed, 7/20/11, John Viescas <john@viescas.com> wrote:

From: John Viescas <john@viescas.com>
Subject: RE: [MS_AccessPros] Navigation Form
To: MS_Access_Professionals@yahoogroups.com
Date: Wednesday, July 20, 2011, 1:04 PM

MEL-

Do you want to list all the forms and reports in your database or just "some"?

John Viescas, author

Microsoft Office Access 2010 Inside Out

Microsoft Office Access 2007 Inside Out

Building Microsoft Access Applications

Microsoft Office Access 2003 Inside Out

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

-----Original Message-----

From: MS_Access_Professionals@yahoogroups.com

[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of MEL

Sent: Wednesday, July 20, 2011 6:14 PM

To: MS_Access_Professionals@yahoogroups.com

Subject: [MS_AccessPros] Navigation Form

How can i create a navigation form and place some forms below it

Use Queries as the name for the second tab and place some forms below it

Use Reports as the name for the third tab and place some reports below it

Thanks

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links