Evening all,
Here's the situation I'm in. At work we've been using Excel to create a Lease Return List. In this list there is the overall master list, a list for non returned computers and then a monthly list (all 12 months) of computers that have been returned by a certain date.
Here are the tables I have broken down into sections:
Lease Table:
Old #
<combo box Model Table here>
<combo box Type Table here>
<insert Employee Table here>
Order Confirmation
New #
New Computer Delivery Date
Refresh Docs Sent (checkmark)
Master Inventory Updated (checkmark)
Old Computer Returned (checkmark)
Not Returned (checkmark)
Purchased (checkmark)
Stolen (checkmark)
Comments (checkmark)
Model Table:
Model
Type Table:
Type
Employee Table:
Last Name
First Name
Employee ID
Dpt.
Loc. ID
Technician Table:
Technician Name
Tech Employee ID
Location
Shipping Table:
Lease End Date
Pickup / Shipped (either P or S)
RMA Number
Waybill Number
Erase Date
Erase Cert. Number
<combo box Tech Employee ID>
Here's the issues I'm having.
1) For some reason I'm not able to create a Recordset in the Database.
2) If Not Returned checkmark is checked I would like to populate a Not Returned Tab or another Form similar to #3 in a listbox.
3) If there is a certain date entered in the End of Lease field I would like that and Old #, last Name, First Name and a few other fields to populate either an End of Lease Month tab or another form in a listbox.
4) The full table will have all of the fields listed above on one sheet as a record. I would like to have a Listbox below that to be able to select a record quickly rather than just going through a list one at a time.
Now I'm guessing that 2, 3 and 4 are queries into separate tabs on OnClick() functions. But I could be wrong.
Here's the situation I'm in. At work we've been using Excel to create a Lease Return List. In this list there is the overall master list, a list for non returned computers and then a monthly list (all 12 months) of computers that have been returned by a certain date.
Here are the tables I have broken down into sections:
Lease Table:
Old #
<combo box Model Table here>
<combo box Type Table here>
<insert Employee Table here>
Order Confirmation
New #
New Computer Delivery Date
Refresh Docs Sent (checkmark)
Master Inventory Updated (checkmark)
Old Computer Returned (checkmark)
Not Returned (checkmark)
Purchased (checkmark)
Stolen (checkmark)
Comments (checkmark)
Model Table:
Model
Type Table:
Type
Employee Table:
Last Name
First Name
Employee ID
Dpt.
Loc. ID
Technician Table:
Technician Name
Tech Employee ID
Location
Shipping Table:
Lease End Date
Pickup / Shipped (either P or S)
RMA Number
Waybill Number
Erase Date
Erase Cert. Number
<combo box Tech Employee ID>
Here's the issues I'm having.
1) For some reason I'm not able to create a Recordset in the Database.
2) If Not Returned checkmark is checked I would like to populate a Not Returned Tab or another Form similar to #3 in a listbox.
3) If there is a certain date entered in the End of Lease field I would like that and Old #, last Name, First Name and a few other fields to populate either an End of Lease Month tab or another form in a listbox.
4) The full table will have all of the fields listed above on one sheet as a record. I would like to have a Listbox below that to be able to select a record quickly rather than just going through a list one at a time.
Now I'm guessing that 2, 3 and 4 are queries into separate tabs on OnClick() functions. But I could be wrong.
