Browse by Tags

All Tags » Tips (RSS)
Sunday, July 13, 2008 3:23 PM

Don't forget the small touches - Invoice number and Set date range to last month

I'm just finishing up adding customer invoicing functionality to my Fleet Management app. One bit of functionality a client requested was the ability to know if a customer service order had been invoiced separately by the branch office accounting...
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 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: , ,
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: ,
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: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: , ,
Saturday, February 23, 2008 6:17 PM

Windows Live SkyDrive - 5 Gb of free storage

Windows Live SkyDrive 5 Gb of free storage. I could've used this a few weeks ago for a client to send me some 5 and 10 Mb zipped files. I'm sure there are other services like this but in the above example I just had the client email me the zipped...
Posted by Tony | with no comments
Filed under:
Wednesday, February 20, 2008 4:42 PM

Looking for Access constants?

Say you're creating fields on a table using VBA and the field collections. You're trying to figure out what the possible values are for the field types. And you've managed to figure out something like the following code. Dim dbsupdate As Database...
Posted by Tony | 4 comment(s)
Filed under: , ,
Thursday, February 07, 2008 5:51 PM

Java, Netbeans and Microsoft Access

Someone posted a link to a tutorial on using Java, Netbeans and Microsoft Access - Persistence, Binding, Annotations: an example with NetBeans6.0 and Access. Undoubtedly 99.9% of my loyal readers won't care but I thought this was interesting enough...
Posted by Tony | with no comments
Filed under: ,
Saturday, December 29, 2007 5:40 PM

A tip on searching Google

I was doing a search on PDFCreator and "Microsoft Access". Google was being helpful by asking "Did you mean: "PDF Creator" "microsoft access" ". I can live with that. However Google was then showing me all kinds...
Posted by Tony | 2 comment(s)
Filed under:
Monday, December 10, 2007 11:42 PM

Resetting autonumber seed to the highest used value

Executing an append query which has a value in the autonumber field can set the autonumber seed to a unwanted high value. Or maybe you had some code running amok, or amuck if you prefer that spelling, which accidentally inserted a lot of records. In Access...
Posted by Tony | with no comments
Filed under: , ,
Friday, November 23, 2007 12:28 AM

I love SNAGIT by TechSmith

SNAGIT is an very easy to use screen capture tool. My previous blog posting would've been impossible using a screen print function as the images only appear if you ran the cursor over the little error control widget. SNAGIT has a video capture option...
Posted by Tony | 2 comment(s)
Filed under:
Friday, November 23, 2007 12:08 AM

Did you know about the "New Label Not Associated With A Control" message?

One reason I much prefer using Access 2003 compared to older versions of Access is the little warning widgets (for lack of a better term) that come up while you are working on forms or reports. These help me, a highly experienced Access developer, work...
Posted by Tony | 1 comment(s)
Filed under: ,
Monday, November 12, 2007 11:14 PM

Shifting fields left on a continuous form

I have a field on a continuous form that is only occasionally visible. Yet, when visible, I'd like it to be right next to another field. And I don't want to leave an ugly gap in the middle. See Shifting fields left on a continuous form in Microsoft...
Posted by Tony | 1 comment(s)
Filed under: , ,
Friday, November 09, 2007 6:43 PM

Access 2000 security patches

Warning: Microsoft Update, which includes Windows and Office Updates, will not locate Office 2000 patches. I was a bit startled recently when I managed to somehow get to an Office Update screen that informed me I was missing a number of Office 2000, and...
Posted by Tony | with no comments
Filed under: , ,
Sunday, October 28, 2007 3:17 PM

Tracking users entering and exiting Microsoft Access Front End

I just created the page Tracking users entering and exiting Microsoft Access Front End .
Posted by Tony | with no comments
Filed under: ,
Friday, October 26, 2007 9:23 PM

Making copies of your database during the working day

The following question came up as part of a newsgroup thread. When you say "make a copy every hour or two", do you really mean that your normal practice during development is to retain multiple separate copies saved at 2-hourly intervals rather...
Posted by Tony | 1 comment(s)
Filed under: , ,
Sunday, October 21, 2007 4:27 PM

Debugging intermittently failing VBA code

I had a problem where an API call would work when stepping through the VBA code but would intermittently fail crashing Access or give an "out of memory" error. (Out of memory is Access's default error message when it doesn't know what...
Posted by Tony | with no comments
Filed under: , ,
Monday, September 10, 2007 12:14 AM

Open your new laptop box before you leave the store

The clerks and such at stores look at me like I'm an idiot. But every time I've purchased a box containing something expensive, such as a laptop, I always open it right there at the clerks station and verify that yes indeed it looks like a laptop...
Posted by Tony | with no comments
Filed under:
More Posts Next page »