|
||||||
Access MVP (2010-2015) |
It’s always tricky when you want export filtered data to Excel. You will get an error message if you put try to put the Forms Control in the Criteria section of the Query. Why? Because Access insists on having the value before it can execute the export and not from the Form but directly in […] 618 total views Recently, I exported an Access Report to Word (.RTF). Nope, did not use Albert’s Super Easy Word Merge because the nature of the report with its many Subreports and Sub-Subreports did not lend itself to a mail merge. Only after I exported it I needed to first copy it in its entirety to another document […] 787 total views The most often asked question is about customizing Autonumber. The answer is, don’t! If you want to use a sequential numbering system Autonumber is not the Data Type to use. Even if you want to include Autonumber with another Field to make a composite… don’t, it’s not always sequential. (More on that later) Leave Autonumber […] 6,558 total views Recently, while trying to Debug some code a colleague of mine suggested I leave Compile on Demand1 unchecked. Since in all my years of developing I have always left it checked, I asked why and here’s what he said got… Many years ago, Michael Kaplan mentioned that this setting was known to cause problems, […] 1,381 total views |
 |
||||
|
Copyright © 2024 Gina's Coffee Shop - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
