Search results

  1. A

    Access VBA To Send Query Results to Outlook Email in Table Format

    Hi, Hi, can you please help me to change the result view, here the result is showing in Horizontal Table view but I need the same code with the Vertical Table view. Public Sub NewEmail() Dim olApp As Object Dim olItem As Variant Dim db As DAO.Database Dim rec As DAO.Recordset...
  2. A

    Outlook Email Management Ticketing System In MS Access

    Dear Team, I have a shared email id and it is configured in MS Outlook 2007. Some time we are initiating a new email and sending it to customer for more input and some time customer is initiated new email for resolving their issue (with attachment / without attachment, attachment format not...
  3. A

    Performance Issue To Append 3 Millions Records From Access Table To SQL Server Table

    I have to append 3 millions of records from MS access table to SQL Server Table, below is the VBA code for the same, This code is correct but it is taking lot of time (2000 Records Per Minute) to append 3 Millions records. can you please help me to reduce processing time. Private Sub...
  4. A

    MS Access VBA Search Result Performance Improvement

    Dear All, I need your help for MS Access VBA Search Result performance improvement, below is the code which i used, i want to get the result based on string matching on % basis, this code is correct but it is taking too much time to perform almost 25 Minutes To 30 Minutes for Single String. I...
  5. A

    How To Auto Update Logout Time in LoginLog Table when user is sudden removed their LA

    Dear All, I need your help on Access VBA 2007, How To system will automatically update Logout Time in LoginLog Table when user is sudden disconnected on Network Connection OR sudden removed LAN cable from their Laptop. Below is my Login_Form VBA Code, here i am using Sub Form_Close() event and...
  6. A

    How To Allocate Tasks to Online Users In MS Access VBA 2007

    Dear All, I need your help to solve my problem, I have 2 Tables : (1st ) tblTaskDetails (2nd ) tblOnlineUsers as below sample data 1st Table : tblTaskDetails (ORDER BY INCIDENT_DATE ASC) Account_Number INCIDENT_DATE 201200178 04-Apr-16 07:34:09 AM 921858299 04-Apr-16...
Top Bottom