filters

  • Thread starter make a VBA to export pivot chart to word
  • Start date
M

make a VBA to export pivot chart to word

hello i am trying to apply filters to a subform only and a form only too, so
that everytime i open either form, the last filter used is automatically
saved anytime the form is opened. i tried creating a saved filter query for
the subform however whenever i clicked on the main form, a parameter box came
up everytime wanting me to apply a filter yet i want the parameter for only
the subform. Better yet if i didnt have any parameters but just had my
filters saved so that whenever i clicked on the main form which includes my
suibform i would have my last saved filter.
 
K

Klatuu

Use the acSaveYes option when you close the form. It will save all changes
made to the form so the next time you open it, the last filter you set will
be in place.
 
M

make a VBA to export pivot chart to word

thanks but where in the form will i put that...will it be in the main form or
the subform and what "event" name or where in "properties" do i change to yes
 
M

make a VBA to export pivot chart to word

It didnt work..it opened up the VBA window and what i cut and paste the code
u gace me didnt work. it highlighted it as yellow. i put it in the "on close"
event
 
K

Klatuu

Glad you got it working. Don't know why the example I sent you did not work.
It was copied directly from Access Help. Ijust changed it to say MyFormName
so you would know where to put the name of the form you want to close.
 
M

make a VBA to export pivot chart to word

Thanks i swear i hardly understand access help it trully just confuses me.
It sems u understand access fairly well. Have another question. i have a
chart made from pivot chart view how do i copy and paste the chart the way it
is in word. i have no interest in modifying it in word. if u know the ans to
this ur most definetely a genius!!
 
K

Klatuu

Sorry, guess I don't make genius level today. I have never done a chart in
Access.
 
M

make a VBA to export pivot chart to word

ok u might be able to help me out with this. when searching for records i
know that when you use "sales*" it returns any record starting with sales but
what if there are words or letters before sales for example "low sales" how
do i get that to show verses just showing "sales" or "sales price"
 
Top