Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    making an access panel (access 2000)

    i was wondering how i could make an access panel that a person could type in a name and have a form come up from it.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: making an access panel (access 2000)

    What do you mean by an "access panel"?
    Also what are you after when you say you "type in a name and have a form come up from it."

    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    New Lounger
    Join Date
    Feb 2003
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: making an access panel (access 2000)

    is there a way to create a form like this that would be the main interface instead of a switchboard?

    ENTER CLIENTS NAME HERE TO RETRIEVE FORM: ( clients name gets entered here)

    then following the entry of a clients name the form box would pop up for the user.

    i think that i need to create macros for a form made in design view, or possibly by coding it in visual basic.

  4. #4
    New Lounger
    Join Date
    Feb 2003
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: making an access panel (access 2000)

    this is a address data base for my works clients , and i need a form /interface that would allow for the entry of a clients name to open up a form that has that specific cliets information on it. this should be pretty simple however I am having difficulty finding how to create such a form.

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

    Re: making an access panel (access 2000)

    Do you really want a separate form to pop up? The following alternative keeps everything in one form, and has the advantage that it can be created almost entirely by wizards.
    1. <LI>Use the Form Wizard to create a columnar form based on your clients table.
      <LI>Open the new form in design view.
      <LI>Make the Form Header section about half an inch high.
      <LI>Make sure the Toolset is visible (View/Toolset).
      <LI>Make sure the Control Wizard is on (the second button on the Toolset - the one with the magic wand - must be down).
      <LI>Click the Combo Box button, then click in the Form Header.
      <LI>Select the third option in the Combo Box Wizard - find a record etc.
      <LI>Click Next.
      <LI>Select the name field and click the ">" button to place it in the list of selected fields. If you wish, you can add more fields.
      <LI>Click Next.
      <LI>Adjust the column width(s). Keep the "Hide key column" checkbox checked, if it is available.
      <LI>Click Next.
      <LI>Type a caption, for example "Select Client".
      <LI>Click Finish.
      <LI>Close and save the form.
    You should be able to use the combo box to find clients now, without writing any code. If you are interested, you can look at the code the wizard has generated.

  6. #6
    New Lounger
    Join Date
    Feb 2003
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: making an access panel (access 2000)

    thank you very much, I still have not learned all the intricasys of this program. You have saved me from a big headache figuring this out

Posting Permissions

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