Recent content by Iceman95

Hi, I've designed a UNION query to gather a field (corresponding to a monthly rate) from 12 queries (one for each month). The goal is to use the UNION query as a basis for displaying a graph, showing the evolution of the monthly rate througout the year. To do so, I've UNIONed the field [Rate]...

Thanks pal, I did not even think of using a label ! A bit slower, and I must use a .Repaint function, but it works ! Thanks again for the idea.

Hi, I'm struggling with a very formal, not to say aesthetic, problem on one of my form used as a progress bar. This form is very simple, it contains only one unbound control that is called "Percentage". It displays the percentage of completion, when launching a report based on a somewhat...

Man, you're simply an ABSOLUTE GENIUS !!! I can't believe it works, after days ans days of testing, hair-pulling, nearing nervous breakdown... I was searching for such a tip since the Jurassic Age ! These are the sort of things that are so upsetting with Access : the solution is sometimes so...

Sorry, but I get the following message : "Unrecognized DataBase format 'D:\Search From Crosstab Access 97.mdb'". Seems like your database is in Access 2000 format. By the way, I must be more specific on my question : I do get the results I want through my Crosstab query ; the problem is when I...

Hi everyone, OK, here is my trouble (I use Access 97) : I designed a crosstab query based on a select query that requires parameters to be entered via a form. All parameters have been declared in the crosstab query. Parameters were given different types of value : numeric, text, date or...

Unfortunately, this does not work when the query is a crosstab query and the parameter has a Text format property. It seems that Access 97 is not able to evaluate Text parameters with a Null value in crosstab query (the same if the criteria is set to something like ...

Thanks, man, it helped ! That was not the cause of my trouble, but it helped to find it out ! The problem was comming from an IIf... instruction used as criterion for one of my field. Now my Xtab query shows off when the parameters are entered with the form, even if they are left blank ...

Yes, I experimented the make-table solution, I think unfortunately I'll have to use it, but it's a pity, for definitely not time-saving and adding complexity where it should not have. Thanks anyway, and I'll dig out the text parameter issue ; will try to convert every parameter to numeric or...

Hi, I'm back again with a problem I've been struggling with for weeks, without being able to find any satisfying solution. Here it is : I designed a crosstab query based on a select query that requires parameters to be entered via a form. All parameters have been declared in the crosstab...

Here is the SQL of my query : PARAMETERS [Forms]![Dialogue]![DateDébut] DateTime, [Forms]![Dialogue]![DateFin] DateTime, [Forms]![Dialogue]![NomLiquidateur] Text, [Forms]![Dialogue]![Option] Bit; TRANSFORM Sum([Requête union anomalies Requête (liquidateur) (2ème...

No, as stated before, all parameters declarations have been done correctly. Once again, when the query is launched without the form, the parameters are prompted via dialog boxes ; should they hadn't been declared, Access would have given an error message. Furthermore, the query does not open...

Yes, I've declared all parameters ; the problem does not lie in the query itself, that works perfectly. As Jason said in his post, I'm afraid this a bug in Access. The only thing that surprises me is that Microsoft Knowledge Base doesn't reference it.

Hi, I have a crosstab query based on a select query requiring parameters to be entered via a dialog form. Everything works fine when the parameters are typed directly via a dialog box (select query and crosstab query run perfectly). When using the form to enter the paramaters, only the select...