Advertisement

06.23.2008 at 02:41PM PDT, ID: 23509255
[x]
Attachment Details

Creating toolbars linked to form data

Asked by AaronGreene1906 in Access Coding/Macros, Access Forms

Tags: MS-Access, MS-ACCESS 2003

I would like to update some of my forms to have a more professional look.  Currently, I have command buttons on the form to perform tasks like saving the record, printing the record and opening related forms that are passed open arguments from the parent form.  I'd like to create a set of custom menus and toolbars for this form to perform the same tasks.  Is that possible?  If so, where is a good place to start?

This is a typical action that I'd like to perform with a toolbar command.
Dim strForm As String
Dim strMESSAGE As String
Dim strCAPTION As String
If IsNull(Me.cboLOCATEGRP) = True Or Me.cboLOCATEGRP.Value = 0 Then
strMESSAGE = "PLEASE SELECT THE SIDE OF I-35"
strCAPTION = "FORM COMPLETION NOTICE"
MsgBox strMESSAGE, vbOKOnly, strCAPTION
Me.cboLOCATEGRP.SetFocus
Exit Sub
End If
If IsNull(Me.cboLOCATETYPE) = True Or Me.cboLOCATETYPE.Value = 0 Then
strMESSAGE = "PLEASE SELECT THE TYPE OF LOCATE"
strCAPTION = "FORM COMPLETION NOTICE"
MsgBox strMESSAGE, vbOKOnly, strCAPTION
Me.cboLOCATETYPE.SetFocus
Exit Sub
End If
strForm = "frmData_Locate_Footage"
DoCmd.OpenForm strForm, acNormal, , , , , Me.txtWORKORDER.ValueStart Free Trial
[+][-]06.23.2008 at 03:10PM PDT, ID: 21850823

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Coding/Macros, Access Forms
Tags: MS-Access, MS-ACCESS 2003
Sign Up Now!
Solution Provided By: omgang
Participating Experts: 1
Solution Grade: A
 
 
[+][-]06.23.2008 at 03:17PM PDT, ID: 21850868

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628