Recent content by ckell23

PNGBill, thank you again for your willingness to help out. I was able to get everything to work through the use of several queries and dumping info into a Temp table. I know that there are more efficient ways of achieving the same result through VBA code where the recordset is built on demand...

PNGBill, thank you again for your input. Unfortunately, we need to plot both the actual price change events that are stored in the tblPriceHistory Table AND the January 1 value for every year that the product has been in existence. I will try playing around with your suggestion of making the...

Thanks PNGBill. I certainly would appreciate any help you can give to writing that sql statement. I've attached a stripped down version of the database and form that has the current unit price history chart. To reiterate what I need to display... the price history currently shows only a...

I have a table where I am storing the entire Price History (tblPriceHistory) of each product being sold. The table is very simple. Contains the following fields: ProductID, UnitPrice, BeginDate, EndDate. On one of my forms in the database, I currently have a Line Chart that displays the price...

Makes sense. There is a line of code at the end that deletes that query, but there must have been a problem with the path name which caused the code to stop before finishing out the last steps. Got it going now. Thanks for the ultra quick replies!

I'm stumped on this error message. I modified this code from samples provided on another website and had things working fine. Do not recall making any changes to the code, but now it is not working. No references to Run-time Erro 3012 anywhere. Private Sub cmdExportToExcel_Click() Dim dbs...