DeveloperBarn Forums

Go Back   DeveloperBarn Forums > Databases > Microsoft Access

Discuss "Quick Links - Combo Open Forms" in the Microsoft Access forum.

Microsoft Access - Microsoft Access is a database for small to medium applications. Learn tips and tricks and best database practices here.


Reply « Previous Thread | Next Thread »  
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old June 4th, 2008, 08:46 AM
AOG123's Avatar
Lightning Master

 
Join Date: Mar 2008
Location: Fortress Of Solitude
Posts: 78
Thanks: 6
Thanked 21 Times in 16 Posts
Rep Power: 1
AOG123 is on a distinguished road

Awards Showcase
Microsoft Access 
Total Awards: 1

Default Quick Links - Combo Open Forms

So i decided to add a quick links combo on my Main switchboard to allow the user quick access to any form.

Please see the attached file,.. this is easy to implement,..

Create a Combo,.. set the Row Source Type to "Value List"

Set your Row Source Values

Code:
I.e.  1;"FormName1";2;"FormName2";3;"FormName3"
Then Set the column Count to 2
and the Bound Column to 2

then either with a command button or the after update of the combo insert the following code.

Code:
DoCmd.OpenForm Me.ComboName, , , stLinkCriteria
Attached Files
File Type: zip QuickLink Open Form.zip (62.5 KB, 6 views)
__________________
If i helped you, make me famous by clicking the
Reply With Quote
The Following User Says Thank You to AOG123 For This Useful Post:
Rebelle (June 4th, 2008)
Sponsored Links
Reply

  DeveloperBarn Forums > Databases > Microsoft Access

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Web Page Jaykappy Microsoft Access 2 May 14th, 2008 06:32 PM
VB6 MODAL and MODELESS forms? theChris Visual Basic Programming 1 April 22nd, 2008 08:41 PM
Maintaining Form Data after forms authentication timeout richyrich .Net Development 13 April 17th, 2008 01:28 AM
Dynamic Combo Maker mehere Classic ASP 0 March 28th, 2008 09:40 AM


Sponsored Links

ASP.NET Resource Index
a directory of ASP.NET tutorials, applications, scripts, assemblies and articles for the novice to professional developer.

Free Web Directory
Including Chats and Forums Resources, Offer automatic, instant and free directory submissions.
URLZ Web Directory
URLZ Web Directory

Free Web Directory - Add Your Link
The Little Web Directory
Free Web Directory
Pegasus free web directory is a free directory organised by categories.

Web Directory & SEO Services
dirroot web directory


All times are GMT -4. The time now is 12:55 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.2.0
Copyright © 2008 DeveloperBarn.com

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46