Recent content by Rhabdo

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