FSDUtils:FSDMenu

From Free State Drivers
Revision as of 12:52, 13 April 2013 by Cvopicka (talk | contribs) (Created page with "'''Description''' FSDMenu is a Microsoft access based self generating menu that allows for easy updates to menus without the need to import custom toolbars. All the data for ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Description

FSDMenu is a Microsoft access based self generating menu that allows for easy updates to menus without the need to import custom toolbars. All the data for the menus are stored in tables and you can have as many menus defined as you have space in the database to hold the toolbar definitions.



Setup

Typical

Called by FSDStart



Programming Guide

Guide Layout:

Module

Function/Sub

Description



FSD_Menu_Blank

Public Function FSD_Menu_BlankTable()

Creates a blank table to be populated by the user for another menu bar.



FSD_Menu_Setup

Public Function FSD_Menu_BuildFromBar()

Function to display a menu bar that is used to activate the reading of existing menu bar and storing the data in a table for use by FSDMenu.


Public Function FSD_MenuClick()

Function called when a choice is made to read a menu bar.


Private Sub ReadBar(TblName As String, Cbar As Variant, Level As Double)

Function to read the menu bar in question and store in a properly formatted table.



FSD_Menu

Public Function FSD_Menu_Version()

Returns the version number of the FSDMenu Code


Public Function FSD_BuildMenu(TableName As String)

Calls the FSDMenu routine


Private Sub FSDMenu(TableName As String)

Private Sub FSD_Btn_Add(DB As Database, TableName As String, FieldNames() As String, FieldMins() As Double, CmdBar As Object, ByRef MinRecSet As Recordset, ByRef Level As Integer)

Button Types:

  • ComboBox
  • DropDown
  • Edit
  • PopUp
  • Button


Button Properties:Warning: Not all properties work with all button types

  • Type (required)
  • ID
  • BeginGroup
  • Caption
  • TooltipText
  • DescriptionText
  • Enabled
  • Visible
  • Height
  • Width
  • HelpContextId
  • HelpFile
  • OnAction
  • Parameter
  • Tag
  • Style
  • Automatic
  • Caption
  • Icon
  • IconAndCaption
  • IconAndCaptionBelow
  • IconAndWrapCaption
  • IconAndWrapCaptionBelow
  • WrapCaption
  • Label
  • Normal
  • State
  • Down
  • Mixed
  • Up
  • FaceId
  • Picture
  • Mask
  • HyperlinkType
  • InsertPicture
  • None
  • Open


Private Sub FSD_MinsRecset(DB As Database, TableName As String, MenuFields() As String, ByRef RecSet As Recordset)

Private Sub FSD_CmdBar_Add(DB As Database, MenuTableName As String, MenuFields() As String, MenuValues() As Double, ByRef CmdBarName As String)

  • Name
  • Position
  • Bottom
  • Floating
  • Left
  • MenuBar
  • Popup
  • Right
  • Top
  • Temporary
  • True
  • False

Private Sub FSD_Menu_Fields(DB As dao.Database, TableName As String, ByRef FieldNames() As String)

Private Sub FSD_CmdBar_Remove(CommandBarName As String)

Private Function FSD_Where_String(MenuFields() As String, MenuFieldsValue() As Double) As String



FSD_Menu_Funcs

Public Function FSD_Menu_SQL(SQLSource as String)

Helps to call an SQL string directly from the menu.


Public Function FSD_Menu_Table(MenuName as String)

Helps to open a Table directly from the menu.


Public Function FSD_Menu_Query(QueryName as String)

Helps to open a Query directly from the menu.


Public Function FSD_Menu_Form(FormName as String)

Helps to Open a Form directly from the menu.


Public Function FSD_Menu_Report(ReportName as String)

Helps to Preview a Report directly from the menu. Preview being different from opening. Opening a report results in printing immediately when called from code. Preview has the same result as double clicking on a report.