Recent content by pony08

I appreciate the redirection!

I have a combo box in a form that is used to populate one of the columns in a table. How do I get the description to appear in the table instead of the primary key?

Thanks....That is a big help!

I have a report that I would like the Page Header to appear in the following page if the data that goes with it continues to another page. Are there any settings or code that can accomplish this?

There will be records in ProductInformation_Consumer table that are not the Attributes Table.

How can I modify the below code so that it only adds new records to AttributesTBL from ProductInformation-Consumer? Thx INSERT INTO AttributesTBL ( Material ) SELECT [ProductInformation-Consumer].Material FROM AttributesTBL INNER JOIN [ProductInformation-Consumer] ON AttributesTBL.Material...

Excellent....Thanks!

How do I modify the after update event?

I would like to have a macro run when I click off of a combo box. The combo box has dates by Quarter and the macro refreshes a pivot table. The pivot table is filtered by the combo box quarter selection.

thx...I will give that a try!

We want to flag any specs that change with a date so field staff know they need to review the revised spec sheets. Sorry typo

Yes...that is correct. It is involving specifications for SKU's. We want to flag and specs that change with a date so field staff know they need to review the revised spec sheets.

I need to build a Query that will look at a previous table and a new table and flag any changes...what is the best way to go about something like this?

Thanks....I will give it a test drive!

I am looking for a query that will single out a SKU with the maximum number of sales. I have a table that shows a SKU's material code, sales and SKU number. What I need the query to do is find the MAX sales, (1831 in the below instance) and return only the line with 0CXX2005300CP. Material...