Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auto Complete (Access 2000)

    Hello,

    I have developed an
    Louise

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

    Re: Auto Complete (Access 2000)

    It would certainly be more efficient to create a Customers table and use that as Row Source of the combo box (with Row Source Type set to Table/Query).

    If you do that, there are several possibilities:

    The combo box could have multiple columns, of which only the name column would be visible to the user. The text boxes on the Contact Info tab would have a Control Source referring to the other columns, for example

    =[cboCustomer].[Column](2)

    (this actually refers to the 3rd column, for column numbers start at 0 for the first column.)

    Another possibility would be to create a query that joins the orders table to the customers table. If you select a customer for an order, the rest of the customer's info is filled in automatically.

    If you would rather stick with the Value List, you can use code in the After Update event of the combo box to fill in the contact info, but it would be a lot of work. I think it is worth the trouble switching to a Customers table.

    <img src=/w3timages/blueline.gif width=33% height=2>

    How to attach a screenshot: you can make a screenshot without any special software: press PrintScreen to put an image of the entire screen on the clipboard, or Alt+PrintScreen to put an image of the foreground window on the clipboard. You can then paste the image into any graphics program, such as Paint (comes with Windows, in the Accessories menu), or Microsoft Photo Editor (comes with Office), or IrfanView, or whichever program you prefer. You can crop the image to display only the essential part (we prefer images to be no more than 640 by 480 pixels), then save it as a .png, .jpg or .gif file (.bmp is usually too large). In my experience, .png is best for screenshots. The image file should be less than 100 KB, otherwise you cannot attach it.

    When you are composing a post, you can enter the path/filename of the file in the 'Attach a file' box, or click the Browse... button to the right of it. If you preview your post, the attachment box will be cleared. so you must specify your attachment just before you actually post it.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto Complete (Access 2000)

    Hi Hans,
    Thanks for the info. I will try the few things that you suggest.
    I have attached a picture so you can "see" what I was talking about:

    After looking at the printscreen, maybe some other ideas will come out.


    Thanks again
    Louise

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

    Re: Auto Complete (Access 2000)

    Microsoft Access comes with a sample database Northwind.mdb. The Orders form demonstrates the second approach I mentioned: the record source of this form is a query based on the Orders and Customers table. When the user selects a customer, the details for this customer are filled in automatically.

    It might be a good idea to have a look at the Northwind database before changing the design of your database.

  5. #5
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto Complete (Access 2000)

    Great! Will look deeper into that database and see how they did that. My experience so far is just with simple databases.

    Thanks,
    Louise

Posting Permissions

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