If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating Record in Access
Background: I have a database with a single, linked table from a large excel
file and I am trying to add more functionality within the database. The file has information, based on part numbers, that needs to be updated. Question: What I would like to do is create a record form. The record would result from choosing from 5 different list boxes (manager, buyer, part number, destination and supplier). When you select the appropriate item from the list box, there is a command button above there that would find the correct record based upon the item. I.e., select "Supplier X" from the list, and all of the records from that supplier are accessable. Each record occupies a single page. Every time you roll the mouse one click, and new part for "Supplier X" appears. I already have a basic format that I want to use for the record, but what I can't figure out is how to make each box have the information linked to it. Things like destination, date due, promise date, need date, IPT, SWBS, PO number, Nomenclature etc. would "roll" each time you used the mouse button. All of this information is unique for each part, so approx 25 boxes would be linked. Sorry for the long question, and good luck with this one. Brian |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Unable to insert record to Access via SQL from an ASP page | Norman Yuan | General Discussion | 1 | February 2nd, 2005 08:23 PM |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |