Browse by Tags

All Tags » Tips » Access (RSS)
Saturday, October 04, 2008 2:58 PM

Referring to a control's label

rkc posted a snippet of code in a thread titled Access an attached label in VBA on how to refer to a control's label using some syntax I've never seen used in exactly that fashion. With ctlCurrentControl .Controls(0).BackColor = lngYellow End...
Posted by Tony | with no comments
Filed under: , ,
Thursday, October 02, 2008 9:04 PM

J Street's Access Relinker available for download

See J Street's Access Relinker by fellow MVP Armen Stein. Also see the Access Web's Relink Access tables from code and Allen Browne's Reconnect Attached tables on Start-up as well as my general approach on this topic for shrink wrap apps Relinking...
Posted by Tony | with no comments
Filed under: , ,
Thursday, September 18, 2008 11:32 PM

Getting a list of control names on a form

Fellow Access MVP John W. Vinson reported a client found an interesting "feature" within Access forms. If while on a form and in Form View hit Ctrl+A and then Ctrl+C. Now switch to Notepad and Ctrl+V to paste. Turns out you get the forms control...
Posted by Tony | 1 comment(s)
Filed under: ,
Tuesday, September 16, 2008 3:44 PM

Referencing one of three identical controls

The client has a very complex, unbound labour entry form. One requirement is to efficiently add over time and double time hours for the same person, job, activity code, etc. So the solution was to create three sets of controls that are identical except...
Posted by Tony | with no comments
Filed under: , ,
Wednesday, September 10, 2008 10:47 PM

Microsoft Access Report Printing Criteria Selection Form page updated

I've completely updated the page at Microsoft Access Report Printing Criteria Selection Form with the latest code that I currently use. That page was created in about 1996 or so and was among the first five or ten pages I ever created. So it was long...
Posted by Tony | with no comments
Filed under: , ,
Wednesday, August 27, 2008 8:13 AM

Making the Query Expression Builder dialog box larger

In my previous blog posting Referencing a control on a subform from the parent form in VBA a comment asked "where you got the, uh, large, ok, monstrous 'expression builder' window." I clicked on the diagonal lines on the lower right...
Posted by Tony | with no comments
Filed under: ,
Monday, August 25, 2008 7:37 PM

Referencing a control on a subform from the parent form in VBA

Sometimes I get confused when trying to figure out the exact syntax required in VBA code to reference a control on a subform from the parent form. For example Forms![Equipment]![EquipmentPartssbf].Form![cboepPartID] See Referencing a control on a subform...
Posted by Tony | 5 comment(s)
Filed under: , ,
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: ,
Monday, February 25, 2008 2:21 AM

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: , ,
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 | 1 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: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: , ,
More Posts Next page »