Access APIs
BuildCriteria DoCmd CancelEvent DoCmd OpenForm DoCmd SendObject DoCmd CopyObject DoCmd OutputTo DoCmd GotoControl DoCmd FindRecord Rotate Text On Change Event ConvertAccessProject AddressOf DoCmd ApplyFilter DoCmd OpenQuery DoCmd Close DoCmd AddMenu DoCmd Min/Max/Restore DoCmd RunSQL DoCmd DeleteObject Application...
Read MoreExcel Charts and Graphics
How to Create a Biorhythm Chart Controlling the Plotting of Empty Cells Broken Y Axis Unlink a chart series from its data range Label High-low Line With Values Negatives in Pie Charts Step Line Charts Printing a Chart Mini XY Scatter plots Creating a Watermark How to Create a Single Stacked Column Chart or Single Bar Chart in Excel 2000 Axis Pointer Line chart marker variations How to Create Two...
Read MoreExcel VBA Printing
Path and Filename in headers and footers How to Programmatically Print All Embedded Charts on a Worksheet Printing Selected Worksheets How to Set Page Setup Attributes for More Than One Sheet One liners to Print a workbook, sheet, sheets, selection….. How to Add the Workbook Path to the Footer Hide cells when printing Printing an Entire Workbook by Default Show Printer Properties...
Read MoreAccess VBA
Follow these tutorials to learn more about using VBA in Excel: How To Create a Parameterized Jet Stored Procedure with DDL How to Use the CreateControl() and CreateReportControl() Functions How to Use the TabStrip ActiveX Control How to Create a Collection of Collections How to Exclude Zero Values When You Calculate Averages How to Implement CanGrow Functionality on a Data Access Page How to Use...
Read MoreExcel VBA Files and Folders
Using the links to the following resources, you can learn all about Excel VBA Files and Folders. Determining the Current Directory Using sequential access Macro to Change File Type to All Files (.) in Open Dialog Box Cleaning up those non-printing ASCII characters after a text import. FileSystemObject (FSO) – File List Getting Rid of Extra Quote Marks in Exported Text Files Delete files...
Read MoreExcel Date and Time
Dates and times can be hard to get to grips with for newcomers. However, this list of Excel date and time tutorials will give you a head start. Return End Of Month Date with =DATE Forcing Dates Forward Calculating the Number of Days Between Two Dates Determining Whether a Worked Shift Was Morning, Afternoon or Night Adding Time Values from Separate Hours and Minutes Columns Week Number...
Read More