Search results for query: *

That works!!! Thanks for all of your help! [thumbsup]

lameid, I liked your idea; unfortunately, the page footer is still not showing up on page 2. Again, I am confused as to why the code does not work because when taken through the debugger it appears that it should be working as intended. Thanks for the idea...I'll be sure to post if I figure...

I have created a report with 2 grouping levels - FSID & Department. I labored long & hard to find code so that the page header and footer would not display on the initial page of each FSID grouping. My code nearly works...except on page 2. Below is my code: Private Sub...

How are your calculations working? If the calculations are based off of controls in reports or forms in your database, you can use the if statement in the expression builder instead of in vba code.

Thank you very much to everyone for the input! I very much appreciate different ideas to solve the same problem. To answer your question MichaelRed, the output is in a report. I'm not sure if I completely understand how to set the control properties when the control is instantiated; however...

Hi, I am working on a database that's main purpose is to output financial metrics. My problem is that not all metrics are formatted the same. For example, Advertising as a % of Gross Profit is a percentage, while Gross Profit per unit is Currency (with no decimal points). I have a table that...

I have written code to update the [Date] field of a table. According to Debug.Print, my SQL statement appears to be retrieving the correct information, but when I open the corresponding table, the date entered does not match. My code is strSQLUpdate = "UPDATE tblTotalDealerMetrics " & _...

Just would like to thank you for your help. The reason I was getting that goofy message box was I had a divide by zero error in code previous to the SQL statement. At least I believe that was the problem, since once I got ride of that error my SQL statement worked, and I was able to get the...

Thanks for the advice - but I seem to be having problems understanding how Debug.Print works (I'm new to using VBA & Access), as I can't get it to print my SQL string (nothing shows up in the immediate window). strSQLCreate = "INSERT INTO tblTotalDealerMetrics([FSID]) " & _...

FSID = 1

Thanks for the quick reply. However, when I use this code and try to run the code Access gives me a message box with the following "Microsoft Access can't find the field '|' referred to in your expression." I was assuming this was due to some sort of syntax error, since [FSID] matches the...

I am working on an access database where my queries are performing multiple calculations for financial analysis. In order to do these calculations, I have used the DLookup function and assigned the result to a variable and then performed calculations with these variables to get the financial...