Search results

  1. N

    'Search' code

    Genius! Thanks for that - how 'should' i know that?? Where are these rules found apart from on forums like this?? Appreciated!
  2. N

    'Search' code

    Hi, I have a form and a few tables. On my form i have a few text boxes and a cmd button. When clicked the cmd button looks up data in a table (using info in one text box) and then populates other text boxes on my form from corresponding data to the record being looked up. My code uses the...
  3. N

    Group by - Query

    Hi, got this all sorted now. Took a bit of fiddling and trial & error, but got there in the end! Thanks for your help......greatly appreciated!
  4. N

    Group by - Query

    Evening All, Iv got a query that gets its data from a table. When going through the query wizard it enabled me to group my data by 'Date'. So, for example, in my table there are numerous records for different products on different days. The date field for each record in my table is a...
  5. N

    'Find' code

    Perfect! Thanks for that, i knew it would be quite simple, Many thanks
  6. N

    'Find' code

    Hi, Thanks for the reply - but im still struggling a bit. Would be grateful for a bit more guidance please. Let me know if you need any more info about my db or what im trying to acheive. But in summary, its simply a form that a user will use to locate a record in a table. they will type the...
  7. N

    'Find' code

    Hi, New to this site, and hope i may be able to source some help. Im a bit rusty on my code knowlege: I have a form with a cmd button with the following code behind it: Private Sub Find_Click() Me.RecordsetClone.FindFirst "[RecordNo] = " & Me![FindNo] If .NoMatch Then...
Back
Top Bottom