Search results

  1. D

    Email generation & tracking system - loops querydefs recordsets...

    Good afternoon, I have a previous post linking to this one but the way i am now doing it is different (Hence this new post) My aim is to import data, use a query to pull back the previous weeks data. Generate an email with this data. Then, the next week, import that data and send that...
  2. D

    Opening an ADODB.Recordset with an SQL statement,taking into account a date on a form

    Good afternoon everyone :o, I hope you can help? I am trying to generate emails based on a date on a form. I have created a VBA module, connected to a recordset, generated emails to be sent depending on that recordset with a table successfully. I want to change this so it only sends for...
  3. D

    Update a table based on query results via VBA

    Good afternoon all,:rolleyes: I have a query which picks up completed work requests from a work request table (which is linked to Sharepoint) I would like to add some of the information from that query to a previously created work request table where work requests were entered manually (I...
  4. D

    Export query to .txt file with incrementing number and specific formatting

    Good afternoon all, I hope everyone is well? I was wondering If anyone could help with the following problem I am having. I need to export the results of a query in the following format, each row having a line number... 1,61545001,,21/04/2009 08:00,21/04/2009 17:00,16/04/2009 17:00...
Top Bottom