How to assign items in a list box to a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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,
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 said:
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.
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.
Click to expand...
Click to expand...
 
Back
Top