Beginner Needing Help

[Avaldez21]

I was assigned a project to track who did what to certain drawings. I initially did it in excel because it was a small project and I knew that excel could do it. Now that it worked well I was assigned to expand and create it in Access so we can track work done to drawings from more than one project. In excel I used a pivot table to create the list of drawings. The user would only have to select the drawing number and it would bring up the given information (rev#, drawing name, etc.). I have never opened Access before last week but I have imported the information needed, created a query so it only looks up the information I need, and created a form but the user has to scroll through the hundreds of drawing numbers to get the one they want. My questions are:
1) Can I create a form around a pivot table where I have multiple txt boxes for user inputs?
2) Is there any other way to have the user access multiple projects (each with their own set of drawings) from one form or do I have to create a form for each one and just give the user the option of which one he/she wants from a switchboard?
3) Any other ways I can make this work?

I'm sure I will have many more questions as I go on but any advice will help. Also, if I did not explain something clear enough let me know and I will try to explain it as best I can.

Thanks,
Aaron

 

[tehNellie]

1) I guess so, I don't think I've ever used a pivot table in access so I'll defer on this one.

2) Yes, if your table structure is set up properly then it should be relatively simple to code, for example, a drop down box to select the project, a second one to select the image based on the project and so on.

3) Yes. Somewhere I've got a bunch of Bash scripts I wrote for an aerospace company to manage 250k odd images across multiple projects, but I'd suggest doing it in Access is probably easier on the user.

 

[Avaldez21]

How can I create the code for a simple drop down list. This is exactly what I'm looking for but have no idea where to start with it. Any point in the right direction would be greatly appreciated.

 

[ozinm]

Hi ya.
what do you want the dropdown list to do?

 

[Avaldez21]

I want it to bring up the selection of project number and then the next one to bring up the given drawing numbers for that selected project number.

 

[neileg]

Search in these forums for cascading combo. This allows the selection in one combo to determine the contents of a second.

 

[Avaldez21]

Okay thank you!