Tutorial for simple Form accessing 2 tables?

[Guest]

Howdy

I've never used Access to do programming before but I think that will be the easiest solution for us. If someone can recommend a couple websites I could go check out to get information on how to do this, that'd be great. I have programming experience with Javascript which I think is close to VBScript but have never used the Excel programming functions before

Here's what we want to do

We want to have two tables/sheets/whatever. 1) List of items we have in our office avilable for checkout 2) List of who checked out what and when. Sheet 1 woudl jsut have Item ID, Tag Number, Item Type. Sheet 2 would have Item ID (from sheet 1) User name, User ID, Date stamp

I then would have a form that would be used to check things in and out. It would probably have a dropdown list to choose Item Type and then have a second box with Item IDs from that type. Then some text boxes to enter the user's information. Finally a Check Out (or in) button. This button would then write the data to Sheet 2

So the only programming would be having the initial sheet populate with a list of item types from Sheet 1. Then having the second boxpopulat with Item IDs once the Item Type has been selected. Then checking that item to see if it's currently checked In or Out

The rest of the coding would be to just write the data to Sheet 2

Any help, guidance, tutorials, etc would be great

Thanks!

 

[Debra Dalgleish]

To create the dropdown lists, you can use Data>Validation. There are
instructions here for dependent lists:

http://www.contextures.com/xlDataVal02.html

You could record the steps as you copy an item from the data entry form,
and paste it into the check out list. That would get you started on the
VBA code, and you post again when you need specific help with that.

David McRitchie has information on getting started with macros:

http://www.mvps.org/dmcritchie/excel/getstarted.htm