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...
@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...
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...
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...
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.
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...