Search results

  1. M

    Populate a form with Max Recordset

    Hey Gang, I'm trying to pull a project number sequentially without using an autonumber field type. I tried to pull a recordset using a SQL string pulling the max of my project# field. All I really need is to take the result of the recordset and set the field in my form equal to it. It...
  2. M

    Formatting recordset data into an email

    Hey Everybody, Does anyone know what the correct VBA syntax is to start columns at a certain field number? I know when using Debug.Print its Tab(24) to start at line 24. But it gives me an error when exporting a recordset into an email. Here is a subset of my string: strLtrContent =...
  3. M

    Transfer results from queries to auto-email

    Hey Everybody, I wanted to see if I could get an auto-email created using the results of a couple queries. On a weekly basis I would like to send an updated email (automatically) pulling 4 or 5 fields from 4 separate queries. I can do a Make-Table and 3 appends to get them all in 1 Table...
Back
Top Bottom