Search results for query: *

Hows it going This is about the 10th time i've posted this question regarding leaving a combo box unselected so that as a parameter it will select all from the field.So far i've had many responses, many thanks, but unfortunately none seem to be working. I'm sure its got something to do with...

Hows it going This is about the 10th time i've posted this question regarding leaving a combo box unselected so that as a parameter it will select all from the field.So far i've had many responses, many thanks, but unfortunately none seem to be working. I'm sure its got something to do with...

Hows it going This is about the 10th time i've posted this question regarding leaving a combo box unselected so that as a parameter it will select all from the field.So far i've had many responses, many thanks, but unfortunately none seem to be working. I'm sure its got something to do with...

Hows it going This is about the 10th time i've posted this question regarding leaving a combo box unselected so that as a parameter it will select all from the field.So far i've had many responses, many thanks, but unfortunately none seem to be working. I'm sure its got something to do with...

If i have a double columned listbox how could i fill one text box with column1 and an other textbox with column 2? surely this is possible!! thank you Frank

Hows it going I want to put a date at the top of a report, simple enough but the date i want to show id the second column of a double column list box and therefore the index is being shown, ive tried [forms]![frm]![listb.column(2,comb.listindex)] this seemed like a long shot but there must be...

Hows it going I want to put a date at the top of a report, simple enough but the date i want to show id the second column of a double column list box and therefore the index is being shown, ive tried [forms]![frm]![listb.column(2,comb.listindex)] this seemed like a long shot but there must be...

Hows it going I want to put a date at the top of a report, simple enough but the date i want to show id the second column of a double column list box and therefore the index is being shown, ive tried [forms]![frm]![listb.column(2,comb.listindex)] this seemed like a long shot but there must be...

Hows it going On a form i have 3 combos each bound to tables with values (sex,model,location) and indexes. the combos column count is 2, the bound columns are 1. I want to use these combos as parameters or criteria in a query. I also want to enable them to be left blank hence selecting all...

Hi Jeff Long time! still at this! yeah thats what i thought , no need to complicate matters. i think i'm confusing it with other situations.I'll give that a go thanks alot Frank

Hows it going I'm trying to use a combo box to act as a criteria in a query. I have done it before but changed it and now cannot get it to work again. I know is got to do with indexes but have kind of forgotten exactly how to do it. Thanks alot Frank

Thanks Stew

Hows it going I have 3 combos which are each used as criteria in a query. I want to be able to leave 1 or more boxes empty so that the criteria will be to select all of that field. I've tried <- like * & [forms]![frmForm]![Combo] -> but its drawing a blank. The * keeps getting quotes...

Hows it going I have a group with a header with a force new page before next, and the footer with a page break. After each group there is a page break but there is always a blank page (with page header only) between groups. How can I get rid of this? thanks alot Frank

Actually sorry thast doesn't seem to work just draws a blank any other suggestions?....anyone....help!! I thought this would be a feature on access but i can't seem to find any way of getting to work. Thanks Frank

hows it going What is the property that defines a criteria for a field in a query? Is there such a property? Could i 'erase' the criteria in code for example qrySelect!field.filter = false thank you Frank

Hows it going Is there a way of getting a listbox to select a whole field when there is no selection in other words in the gender box leaving it unselected will find records with all genders. or even a selection (&quot;All&quot; or *) that would select without the filters? thanks alot frank

Hows it going Is there a method or command that will delete all records in one go or would I have to use the .delete method in a loop? many thanks Frank

Thanks thats just what I needed! Frank

Hows it going I have a few listboxes for gender location and model selection and want one of the options in the gender box to select all m, f and unknown. I currently just have an asterix for this and thought that maybe i could use this in sql or in some way to make the criteria select all...