Recent content by loo8866

Prob solved - managed to get the query up and running! thanks!

Hi there, is it possible, on one of my reports, to filter the records based on a text field on the report. I just want it to be filter where textfieldX < 0 Is this poss on a report? the text field comes from a bunch of calculations, otherwise i would have done it in a query...

OK - just tested this, and heres the score. On the form where the text is entered made no difference decreasing or increasing text size. However, I decreased the size of the text on the report from 12 to 10, and it showed a 'bit' more of the text! What does this mean!!

Yes, the field & detail section are set to 'can grow'. I tested it, and the text turns unreadable from the 501st letter!! this should be a clue?>

Is this possible considering there is no 'field' - as the text box does not link to a table! the text in the text box is transferred to the report, thats all.!

It seemes to cut out after 500 words...where can i change the settings for this, is it in the report/query/text box? Cant seem to find a way to change...

Mm, so this means that it shouldnt go funky after a couple of short paragraphs?

Hi there - on one of my forms i have a text box where the user can write the contents of a letter. When a button is pressed, a report is run, and the text from the form is entered into the report - this all works fine - but when the text reaches a certain length, it goes all unreadable. SO i...

OK - strugling with this. Basically the contacts table (full of people) has a number of types which can be either yes or no. A form has matching tick boxes for all types - when the button is selected a query is run. I want the query to just show the people that include a type from the types...

OK - so i change the combo box on the form to tick boxes of the types (as in the table). How do i link this with the query tho?

Sorry, still having no luck with this query. Basically, id usually do a query like Blah Blah Where FieldName = Variable. THis is fine - but now im trying to do & gettin problems is: blah blah Where Variable (which equals a fieldname) = True. Can any1 else help? Many thanks.

u mean make a new table for contact types? Will this make anything easier - or just good practice?

5/6? I previously had two fields which were called contact type - and the user would be able to select 2 types. But actually, a person could come under more than 2 types - so i changed to this way. It works great, but just trying to get this query changed isnt working...

yeh its boolean - il give that a bash -

mm doesn't seem to work - I tried this - SELECT * FROM contacts WHERE (([Forms]![frmContactLetter]![TypeC]) & "= true"); but no matter what i select, it just shows everyone!