Replies

Hans

Thanks for the advice, tried it and there is no change to the result I’m getting.

If nothing else I would expect a couple of error messages from some where, especially as I’ve now tried to force this by allowing null values to be used as inputs to the bookmarks in Word.

I’ve also tried replacing the form with a duplicate created from scratch as I’d seen that as a ‘solution’ for other odd VBA problems, same result from both forms, even after the decompile, recompile and compact and repair…

At least I now know how to decompile a project though, live and learn

Ian

Hans

Thanks for the advice, tried it and there is no change to the result I’m getting.

If nothing else I would expect a couple of error messages from some where, especially as I’ve now tried to force this by allowing null values to be used as inputs to the bookmarks in Word.

I’ve also tried replacing the form with a duplicate created from scratch as I’d seen that as a ‘solution’ for other odd VBA problems, same result from both forms, even after the decompile, recompile and compact and repair…

At least I now know how to decompile a project though, live and learn

Ian

Hans

Thanks yet again for a solution.

The idea didn’t quite work as I’m using subforms to display some of my queries, but did lead me to the forms own Filters property and the FilterOn.

I simply added an:-
if ‘x’ = ‘chkY’ then
me.Filter = “[mycontrolname] = -1”
me.FilterOn = True
Else
me.FilterOn = False
End if

Seems to be working fine.

Thanks

Ian

Hans

Thanks yet again for a solution.

The idea didn’t quite work as I’m using subforms to display some of my queries, but did lead me to the forms own Filters property and the FilterOn.

I simply added an:-
if ‘x’ = ‘chkY’ then
me.Filter = “[mycontrolname] = -1”
me.FilterOn = True
Else
me.FilterOn = False
End if

Seems to be working fine.

Thanks

Ian

Hans

Sorry. So busy explaining what I wanted I didn’t cover the basics….

The user’s checkbox will be on a form, the idea in my mind is that they click the checkbox on this main form, then click the one of the buttons to open the form which is populated by the one of the queries. This button has code attached to it that checks the checkbox status and either runs the standard query, or runs the query with the additional SQL to restrict it.

Thanks

Ian

Hans

Sorry. So busy explaining what I wanted I didn’t cover the basics….

The user’s checkbox will be on a form, the idea in my mind is that they click the checkbox on this main form, then click the one of the buttons to open the form which is populated by the one of the queries. This button has code attached to it that checks the checkbox status and either runs the standard query, or runs the query with the additional SQL to restrict it.

Thanks

Ian

Thanks Hans, I’d got a feeling it was something of that ilk, but for the life of me (well for my sanity any way) I couldn’t see it.

Ian

Thanks Hans, I’d got a feeling it was something of that ilk, but for the life of me (well for my sanity any way) I couldn’t see it.

Ian

(Edited by HansV to make URL clickable – see Help 19)

Hello

Sounds like the sort of problems I had getting a help file to work. Go to the site shown below and opt for the Cheetah software, it’s free and so simple i had my first working help file up and running, well limping, in 30 minutes.

http://www.thefreecountry.com/programming/…authoring.shtml%5B/url%5D

You’ll need the Microsoft Help Workshop as well.

Hope this helps.

Ian

(Edited by HansV to make URL clickable – see Help 19)

Hello

Sounds like the sort of problems I had getting a help file to work. Go to the site shown below and opt for the Cheetah software, it’s free and so simple i had my first working help file up and running, well limping, in 30 minutes.

http://www.thefreecountry.com/programming/…authoring.shtml%5B/url%5D

You’ll need the Microsoft Help Workshop as well.

Hope this helps.

Ian

Brilliant, works fine.

I also found the ChartWizard Method in the object browser, this does have the ‘template’ like many of the other Access methods, seems easy to use as well, as long as I arrange the original query sensibly.

Thanks

Ian

Brilliant, works fine.

I also found the ChartWizard Method in the object browser, this does have the ‘template’ like many of the other Access methods, seems easy to use as well, as long as I arrange the original query sensibly.

Thanks

Ian

Thought I might be back soon….

How do I set the axis labels? I know which column they will be in, but can’t see what to use. There are a few items in the object model that look like they might, but I’ve had no luck with them as they don’t seem to provide the ‘template’ to fill in as many of the Access parts of VBA do…

Thanks

Ian

Thought I might be back soon….

How do I set the axis labels? I know which column they will be in, but can’t see what to use. There are a few items in the object model that look like they might, but I’ve had no luck with them as they don’t seem to provide the ‘template’ to fill in as many of the Access parts of VBA do…

Thanks

Ian

I made the post after about an hour of staring at the code, decided to have one last look and the error leapt out at me . I new you’d receive the original as an email, but was hoping I’d get the errant code removed before you got back…..

My humble apologies for wasting your time.

Ian