Forms side by side?

[Mickey Flynn]

I would like to set up a database structured similar to a webpage with
frames.

What I'm trying to do is have a main switchboard frame on the left side with
a main frame to the right.

The switch board would consist of simple command buttons. The command
buttons would open the corresponding form in the right frame. Maybe a form
with a subform triggered with the command button? Is this possible? As you
can tell I am new to access so keep it simple if possible. Thanks for any
help!

 

[Jeff Boyce]

Mickey

Which version of Access?

Another variation that might accomplish something similar would be to use a
tab control on a single form. Clicking different tabs would reveal
different pages (similar to your notion of different forms per command
button).

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mickey Flynn]

The version is Access97. OK how do I do that. By subform you mean just a
form? And code the buttons I assume some kind of on click event on the
command button? What would that be? Say the form I want to open in the main
frame is frmTracking.

One other quick question: One of my labels is captioned F&I but shows as F
_I. How do I get it to show the & sign?
Thanks again for helping.

Thanks for the help. OK, So kind of what I was thinking,

 

[Mickey Flynn]

The version is Access97. OK how do I do that. By subform you mean just a
form? And code the buttons I assume some kind of on click event on the
command button? What would that be? Say the form I want to open in the main
frame is frmTracking.

One other quick question: One of my labels is captioned F&I but shows as F
_I. How do I get it to show the & sign?
Thanks again for helping.

 

[Larry Linson]

The version is Access97.

By subform you mean just a form?

Strictly speaking, Access has no object called a Subform. Access has a
Subform Control, which in Access 97, you'll find in the ToolBox that, by
default, displays along the left side of the design window.

Steve is, I am sure, using "subform" as shorthand for "form displayed in a
Subform Control", as is common in these newsgroups. Though a common usage,
it can be confusing if you aren't aware of how it's used.

code the buttons I assume some kind of
on click event on the command button?
What would that be? Say the form I want to open in the main
frame is frmTracking.

In an example database, with a "frmSFTestMainWhite" and a SubformControl
"sbfTest", initially set with either of two Forms "frmSFTestRedSub" or
"frmSFTestBlueSub", the OnClick event
of a Command Button on "frmSFTestMainWhite" named
"cmdToggleSubformSource" is:

If Me.sbfTest.SourceObject = "frmSFTestRedSub" Then
Me.sbfTest.SourceObject = "frmSFTestBlueSub"
Else
Me.sbfTest.SourceObject = "frmSFTestRedSub"
End If

One other quick question: One of my labels is
captioned F&I but shows as F_I. How do I get
it to show the & sign?

Change the caption from "F&I" to "F&&I". Caption text uses a single & to
designate the following character for a shortcut/hotkey (and marks it by the
immediately-preceding underline).

I gather from your questions that you are not familiar with Visual Basic for
Applications (VBA) code. If you want to create "finished" or "polished"
applications, it would be good to learn some VBA.

Just a caution: I have not found my clients' users to be any happier, nor
more productive, using a configuration as you describe, nor a tab control
for application navigation, than with normal Access usage (switchboard
form -- not a Switchboard Manager generated form) main forms, navigation to
other forms either in Subform Controls or separate forms. Certain
structures of data do lend themselves to being easier for the user if
implemented in a Treeview Control, but that requires non-trivial code to
implement (it is a control that comes in Windows, but is not a "native
Access control" in the Access Toolbox).

Good luck with your application.

Larry Linson
Microsoft Office Access MVP

 

[Mickey Flynn]

Thanks for all the help. And you are right, I am NOT familiar with VBA but
am trying to learn as I build this Access database.
Hopefully with a little help from you smart guys on here I'll eventually get
there. Thanks again.

 

[Mickey Flynn]

OK, that works perfectly. Thanks for the help!
You guys are great...

 

[Mickey Flynn]

One more quick question on this.
How do I open the form in "Add New Record" mode...I'm sure I'm not wording
that right but similar to this code in the On Click event for "Add" Command
Button if I am already in the form:

On Error GoTo Err_cmdAddRecord_Click

Forms!FrmContacts!Date.SetFocus

DoCmd.GoToRecord , , acNewRec

Exit_cmdAddRecord_Click:
Exit Sub

Err_cmdAddRecord_Click:
MsgBox Err.Description
Resume Exit_cmdAddRecord_ClickRight now all I have is simply this code that opens the form only:

Private Sub cmdOpenTracking_Click()

Me!SbFrmCtl.SourceObject = "FrmTracking"

End Sub

Thanks again!

 

[micfly]

Never mind, just set the Data Entry to Yes in the FrmTracking properties...
took me forever (-: