Search results

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

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