Search results

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!

On the form it is a combo, where the user can select a single category - i want the query to show every person which has this category set as true. Ive got it to work filtering a datasheet with the code below, but having trouble doing it in a query: Dim SearchCriteria As String...

Hi there - Having a bit of bother with a query - I have a table which holds a list of people. The table contains a few fields which are categories the people can be - eg member, help, volunteer etc, and these are yes/no fields. A person can be any number of these. Now, i am making a form...

Hi there, does any1 know of a line of code which creates a new report? Ive had a try and look round the forums with no luck... Cheers

Thats great - we both have same Access just now. Thats good - thanks!

Hi guys, ive been developing a database for someone. As some coding has been involved, I have added some references etc as I went along. I'll be soon handing it over to them to use - will they have to add the references for the database to run on their comp? If so, is there more user friendly...