Need command button to amend query

[Mikey C]

Hi all!

I'm trying to find out how (or if possible) to create a command button
which will open a specified query so that it can then be edited by a
user. I already know how to open the database window from a command
button but I don't want general users to have access to that!

I have created a function which can produce a graph in access but to
narrow down the values, a background query is required. Rather than
creating a completely different query for each chart required, it would
be much simpler if users could just amend the main chart query.

Thanks for you help

 

[Renster]

Mikey,

This sounds very similar to what I am currently trying to achieve.

This may not help you, but I have added combo boxes for the 2 main
fields in my query.

The options in the 2nd combo box depend on the value from the 1st, and
once both are selected, I can set my graph. So I use the "onchanged"
event in the first combobox to set the rowsource in the second, and the
onchanged event in the 2nd to set the rowsource property of my chart.

This is probably much simpler than the query you are constructing - but
maybe you could Identify "core" parts of the query that dont change,
have some combo boxes, or maybe text boxes to allow edits to the other
parts, then a button that puts them all together, and sets the
rowsource of the chart?

Just my 2p. Probably worth a lot less anyway!

Cheers

Steve

 

[Mikey C]

That sounds like a good idea - I will try it out!

Thanks Steve