Recent content by Stm

Hi all, I'm using Access VBA to run a query and format numeric value according to below and then send out by email. 1) if the value is 0, show a dash. 2) if it is >=1 or <= -1, show it without decimal place 3) if it is (>0 and <1) or (<0 and >-1), show it with 1 d.p. (e.g. 0.51 / -0.49) I've...

Hi all, I have an Access program that export report to PDF for distribution using the below command and the job should finish within 10 mins. DoCmd.OutputTo acOutputReport, "rpt_xxx_Report", acFormatPDF I've setup this as batch job in another machine and will auto run every day. Two months...

Recently I noticed a phenomenon that if "Compact and repair database" has been performed on accdb, it is less likely for the error to appear. So, I've updated my scheduler to compact the database once after each run.

The problem is likely due to bad patch, as in past few months, I encounter significantly less such error than before. However, since Aug, this problem appears again more frequent. The saddest thing is that I don't have any control to apply/rollback any MS patch as it is a company policy.

Thanks but no Cloud involved in my situation.

Thanks @TacoTetradactyl for your findings....in my case however, all files are not on cloud, and I just read from them. It's interesting when I use DoCmd.TransferSpreadsheet to export to excel, I never encounter "External table is not in the expected format" error!

Dear all, I have two Access Forms which each run few queries and then send out the results by email. There are few linked tables to excel *.xlsx and some local tables, each query will join these tables to compute the results. This program runs fine for long time until about one year ago, the...