Search results

Hello all, I hope someone can help me with this question. I have a database set up similar to the frmCombo1 that is in Northwind's sample database. However, instead of using a list box, I would like to use a subform. The idea being the user will select options from 2 combo boxes and the subform...

Charity, You are wonderful to offer to help. An e-mail is on the way. Thanks!!!

I'm going nuts trying to create this form and I've gone thru all the Access examples for help. There does not seem to be a problem you guys can't solve, so I'm begging for help! I'll do my best to describe my situation: I'm working with a horrible database and need a form that uses 2 of the...

Thanks for the help!!!

I have a very simple form where the user selects a part id from a drop-down box and a subform displays all the matches. Some parts have quite a few matches. Then they can scroll thru the subform, select the part they want, and make changes to the data. (The subform is just text boxes pulling...

Actually, that would be perfect. It really doesn't matter where the subform comes from. But how do I set up the form with the data from 2 different tables without creating a relationship with a query? It's just one field from the second table that I need - but I have to have that field since...

It's the query - everything else it set correctly. All the fields in the query come from one table, with the execption of one field. That why I had to create the query - so I could get that one other field in the form. But once I do this, I can't update the info. Any other ideas on how I could...

I have a form with a subform that pulls from a query. What we want is for the users to be able to make changes to 2 of the fields in the subform (which in turn would update the table). Anyone have any ideas of how this could be done? I would really appreciate it!

You are correct - it is more than one table. I have been creating queries to get the data together. Unfortunately, the data in the tables is being pulled from another software - it's made it pretty difficult to work with! After I created the queries, I was able to get the product, then product...

I have been reading thru all the posting but I can't find anything that exactly works for this situation. I have 3 items - Product, Prod Description and Product Size. There are multiple product descriptions and multiple product sizes for each product. I have the first combo box set so the...

Kevin, You are a genius! This worked like a charm and was exactly what I needed! You just saved me a ton of time. Thanks!

I have a form set up with multiple option buttons for the user to select a report to e-mail. The final option button is for the user to select "all" reports to e-mail. I am using Select Case and then on the "all reports" case, it has a DoCmd to open each report one at a time and send each via...

I have a database with sales reports for various salespeople. I have it set up so each report can be e-mailed, but I want the users to have the ablitiy to e-mail all the sales reports on one e-mail. I cannot find a way to e-mail multiple reports. Any help would be greatly appreciated!