Recent content by bnfkru4567

  1. B

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

    My Table has number format and Report has conditional formatting . So how can I transfer from Report with conditional formatting to Query ?
  2. 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...
  3. B

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

    Cool thanks for explanations
  4. B

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

    @Gasman the answer is that in <result>table, I found the Primary Key that does not allow "duplicate". At the beginning, I copied from other table (i.e. the field only) but didnt know that Access would treat the first field as Primary Key and not allow "duplicate" @Pat Hartman In...
  5. B

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

    Yes, but it sounds like the result table is set NOT to have duplicates?<-------you are right from normal situation but for my situation , I will expect that some data were duplicated. That will likely be why not all records were appended on your previous run?<---the answer is Some data are as...
  6. B

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

    It is not possible ---I will expect that a few of them will be duplicated
  7. B

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

    Dear all I had already run my VBA code step by step. Let say this way: 1st run "run-query", then I have 100 records in the result -my VBA Code can copy and paste all the 100 records into <result>table 2nd run "run-query" ,then I have 25 records in the result My VBA code is not working...
  8. B

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

    Dear Experts If NOT use "Append", do you have alternative idea to update the above VBA codes in order to run it smoothly ? Thanks
  9. B

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

    I think your idea is not suitable for my case. Why? I clearly mentioned that I had to run query a lot of times per day. Thus, my table "sources 1&2" will be updated each time before run query (I didnt mentioned). So Append is not suitable for this case.
  10. 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