Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    No brainer for most. (ACC97 SR2)

    What command goes before this 'filter' to update the current record into the table so that I can print ?

    DoCmd.OpenReport "NewBadges", acPreview, , "[Last Name] like '" & Me![Last Name] & "'"

    Yes, I know that Last Name is a bad field choice for the criteria, but there was no SSN#.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: No brainer for most. (ACC97 SR2)

    You can put the following instructions before the DoCmd.OpenReport:

    If Me.Dirty Then
    RunCommand acCmdSaveRecord
    End If

    If the current record has been updated, the Dirty property of the form will be True. In that case, save it.
    (You can handle errors in saving the record in your error routine)

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: No brainer for most. (ACC97 SR2)

    Oh, and why do you use Like without a wildcard? You might as well use
    [Last Name] = ...
    in the WhereCondition.

  4. #4
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: No brainer for most. (ACC97 SR2)

    <font color=red>Cont...</font color=red>
    Now we need to test the single print option on their machine.
    Apparently their printer is able to print to 3x5 index cards and cardstock (they claim)
    What would be the best way to send a print?
    Publish it in Word, or keep it in the Access report.
    I'm having difficulty defining the size parameters of the report to a CUSTOM size.
    I'm thinking Word may be the answer.
    Is there something I'm over looking?
    (Ooops...no way of moving the graphic with the data) Back to the Access options

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: No brainer for most. (ACC97 SR2)

    If you're going to print on 3 x 5 index cards, think Address Labels.
    Set up your report in Access using the Address Labels Wizard (don't know the exact phrase in English). Probably, the exact type of card is already defined.

  6. #6
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: No brainer for most. (ACC97 SR2)

    I attempt to set it up to use an index card, but it grabs the printer settings and formats the page to 8.5x11 everytime.
    Plus, I've already achieved the delicate balance of graphic and name spool and I don't want to redesign the wheel.
    I'm thinking this is moot, because the print call has to recognize the print device.
    Since none of our network printers are set up to print index cards, the paper size is not available for my test,
    but should be when the customer calls their local printer.
    Thanks for the HELP

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: No brainer for most. (ACC97 SR2)

    You nailed it. Access reports can only be formatted based on available printers. If the printers don't support odd sizes, you won't be able to format reports to support them either.
    Charlotte

  8. #8
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: No brainer for most. (ACC97 SR2)

    But you can install the printer driver without having the printer.
    This will allow you to create the report.
    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •