Recent content by Frank72

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