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
|
|||
|
|||
How to assign items in a list box to a record
Hi all...need some help big time! I'm doing a personnel record checkout
tracking database. I created 2 listboxes. The first has the fields: pay grade, name, and employee ID of all employees in the company. The second will contain selected records that I transfered over from the first list box. That part of the databse is done. Here's the idea: When Joe Blow comes down the to record section as asks to check out 10 employee records, I hand him all 10 records then I go into my database, select the 10 records in the first list box, press a command button that sends the 10 records over to list box 2. Here's what I don't know how to do: How do I assign those 10 records to Joe Blow? And if Mary Jane needs 13 records to check out, how do I do the same for her? I want to be able to pull a report that shows who has checked out what records. And eventually when that's worked out, all records are due back within 72 hours. I would like to program some type of notification to let me know these records are over due. I'd appreciate any type of help...thank you. |
#2
|
|||
|
|||
Take a look at the "Select Records" example on my website:
http://www.daiglenet.com/MSAccess.htm. This is a simple example showing how to assign Students to Classes or Classes to Students. I think it will help you get started. The main difference is that in my example I have three tables, Students, Classes and StudentClasses (I think those were the table names). I think you will have only two because I would assume that the people checking out records are also employees. So your tables might be Employees and RecordAssignment. RecordAssignment would have EmployeeID and AssignedToID (which would hold the ID of the Employee to whom the record is assigned). -- Sandra Daigle [Microsoft Access MVP] For the benefit of others please post all replies to this newsgroup. AccessDummy wrote: Hi all...need some help big time! I'm doing a personnel record checkout tracking database. I created 2 listboxes. The first has the fields: pay grade, name, and employee ID of all employees in the company. The second will contain selected records that I transfered over from the first list box. That part of the databse is done. Here's the idea: When Joe Blow comes down the to record section as asks to check out 10 employee records, I hand him all 10 records then I go into my database, select the 10 records in the first list box, press a command button that sends the 10 records over to list box 2. Here's what I don't know how to do: How do I assign those 10 records to Joe Blow? And if Mary Jane needs 13 records to check out, how do I do the same for her? I want to be able to pull a report that shows who has checked out what records. And eventually when that's worked out, all records are due back within 72 hours. I would like to program some type of notification to let me know these records are over due. I'd appreciate any type of help...thank you. |
#3
|
|||
|
|||
Sandra,
Thank you for your post. I appologize I couldn't thank you earlier but i've been just running into some bad luck. My DSL modem got fried (just got a new one last night) and for some reason, I could not get to this page from work...come to find out my permissions were accidentally change. Argggh! Anyway, I'm about to take a look at your website to see if I can figure this stuff out. Once again, sorry for the late reply and thanks a bunch! "Sandra Daigle" wrote: Take a look at the "Select Records" example on my website: http://www.daiglenet.com/MSAccess.htm. This is a simple example showing how to assign Students to Classes or Classes to Students. I think it will help you get started. The main difference is that in my example I have three tables, Students, Classes and StudentClasses (I think those were the table names). I think you will have only two because I would assume that the people checking out records are also employees. So your tables might be Employees and RecordAssignment. RecordAssignment would have EmployeeID and AssignedToID (which would hold the ID of the Employee to whom the record is assigned). -- Sandra Daigle [Microsoft Access MVP] For the benefit of others please post all replies to this newsgroup. AccessDummy wrote: Hi all...need some help big time! I'm doing a personnel record checkout tracking database. I created 2 listboxes. The first has the fields: pay grade, name, and employee ID of all employees in the company. The second will contain selected records that I transfered over from the first list box. That part of the databse is done. Here's the idea: When Joe Blow comes down the to record section as asks to check out 10 employee records, I hand him all 10 records then I go into my database, select the 10 records in the first list box, press a command button that sends the 10 records over to list box 2. Here's what I don't know how to do: How do I assign those 10 records to Joe Blow? And if Mary Jane needs 13 records to check out, how do I do the same for her? I want to be able to pull a report that shows who has checked out what records. And eventually when that's worked out, all records are due back within 72 hours. I would like to program some type of notification to let me know these records are over due. I'd appreciate any type of help...thank you. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I assign contacts from my contact list in a new list | Classic | Contacts | 2 | January 12th, 2005 04:07 PM |
Distribution List vs. Contact Items Folder | MEG | Contacts | 1 | December 9th, 2004 09:44 PM |
Two line items in drop down list. | Ripperdan | Tables | 1 | October 18th, 2004 06:11 PM |
Randomly selecting items from a list given their statistical likelihood | MACRE0 | General Discussion | 1 | September 22nd, 2004 02:29 AM |
assigning items from a list of 1000 to a form field | sek0910 | Database Design | 1 | August 10th, 2004 02:24 PM |