Re: I AM SO DUMB..........................PLEASE HELP

From: Cheryl Fischer (cherylfischer_at_NOSPAMmsn.com)
Date: 05/27/04 

Date: Wed, 26 May 2004 21:44:41 -0500

Just one last thing ...

Everyone has to start somewhere, and having one or two good books plus the
desire to learn good techniques and make them your own is getting off to a
*very good start*.

As you work through your book and your database project, do not hesitate to
post here with your questions. There are dozens of Access MVPs and other
expert responders who will be happy to answer them - and, of course, all
help is provided at our low, low rate of zero dollars/hour <smile>. 

--
Cheryl Fischer, MVP Microsoft Access
"LMB" <RomulanQueen@10Forward.SSTNG> wrote in message
news:ejHIu64QEHA.2404@TK2MSFTNGP09.phx.gbl...
> Hi Cheryl,
>
> Since I am not a programmer, I use the toolbox and click on the command
> button.  I then follow the prompts and there is one for report operations.
> I have used 2 before, the print report and open report.  What is the
> advantage to doing it using the method below instead of the toolbox?  I
> would never be able to remember all of that wording.  Does using the
wizards
> cause the database to have problems or not to be efficient?  BTW, I go the
> book "Database design for mere mortals SE" that you suggested in another
> thread.  It cost me $50 at the local bookstore but I just couldn't wait to
> have it delivered <g> So far I am understanding it, I have read the intro.
> <s>
>
> Thanks,
> Linda
>
>
> "Cheryl Fischer" <cherylfischer@NOSPAMmsn.com> wrote in message
> news:OUjvYa1QEHA.644@tk2msftngp13.phx.gbl...
> > You will need to add a Where Condition to the OpenReport method so that
> the
> > report shows only the information for the record displayed on your form.
> The
> > record will need to have a unique identifier, presumably
WorkOrderNumber.
> > Then, in the Click event of your command button, you can insert the
> > following:
> >
> >      ' This works when your WorkOrderNumber field is text
> >
> >     Dim strCriteria As String
> >
> >     strCriteria = "[WorkOrderNumber] = " & Chr(34) & Me!WorkOrderNumber
&
> > Chr(34)
> >     DoCmd.OpenReport "MyReport", acViewNormal, , strCriteria
> >
> >      ' This works when your WorkOrderNumber field is a number
> >
> >     Dim strCriteria As String
> >
> >     strCriteria = "[WorkOrderNumber] = " &  Me!WorkOrderNumber
> >     DoCmd.OpenReport "MyReport", acViewNormal, , strCriteria
> >
> > In the event that you have not done much VBA coding of events, here are
> the
> > steps needed to put the code "behind a button":
> >
> > 1.  Right click on the desired Command Button (let's call it:
> > CommandRunReport) control and select Properties.
> >
> > 2.  When the Properties *** opens, click the tab labeled Event.
> >
> > 3. In the grid below, locate the row labeled, On Click.  It should be
> blank.
> > Click anywhere in the white space to the right of the label and you will
> see
> > a downward-pointing arrow appear, indicating that this is also a
ComboBox.
> > Click the arrow and select "Event Procedure".
> >
> > 4.  Then, notice that there is an ellipsis or three little dots (...) to
> the
> > right of the ComboBox.  Click the ellipsis and you will open a code
> window.
> > You will see that Access has given you a space for entering some code in
> > this event - it will look something like the following:
> >
> >      Private Sub Private Sub CommandRunReport_Click()
> >
> >      End Sub
> >
> > 5.  After the "Private Sub Private Sub CommandRunReport_Click()" line,
> > insert the code provided earlier.
> >
> > 6.  Click the Save icon and close the Microsoft Visual Basic code
window.
> >
> >
> >
> >
> > --
> >
> > Cheryl Fischer, MVP Microsoft Access
> >
> >
> >
> > "kdc" <anonymous@discussions.microsoft.com> wrote in message
> > news:8001E8F0-272C-499F-864E-B40A42BA8229@microsoft.com...
> > > I am very new to Access and have been working forever to try to get a
> > simple form together for my boss.  It's a form which tracks incoming
work
> > orders on vehicles complete with a work order number, date incoming,
date
> > expected back, date sent out for service, where and a few other items.
At
> > the bottom of the form I want a command button that reads print form
which
> > would print only one form.  I have read tons of information concerning
not
> > printing forms but rather to set up a report and print that instead.  I
> have
> > also read alot about VBA's (very confusing information-to me) Printing a
> > report is fine with me - I have set one up that looks beautiful, now my
> > biggest dilema.  I need step-by-step instructions (remember I'm really
> dumb)
> > on how to link the command button on the form to the report.  Also, I'm
> sure
> > you've figured out I need to print one form or report at time.   You
have
> no
> > idea how much I would appreciate any help given.
> >
> >
>
>