Search results

Let's have a New Years cocktail and check this out at a later time ;-)

The pasted in sql shows error at the "yyyy" ?

The query was working fine .... how cud that cause an error when referring again to its name ?

This clears the Table, inserts records for all of a customer's job where there is Labor. Then, inserts records into the table where a year/week# had NO labor, and then the final step will be to UPDATE the records in the Table WITH THE MATERIAL AMOUNT - WHERE there is ALREADY a record for the...

SELECT materials.customer, DatePart("yyyy",[purchasedate],7) & DatePart("ww",[purchaseDate],7) AS YearWeekNumber, Sum(materials.extended) AS SumOfMatl FROM materials WHERE materials.customer=[Forms]![SelectCustBobsWeekly].[simcust] GROUP BY materials.customer, DatePart("yyyy",[purchaseDate],7)...

err 3061 - too few parms , expected 1

My Bad, this is line it errors out on: ' *** CODE ABORTS AT THE NEXT LINE *** Set rstquery = db.OpenRecordset("weeklytotalMatl")

HAPPY NEW YEAR TO ALL!! Can anyone quickly see why the code aborts at the debug line ? Private Sub Command2_Click() DoCmd.OpenQuery "weeklytotallabor" DoCmd.OpenQuery "weeklytotalmatl" ' get weekly totals of labor + materials for CUSTOMER DoCmd.RunSQL ("delete * from weeklygraph;")...

I think that shows (according to the legend) that I am also plotting the WEEK# as well as the Labor Amounts. Not sure how to remove it, so I may have to rebuild the graph from scratch. You found it !!

This is a report graph in 2016 format

Awesome, perfect, fixed, thanks and Merry Christmas!!

Makes perfect sense. How can I prevent using the 'modern' feature ? Is that done by checking the 16 Graph reference?

That is NOT checked on my PC but the graph still works ?

I have a report with a couple of text fields above the graph. The report has no source, but the graph below the textboxes has a query as the source. When I run the report on my laptop (vers. 2016), the whole report looks fine in the Preview. I shipped the whole database to a user but when the...

Thanks theDBguy - U gave me confidence and looks like I got it !!

You make it sound so easy ..... Could I leave one source in the combo field definition and provide IF vba code to select the values from a different source ? Or, maybe it wud be simpler to hard code the "other" values in the VBA to avoid the SELECT issues?

Is there a way to load a bound combo box using IF statements in VBA? I am trying to load the combo box from a field from 2 different tables - depending on the value of a preceding field. Possible ??

I changed the code to a Function and that seems to correct this. Could that be it? Really confused on sub vs function ...

Have not figured that point out just yet. Now, I just open the module and click the "run" which executes it. Not too smart about all that "integration" yet but maybe it will/has to be run from a Macro ?

How's that Christmas Tree lookin' :)