Monday, September 5, 2011

Use the Form property when referencing subforms in your code

›
There's a good post from back in May on the Microsoft office team Access blog that talks about some best practices for referring to form...
1 comment:
Sunday, September 4, 2011

Is the treeview control going away?

›
You may have noticed I haven't posted in a while. I have not been working in VBA/MS Access and have neglected the blog. But I'm st...
Friday, November 20, 2009

API: Copy variables/control contents to memory

›
I used to have this bookmarked but somewhere along the line I lost it: API: Copy variables/control contents to memory from The Access W...
6 comments:
Thursday, November 19, 2009

Macros and Access 2007: What happened to all the extra Macro Actions in Access 2007?

›
"Access Junkie" has a quick tip here about macros in Access 2007: What happened to all the extra Macro Actions in Access 2007? Whe...
1 comment:
Wednesday, November 18, 2009

Case Study: Improving Visibility & Control for Mission Critical Spreadsheets in Energy

›
In their company blog the folks from Prodiance have posted a case study that discusses spreadsheet and EUC risk management in a major US e...
Tuesday, November 17, 2009

My Treeview Project Episode 7 | Another Way To Read Through Your Data

›
In Episode 7 of My Treeview Project we're going to look at another approach to reading through our data and adding nodes to the tree...
3 comments:
Monday, November 16, 2009

Running a Command as Administrator in VBA

›
As Windows and Office become more and more security aware we've had to learn about things like trusted folders and macro security. Here...
Sunday, November 15, 2009

Link Textbox Contents to Worksheet Data

›
Link Textbox Contents to Worksheet Data on Glenn Lloyd's "OfficeTipsAndMethods" blog is a nice discussion of some really good...
Saturday, November 14, 2009

Gantt Chart using the Microsoft Chart Control

›
"How can I show a Gantt chart on my forms (or reports) using data in my database?" Here's one solution that uses the built-...
Friday, November 13, 2009

Search Criteria Form Example From Allen Browne

›
Many Access developers set out to create a search form: a form where the user can enter or pick criteria and matching records will be shown...
Thursday, November 12, 2009

Subqueries Primer: Find Employees With Salary Higher Than Their Department Average

›
This is a classic SQL problem- probably more a textbook exercise than a real-life business problem, but a classic nonetheless. "Fin...
Tuesday, November 3, 2009

Functions for Calculating and for Displaying Date/Time Values in Access

›
Functions for Calculating and for Displaying Date/Time Values in Access from Microsoft covers a whole bunch of data and time topics. It ...