Search results for query: *

Thanks leslie, But I would like to use a similar function to [Type Source name ?] in the criteria and the user only has to enter part of the word and all fields with those letters are pulled. Thanks

Hi all, I used to remember how to do this but for some reason I havn't a clue now. I know its possible to type, for instance the 1st three letters of the field you have set the criteria on, and it pulls all the records that include those 3 letters in any part of the word / phrase. for...

Cheerio, Had already tried SELECT DISTINCT etc Keep getting a message 'At most one record can be returned by this subquery'

I have a main table (AllContactsInLists) and have used the following code to show me all duplicates that occur within this table. In (SELECT [Address] FROM [AllContactsInLists] As Tmp GROUP BY [Address] HAVING Count(*)>1 ) Some of the duplicates contacts have many duplicates. What I would like...

I am using 2 tables in my query and having the above message come up every time I try to populate one of the fields thru the query. Have tried all sorts of possibilities, no index's, no primary keys etc etc but am getting nowhere. When I use a query from either one of the tables on there own I...

Thank you Paul. Worked a treat

I have a table/query with one of the fields [ResearchListID] having numerous values. In my report I am grouping by this field. Can anyone tell me the easiest way to count the different groups...not what is in each group.... 194 194 194 196 196 196 I would like my count to say '2' and not...

Thank you Jeff, that worked great, but I've just realised I need it slightly different still....doh ! I need the first record on the subform to say "1", then the next record to say "2" and so on. It now just says the Dcount figure. Whoops, didn't think of that !

Hi all, I am trying to count the number of records in my subform which relate to the main form. I have so far =DCount("[SAMPLE_ID]","sample_table") This works to an extent that it counts all the records within my sample_table. What I'd really like is it to count the...

Even if I do create a subreport it still prints out the same amount of pages. Its very strange

Hi all, This will probably be easy to fix but is causing me a bit of grief at present. I have a main input form for enquiries which includes a subform for all the types of different requirements to be printed out on a report. The problem is, that if for example I have 4 requirements then my...

Cosmo, Why should I replace it with Forms! object ref ?? It doesn't really have anything to do with forms

Am, at home now. Will have to do it when I get into work tomorrow. The controls are the exact names from the fields from the table. Is that ok ??

I thought it did get sent...oh well ! The controls should be the names of the text boxes from the original form ?? They are the names of the fields from the table.

I get a run time error 2465. Can't find field Customer add 2. Does there need to be anything in the control source for the new text box ??

Sortof, I have three different combinations that I need to include. How can I like these 3 IIf statments together? In plain English.....If Customer add 2 is null I need fields 1,5 and 6 printed. If cust add 3 is null I need fields 1,2,5 and 6. and finally if Cust. add 4 is null, I need...

Yes, sorry. More than one field. It was a long day !

Can you have more than one record as Null in the same IIf statement??

Is the vbCrLf constant an access 2000 thing ?? Cant find it in the Access 97 help anywhere

Hello, I have an IIf statement in one of my reports which seems to work fine. I would like to instead of the fields listing across the page horizontally, jump to a new line after each record is diplayed. =IIf(IsNull([Customer add 1]),[Customer add 5] & " " & [Customer add...