Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jamespeters01

    Typing part of word in 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
  2. jamespeters01

    Typing part of word in Query

    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...
  3. jamespeters01

    Show just one record from duplicates

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

    Show just one record from duplicates

    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...
  5. jamespeters01

    Recordset not updatable

    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...
  6. jamespeters01

    Count number of Groups

    Thank you Paul. Worked a treat
  7. jamespeters01

    Count number of Groups

    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...
  8. jamespeters01

    DCount on subForms

    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 !
  9. jamespeters01

    DCount on subForms

    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...
  10. jamespeters01

    Using subform prints out too many reports

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

    Using subform prints out too many reports

    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...
  12. jamespeters01

    IIf statement and a new line

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

    IIf statement and a new line

    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 ??
  14. jamespeters01

    IIf statement and a new line

    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.
  15. jamespeters01

    IIf statement and a new line

    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 ??
  16. jamespeters01

    IIf statement and a new line

    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...
  17. jamespeters01

    IIf statement and a new line

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

    IIf statement and a new line

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

    IIf statement and a new line

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

    IIf statement and a new line

    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...

Part and Inventory Search

Back
Top