Recent content by SMatthews

Sub TestforOutlook() Dim objOutlook As Object On Error Resume Next Set objOutlook = GetObject(, "Outlook.Application") On Error GoTo 0 If objOutlook Is Nothing Then MsgBox "Outlook not running" Else MsgBox "Outlook is running" End If End Sub Retrieved from...

I'd guess that you need to use sumproduct. I'd have a place to define your date ranges. For example, you define your ranges in Row 1 and Row 2 (start, end) where A1 is the start date for period one, B1 for period two, etc., and A2 would be the end date of the period. From there you use...

Can you have two tables, one for Verbal quotes and one for Proper quotes? If not, you could make another field in the table you have and give every entry a unique identifier. You could then store "verbal" or "proper" in a separate field.

Why don't you just save the report as an Excel file to begin with?

Get rid of the comma after [Store Data].* and put a semicolon at the end of the SQL statement.

You could setup a cross reference table that contains the forecast week (1-52) and the corresponding calendar week. Then you can join the two tables on forecast week and query for results where the calendar weeks are equal.

You could use the countif() function. You can have it count the number of times "h" is in the defined range. i.e. =COUNTIF(A1:G10, "H")

Check out the PMT and NPER functions in excel help.

Change the OR to AND.

Did you create a table with the fields listed in the code?

Try this. Pat Hartman wrotea function that I believe should help you out. It will creat a table that will list table name, field name and all field name attributes. Let me know if this helps. http://www.access-programmers.co.uk/forums/showthread.php?t=9790&highlight=Loop+TableDefs+collection

No problem. Make sure you remember to turn those warnings back on at the end of your macros and procedures. :)

Turn your warnings back on. Let me know if that works.

Change your criteria from [Enter Serial Number] to Like [Enter Serial Number] & "*"

Check out this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=94510 and/or this link: http://databasejournal.com/features/mssql/article.php/10894_2244821_2 (original link was wrong) Let me know if these help.