> Hi,
> 1) I would like to make a command button that allows a user to move
[quoted text clipped - 12 lines]
> insert this? Do I need to make a button using the wizard and then
> insert this somewhere in Microsoft's code?
Drop a button on your form with the toolbox wizard turned off, name the button
what you want, and then in the property sheet for the button go to the events
tab and find the OnClick property. In the drop list of choices choose [Event
Procedure] and then press the build button [...] to the right.
That will take you to the VBA code window and *that* is where you code goes.
> I was also wondering how to get the focus to move automatically from
> the last control on one page to the first control on the next page.
Place a very small (but visible=true) TextBox on each page and make it last in
the TabOrder. In its GotFocus event have code...
Me.ControlName.SetFocus
...where ControlName is the name of the desired control on the desired TabPage.
> 2) Another problem I am having is that I want to print one page at a
> time, but when I press the print record button, it prints everything
> out. This is because all the tabs are on one record, but there isn't
> any other option in the command buttom wizard. Is there a way to
> print only one tab at a time?
Don't print forms, create a report and print that. It is easy to open or print
a report pre-filtered to the record currently being displayed on the form by
using the WHERE argument of the OpenReport method.
DoCmd.OpenReport "ReportName",,,,"PrimaryKeyField = " & Me!PrimaryKeyField

Signature
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
steveoz@charter.net - 22 Oct 2005 22:00 GMT
> > Hi,
> > 1) I would like to make a command button that allows a user to move
[quoted text clipped - 46 lines]
> to this message. Send instead to...
> RBrandt at Hunter dot com