Author Archives: admin

Using a subtable for criteria to a main table report

Here’s the scenario: You have 2 related tables:  Projects and Machinery.  You wish to see a listing of projects where the location of the Machinery is in China.  Yet there are multiple machinery items in multiple locations for Projects, and … Continue reading

Posted in Uncategorized | Leave a comment

Sending list box results to a temporary table for reporting

Situation:  You’ve got a list box of surgeons.  You want to run a report and as a criteria to the report, you want to filter by the surgeons selected in the list box.  How do you do this? Here’s the … Continue reading

Posted in Uncategorized | Leave a comment

Complex Reporting

(and building a source form to understand how the report results are derived) Sometimes you need to build a really complex report. I had to do that for one of my Fortune 500 clients. They were trying to automate a … Continue reading

Posted in Access 2007 problems/solutions | Leave a comment

Can’t delete records in SQL Server table from Access

Issue: Table must have a Primary key (or at least a unique index). Resolution: When creating the link to the SQL Server table, and Access prompts for index, this isn’t sufficient. The index must be created on the SQL Server … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged , , | Leave a comment

Closing all open forms except certain forms

I had a tough time accomplishing this one and my final solution isn’t elegant at all! I wanted to close all currently open forms except the main menu.  And if the main menu wasn’t open, I wanted to open it … Continue reading

Posted in Uncategorized | Leave a comment

Subreport Hell

So, a new item found today (actually found a week or so ago):  Problems linking reports/subreports. I went to link a subreport to a main report just like I’d done many, many times before:  I dragged a pre-created subreport onto … Continue reading

Posted in Access 2007 problems/solutions | Leave a comment

Another Access 2007 Issue – Default grouping of objects on report and how the heck do you ungroup?

Created a default report (I hate the lack of control you have on default reports!  Where are my old wizards that I’ve loved over the past 10 years?  Arrrggghhhh!!!!!).  Then started to modify the controls that were pre-populated on the … Continue reading

Posted in Access 2007 problems/solutions | Leave a comment

Another Access 2007 Issue – Back Color values not working in code…

I continue to be disappointed with Access 2007 from a Developer’s point of view.  Here is my most recent issue:  I’m attempting to set the backcolor property of a text box control using the ‘On Format’ event property of a … Continue reading

Posted in Access 2007 problems/solutions | Leave a comment

Working for UVA soon?

Hey, just had my first meeting with a University of Virginia manager than needs an Access database built.  She’s got the process flow mapped out, the data structure mapped out, and now just needs the database built.  I asked her … Continue reading

Posted in Business Opportunities | 1 Comment