Recent content by ristoner

I am wondering if it is possible to create a recordset and then execute an SQL statement using the recordset as a the data source and then, doing a create table and append table SQL statement, transfer the SQLed information into a new recordset. Then use the new recordset as a the record source...

I am trying to make this as user friendly as possible, because I am making this part of a larger database that will be used by people who don't really know how to use computers (seriously...margin adjustment is a huge deal). So I don't care how complex the code is, as long as it runs smoothly...

I am trying to print out address labels from a table of addresses and I need to print out multiple labels with the same address and don't want to add a bunch of repeat addresses. Is there a way to get the information to repeat and print out a sheet of all the same label? I am currently using a...

I tried to upload my database and it is to big even when zipped. As far as the P/N form, there can be 50 to 100 specs or materials so what I did was create a button that opens a form just for materials filtered by P/N so I only get one P/N at a time. When I put in drop down menus for the...

Thank you for the quick response. The only problem is that some part numbers use the same specs and material and I don't want to duplicate them by part number either. I would load the database if I knew how. Do I have to download a plug-in or something? Let me know, I'm still new at this, lol...

I have Multiple tables. For the sake of simplifying things there is one with Specs, one with Materials, and on with Part Numbers. There can be multiple specs for one part number and multiple materials for one part number. Is there any way that I can have all three tables have a primary key...