Search results

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...

cheers mate, i'll give it a crack.

This has to be possible, I'm sure i'm missing something obvious. As this is quite complex to describe I've put some screen shots here: link not available [This message has been edited by cunnie (edited 05-13-2002).]

Yeah my query only gives one result; But, turns out this is slightly more complicated than I had first imagined. You see I have lots of textboxes on the same form, not all 'will' be filled with data, but all of them 'could be'. How can I select a range of data to be used for the form, and then...

well, for now this'll do. I put a button in the form with this code in the on_click event; TXTbox.SetFocus DoCmd.ShowAllRecords (tried it in the form_load event but it didn't work) If anyone comes up with a better solution post a reply

I have a textbox that gets it value from a query. But when i load the form that textbox remains blank, even after click it. Then I noticed, if you right click on it and then click 'Remove filter/sort' the value is displayed. Anyone know how I can get the value to appear automatically?