Search results

this the code for the working parte (numeric field on table) This is the code for the "numeric" version: TRANSFORM Sum(tab1.numeric) AS SommaDinumeric SELECT tab1.ID_tab, tab1.mansione FROM tab1 GROUP BY tab1.ID_tab, tab1.mansione PIVOT tab1.IdAnno;

how to make a crossed field query with text "value"? Hi, first of all sorry for my english. I need to create a crossed field query like in the file I uploaded but instead of count values of "qualifica_man" have to show me the text. I can do it but only that field is (on the table) a number...

Hi Chris! I worked on your file... but I had some problems. is it possible to make that when the mask applyfilter works without i change any value on green boxes? (in my file it will filter by "2011"). (I tryed to make it putting a call apply filter on opening or launging event but it give me...

it work perfectly! I hope to be able to use your code for all my forms and subform. the next one have the button that i was trying to put the call into. but maybe with your filtr instruction i can avoid it. In this case the problem is that I have a form based on a crossed fields query. this work...

I have tried to write that code for a week... peoples on many forums say me "it is so easy! write it by yourself!... or give me the code but once i put it in my file (after change word necessary i had only errors!) thank you very much! 2 questions: - applyfilter is not an element on my file (ad...

I created the yellow box that make a union of green boxes content because i'cant write VBA. that put in AND the three filters... so is newbbie trick. I think yellow box works you have only to write in green boxes in a particolar way: for the first on the left you have to write starting from the...

hi Chris!, i'have done a "little bit" cofusion. sorry!!! is better to solve one problem at time in the file i have uploaded, the record in the form will not change in this form. it is used only to search datas. the button works correctly. It have only to reset the green boxes and reset the...

Hi everybody, first of all sorry for my bad english! this is my problem: I created a subform that contain a textbox (in yellow) which works as a filter for records. It works but i have a problem, if I change record in the form the value in the filterbox doesn't change. so I created a button that...