Search results

It gives me an Error 3061. too few parameters. Expected 1.

thanks, i have been looking at that page, but i honestly can't see any difference in my code......

This is the code i have in the Module. As i said it works fine when i run a query directly off a table, but it will not work when i run it off another query? Public Function CondMedian(RstName As String, fldName As String, grpName As String) 'This function will calculate the median of a...

Hi, I have managed to successfully get the CondMedian funtion to work directly off a table, no problems. However, i have a form into which i can select start & end dates to query a specific time period and subset of the data. I thin try run a new query on this subset with the CondMedian...

I have been struggling with getting the syntax right for the ConcatRelate function. I have looked at other peoples examples and mine seems to have exactly the same syntax but it is giving me an error. My Sql is SELECT qr_RiverGroup.River, ConcatRelated("Site_ID","qr_RiverGroup","[River] = '" &...

Hi JHB, Thanks so much, i have also spent ages looking for a solution with no success yet. Something so simple in the end! Thanks, much appreciated :)

Anybody experience this problem before?

Hi JHB, thanks for responding again. I am trying to avoid re-creating the graphs as there are many and they require a lot of formatting. I have uploaded an example database with my problem. If you open fr_1 and select the info from the combo boxes then the chart will draw. However, the sites...

Hi, I have a chart in a form which gets its data from a cross-tab query. The chart was working fine and still is besides the fact the it is skipping the first row of data, or reading/treating it as a header. I had this problem before and the only way i could get around it was to re-create the...

Ok changed the code to: If Not [Forms]![fr_insitu_SurfaceWater]![GapORP] = Empty Then Me![g_ORP].Axes(2).MajorUnit = [Forms]![fr_insitu_SurfaceWater]![GapORP] and it seems to be working fine now. Thanks for all the help :)

Yes the form is open, sorry i see now it only happens when the txt box for ygap is empty; should i put an if not = empty in?

Thanks, sorry i changed the code to open the report directly into print preview and the min max values update fine. Awesome I am just having trouble with the interval, it gives me a run-time error 1004 Unable to set the MajorUnit Property of the axis class. Any ideas?works fine on the form.

It is giving me a run-time error '438' object doesn't support this property or method

This is the code from the Form which i use to update the y-axis scale and parameters as required based on the output of the query on which the graph is based. If Not Me![YminORP] = Empty Then Me![g_ORP].Axes(2).minimumscale = Me![YminORP] If Not Me![YmaxORP] = Empty Then...

Sorry just worked it out, in the Query Properties Top Numbers

Thanks that's working perfectly now. Could you help me to only display the first 12 rows Reason: input from the form is Year and Month and I want to graph 12 months worth of data. If the user selects May 2013 my query is set to run on >= 2013 and 5 (May) and hence displays all of 2014 monthly...

Hi vbaInet, Thanks seems like we on the right track here, but unfortunately i do not understand the syntax and there appears to be an error as it is displaying the code as well as the number See below). But i took out the first half of the code and it is now just giving me the numbehr which is...

Sorry again for the confusion, that is along the lines of what i was originally thinking of doing with a ROW or sequential number but i could not find a way to do it. Unfortunately what you suggest is not going to work: 2013 + 7 = 2020 2013 + 8 = 2021 2014 +1 = 2015 less than 2020 and hence...

I have the same graphs in the report as are in the form, use the scaling text boxes to modify the form graphs and use control buttons to run the code for each graph. I have tried putting the same code using the form text boxes as the sources into the 'on open' event for the report but this...

Sorry for the hassle but q_WQ_Rainfall_Dates is sorted ascending by year first then Month. The results of that query are below: yYear mMonth Monthly Total 2013 7 45 2013 8 101.8 2013 9 44.5 2013 10 139 2013 11 169 2013 12 27 2014 1 0 2014 2 13 2014 3 62 2014 4 128.5 2014 5 569 2014 6 202.5 2014...