Stand alone programme question

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • William Bradley

    #1

    Stand alone programme question

    First of all thank you to all those who have helped me in the past, as I
    have stumbled along with MS Access 97.

    My question this time is more of a general one in nature. It seems obvious
    to me now that what the client needs is a stand-alone programme. To that end
    I have begun looking at menu building and the like. What I need to know, and
    this may be a real dumb question, is this: I have a form, that writes to a
    table. From that table I need to generate a bin label and a QC document. I
    would like the operator to be able to use a menu to bring up the form and
    modify the table as needed. Then from that same menu print a bin label from
    that table only, and a QC report, from that table only. Can this be done??
    I'm sure it can it is just that I need to find my way to doing it.

    Any help appreciated,

    Bill.



  • Albert D. Kallal

    #2
    Re: Stand alone programme question

    Of course in any good application, your users will never edit or use the
    tables directly.

    As for placing a button on a form to printout the current record, that is
    quite easy.

    the code behind the button called "QC document" could be:


    me.refresh
    docmd.OpenForm "QCReprt",, ,"id = " & me.id


    --
    Albert D. Kallal (MVP)
    Edmonton, Alberta Canada
    kallal@msn.com



    Comment

    • William Bradley

      #3
      Re: Stand alone programme question


      "Albert D. Kallal" <kallal@msn.com > wrote in message
      news:L0o6b.1050 91$la.2380552@n ews1.calgary.sh aw.ca...[color=blue]
      > Of course in any good application, your users will never edit or use the
      > tables directly.
      > As for placing a button on a form to printout the current record, that is
      > quite easy.
      > the code behind the button called "QC document" could be:
      > me.refresh
      > docmd.OpenForm "QCReprt",, ,"id = " & me.id[/color]

      Thank you for this, Albert. I will give it a try.

      Bill.


      Comment

      Working...