Page 1 of 2 12 LastLast
Results 1 to 15 of 27
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pulling data from another table (2000)

    Long ago I worked in a database called Smart. It had the greatest feature. If you typed the Product number into a field either Sales, Purchases, or Manufacturing, it would pull up the name and the cost for you from the Inventory table. As powerful as Access is, I'm sure it could be made to do this. How???
    I loved this feature. I want this feature. Please help.

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

    Re: Pulling data from another table (2000)

    Access doesn't have a directly comparable feature, AFAIK.

    You can place a combo box on a form that lists all products (or product numbers); selecting one makes the form display the corresponding details. Such a combo box can be created using the Combo Box Wizard.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pulling data from another table (2000)

    Thanks Hans. Unfortuneately, this doesn't do what I had in mind. I'm so disappointed. <img src=/S/disappointed.gif border=0 alt=disappointed width=15 height=15>

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

    Re: Pulling data from another table (2000)

    To simulate the behavior you describe would be a lot of work. Your form would have to be unbound (i.e. without a record source). You'd have to write VBA code to populate the form from a table, and to save the data to the table, and to let the text boxes respond to entering data - you'd have to find a way to distinguish entering/modifying data and entering a search code.

    Although I understand that the feature you describe is useful, perhaps you shouldn't spend a lot of energy in trying to make Access behave like another program, but try to use the built-in features instead.

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

    Re: Pulling data from another table (2000)

    Keep in mind that many database products have nice features built in, but the products are not necessarily programmable or even very flexible. Access is built to allow you to create the features you want using code and the Access interface objects. There's no way every handy feature someone might have used elsewhere could have been built into the product and still have it fit on a hard drive and load within a week. <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15>
    Charlotte

  6. #6
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pulling data from another table (2000)

    Are you saying that it would populate fields for data entry, or just a search feature?

  7. #7
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pulling data from another table (2000)

    It would populate the fields. The end user had to first create a link, which involved only clicking on buttons and identifying the linked field. Then, depending on what fields were in your new table, you had only to type the data for the linked field and the other fields would be populated. I used it to cost out manufactured items among other things.

  8. #8
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pulling data from another table (2000)

    Okay,
    So -- what features would take the place of this handy tool? My situation is that I have a monthly download of "Reports generated" by Employee number. I need to add Employee name and SSN to this on a monthly basis. Then keep track in one table all reports issued in the fiscal year.

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

    Re: Pulling data from another table (2000)

    You said you used that feature "long ago", so what have you been doing recently instead?
    Charlotte

  10. #10
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pulling data from another table (2000)

    Hi Charlotte,
    I really can't argue with this. I do want to say that the feature I described is probably the one most useful feature I have ever found in a database. You can't blame me for hoping there was a way to get it done in Access.
    I also want to point out something you and the other experts might have forgotten. When all you have is the unaltered Access database and it's help function, and you don't know VBA, there are a lot of wonderful things that Access will do, that you as an enduser, NOT a developer, can not make it do.
    I'm grateful that this board exists, and has patient, knowledgeable people to teach me.
    <img src=/S/hugs.gif border=0 alt=hugs width=41 height=25>

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

    Re: Pulling data from another table (2000)

    If you create a query that looks up data in the related table, and use that as record source of the form, you will come close to the feature you want. I have attached a very simple demo based on the Products and Categories tables from the Northwind sample database (in Access 97 format, zipped).

    If you open the form, you will see data from the Products table. The category description, however, is from the Categories table. If you select another category from the combo box, you will see the description change automatically.
    Attached Files Attached Files

  12. #12
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pulling data from another table (2000)

    A lot of typing. And Copying and pasting.
    Actually, the need for this as only recently become urgent. Until a couple of months ago, the information was all on the mainframe. I'm trying to get the information into Access in a format that can be manipulated to create graphs, and a variety of reports.
    "Long ago" I was keeping track of my husbands custom jewelry business. He hasn't done that for a while.

  13. #13
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pulling data from another table (2000)

    Thanks! I'm going to check this out right away. <img src=/S/exclamation.gif border=0 alt=exclamation width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  14. #14
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pulling data from another table (2000)

    Sounds like you need an unbound process to 'pull' data from a recordsource, and dump it into your current form. That's not too difficult to do. Hey, did you ever read that VBA tutorial I wrote? It does get into Recordsets....at least the very basics.

  15. #15
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pulling data from another table (2000)

    Well, just judging from how it sounds that does seem to be what I need. I have read part of the tutorial you sent. Work keeps interfering with my learning experience. Recordsets, huh? I'll take a look and see what it says. They also bought for the department the Access 2000 Developers Handbook. It lives on MY desk. I'll check in it and see what I can find. At this point, it is a bit overwhelming. More than half the battle is knowing what to look for.
    Lady Gnome

Page 1 of 2 12 LastLast

Posting Permissions

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