Search results

  1. B

    Export Access- Table (with format) and Report(with conditional format) to Excel by using VBA code<--need help?

    Dear Experts I could use DoCmd.TransferSpreadsheet to export Access-table to Excel . However, all the formats were gone. (i.e. number/date format ) 1) How could I transfer those formats from Access-table to Excel by using VBA directly ? (Note: no need to change the format again by using...
  2. B

    Access VBA- Copy Query results into Table(in Access)--need help?

    Dear All Experts, I need your help into ACCESS VBA as I am facing the following problem: Background: In my Access file, I have a query and 3 tables. Query was named as "run-query" (has 14 fields) 1st table was named as "source1" 2nd table was named as "source2" 3rd table was named as...
Top Bottom