Recent content by cunnie

heres a screenshot of the macro design view, this should tell you everything you need to know. cunnie

I got my crosstab query to export to excell without corrupting the data. I created a macro, and gave it an "OutputTo" action, then changed the action arguments so the output format was *.xls hope this helps, cunnie

The search helped a little, I did some searching elsewhere and found the solution: In the design view of a select query, add the fields you want the query to display, plus your DOB field. You do not need anything in the criteria of any of the fields. Then in a blank column, enter the Field...

How do I create a query to return all members who's Date Of Birth matches todays date (apart from the year), to show members who have birthdays today.

Yeah thats what I thought, but i did it and the sub-form comes up with no control source. If I try and create it with the wizard when i asks for what fields I want to include, it doesn't show any in the available fields list. The other day I managed to get an error message (don't remember what...

yeah I just want to show the crosstab

Ok, The problem I've got now is that I want the croostab query to be shown in a sub-form on the servicesheet form. The query works on its own, but when i try and create a form based on the query it doesn't give me any fields to add, so no data is shown. I'm pretty sure I've done this before...

I've got the crosstab working now, I needed to set the parameters data type to Value instead of Text (in the parameter query). I guess this is because i'm referencing the value of the text box and not its text, makes sense in a strange access kinda way. [This message has been edited by cunnie...

Explaination of the problem here [This message has been edited by cunnie (edited 05-13-2002).]

OK, i set the parameters correctly and refer to everthing with the right name, but i'm getting an error again. A nice vague one; "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try...

Ah, I see... Now I get a box prompting me to input a value when I run the query, access really doesn't like crosstab queries and textboxes does it.

parameters?...parameters? where are these parameters? i'm using access 97 btw

can you explain what you mean in a bit more detail? [This message has been edited by cunnie (edited 05-03-2002).]

see 'fill textboxes with a query' in query forum (turning out to be more of a query post this)

Ok tried a crosstab. But the criteria refers to three text boxes on the form, like this; [Forms]![servicesheet]![txtmodel] [Forms]![servicesheet]![txtvari] [Forms]![servicesheet]![txtpres] this works in a select query, but in a crosstab it gives the error; The Microsoft Jet database engine...