Browse by Tags

All Tags » Access (RSS)
Friday, June 27, 2008 1:15 PM

Setfocus and subforms - 2165 "You can't hide a control that has the focus."

I was quite puzzled. I wanted to setup some fields on my Fleet Management System so that the user could toggle off or on the item cost or price. For example they might want to do up a quote for someone and just show the price. (Hmm, I'll have to add...
Posted by Tony | with no comments
Filed under: ,
Saturday, June 14, 2008 11:50 AM

Stephen Lebans has updated the A2000ReportToPDF utility

A2000ReportToPDF is an Access 2000 database containing a function to convert Reports and Snapshot files to PDF documents. No PDF Printer driver is required. New Version of DynapPDF.DLL dated March 11/2008. New Version of StrStorage.DLL dated May 12/2008...
Posted by Tony | with no comments
Filed under:
Saturday, May 31, 2008 6:20 PM

File Compression using the OS and NTFS file system

Thanks to a question in the newsgroups I did some research and updated the Microsoft Access Compatible Compression Solutions page with the below File Compression using the OS and NTFS file system section (And I renamed the web site page from Microsoft...
Posted by Tony | 2 comment(s)
Filed under: , , ,
Saturday, May 10, 2008 10:56 PM

Bug in ADO, SQL Server and latest OS SPs

On a computer that is running Windows Vista, Windows Server 2008, or Windows XP, an incorrect value is returned when an application queries the identity column value of a newly inserted row in various versions of SQL Server 2005 and of SQL Server 2000...
Posted by Tony | with no comments
Filed under: , ,
Saturday, May 10, 2008 7:03 PM

Permission Denied

Short story: I was trying to copy the backend MDB from the front end but hadn't closed a database variable pointing to the backend MDB. I used the presence and absence of the backend LDB file in Windows Explorer to track down the problem. Long story...
Posted by Tony | 2 comment(s)
Filed under:
Tuesday, May 06, 2008 11:20 PM

Awesome application description

I read the Jack Cowley's Rodeos posting on fellow MVP Steve Schapel's Real World Access blog. His blog is "a series of articles about where Microsoft Office Access applications have found a real-world niche." I felt the description of...
Posted by Tony | with no comments
Filed under:
Saturday, May 03, 2008 10:41 PM

Deploy Access 2003 runtime with SP2

Tim Lentine asked about this topic in the Microsoft newsgroups. However I didn't have an answer. He subsequently found a very interesting posting on how Deploy Access 2003 runtime with SP2 built in . Go down about six postings to the longish posting...
Posted by Tony | with no comments
Filed under: ,
Saturday, May 03, 2008 3:02 PM

References

Paul asked "I sometimes get frustrated that Access does not always update references between versions...for example a calendar control or Outlook reference" 1) Use a calendar form or the API calls which is what the calendar control uses behind...
Posted by Tony | with no comments
Filed under: , ,
Thursday, May 01, 2008 9:39 PM

Background colour of forms

In a comment to my Multi Row Tab control posting Diana asked: "Just curious, is your form really that blue color? Is it in production? How do your users feel about that color? Would you design a web page that color? I'm always curious why Access...
Posted by Tony | 7 comment(s)
Filed under:
Monday, April 28, 2008 8:29 PM

VB/VBA line numbers

So you're looking at this posting and thinking "how retro". What is that old fart Tony up to? Well, yes, I did use line numbers a lot when I first started as a programmer in this business almost thirty years ago. The IBM 5110 computer booted...
Posted by Tony | 2 comment(s)
Filed under: ,
Saturday, April 26, 2008 2:21 PM

Access 2003 hotfix package - April 16, 2008

Access 2003 hotfix package: April 16, 2008 "- In Access 2003, when you save an .mdb database in the design view, the properties of the sub-database in the .mdb database are lost. - You install the Office 2003 Service Pack 3 on a client computer....
Posted by Tony | 9 comment(s)
Filed under: ,
Wednesday, April 23, 2008 11:25 PM

Changing Allow Design Changes while at the Form View

Tired of creating forms in Access 2003 with this option? Allen Browne suggests creating default forms, reports and databases. I did get quite irritated about having to switch the form to design view, click on the small black box in the upper left hand...
Posted by Tony | 2 comment(s)
Filed under: ,
Tuesday, April 22, 2008 10:40 PM

The expression On Click you entered ...

I was getting the below error message in Access 2003 when I clicked on a command button. Likely because I was working on a form module and possibly saved it while the form was in regular view and not in design view. "The expression On Click you entered...
Posted by Tony | 3 comment(s)
Filed under: ,
Monday, April 14, 2008 7:28 PM

Another very useful Access 2007 blog

Help and How-to for Microsoft Office Access 2007 This blog has some useful and interesting tidbits even for an experienced person. Also see Help and How-to for Microsoft Office Access 2003 You may have to right click and copy the link location and paste...
Posted by Tony | with no comments
Filed under: ,
Monday, March 24, 2008 3:10 PM

Vulnerability in Microsoft Jet Database Engine (Jet) Could Allow Remote Code Execution

Microsoft Security Advisory (950627) That said "At this time, we are aware only of targeted attacks that attempt to use this vulnerability. Current attacks require customers to take multiple steps in order to be successful; we believe the risk to...
Posted by Tony | with no comments
Filed under:
Monday, February 25, 2008 9:33 PM

Multi Row Tab control not

A number of fellow Access MVPs disagreed with the UI of a multi row tab control. John Mishefske pointed out a excellent page at the Interface Hall of Shame - Tabbed Dialogs . Of course *MY* multi row tab would not look anywhere near as ugly as some of...
Posted by Tony | 2 comment(s)
Filed under: ,
Sunday, February 24, 2008 11:24 PM

Multi Row Tab control

In my Fleet Management System I'm soon going to be adding enough tabs to the following form that I'll run out of space. I didn't like the looks of the default behavior. So I asked in the private MVP Access newsgroup how you could get multi...
Posted by Tony | 2 comment(s)
Filed under:
Sunday, February 24, 2008 11:21 PM

Minor unexpected behavior in VBA DIR function

This is exceedingly minor. However the following example brought two different results. ?Dir("Q:\1 access\Fleet Mgmt\*.key") PD.keyzzzz ?Dir("Q:\1 access\Fleet Mgmt\pd.key") <nothing> Background. For my "shrink wrap"...
Posted by Tony | 2 comment(s)
Filed under: , ,
Sunday, February 24, 2008 7:17 PM

Fetching the reference description

I've always been irritated at how you can't get at the user friendly reference description as displayed in the Access VBA References screen. When you look at the properties of the reference object you can't see the user friendly name you see...
Posted by Tony | 5 comment(s)
Filed under: , ,
Friday, February 22, 2008 10:29 PM

Access Basics by Crystal

Access Basics by Crystal fellow Access MVP. While the three or four loyal readers of my blog likely are more interested in advanced Access topics you may have coworkers who could use these PDF files.
Posted by Tony | 1 comment(s)
Filed under:
More Posts Next page »