Tony's Microsoft Access Blog

Added Auto FE Updater - The AutoFEUpdater.INI file page

I was asked the following question by Christopher Parker:

First off, I'd like to say I've found Auto FE Updater to be pretty useful. Thank you for developing it and releasing it to the world.

I've tried using comments in the AutoFEUpdater.INI file to annotate which computer name belongs to whom, and it seems like this breaks the INI file:

[Auto FE Updater Global Settings]

Master1=ComputerNameHere ; Person's Name Here

I've also tried # instead of ; and it still doesn't work. Does Auto FE Updater not support comments in the INI files?

Thanks for your kind words regarding the Auto FE Updater.

No, the Auto FE Updater doesn't support adding comments to the ends of the lines as that is extra logic I'd have to put in the code to strip out the additional text.   However you can add lines to the INI file.  Such as:

Master1=ComputerNameHere
ComputerNameHere belongs to John Smith.

Note that only developers work station names should be added to this file.'

I've added Auto FE Updater - The AutoFEUpdater.INI file to explain how this file works and to answer this question.  

Thanks for asking, Tony

Another good Access blog

Roger Carlson, fellow Access MVP, recently started his own Roger's Access Blog.  "Thoughts, opinions, samples, tips, and tricks about Microsoft Access."   He will also be announcing new sample code articles on his extensive Roger's Access Library.

He's off to a fine start.

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 With

which I then extended to

Me.<controlname>.controls(0).BackColor = lngYellow

In this thread the original posted wanted to change the background colour of the label when the user entered the control.  

I could've used that logic to change the control's label caption in my Granite Fleet Manager app.   I allow the user to select either miles or kilometers as the unit of measure.  I also allow the user to change the units permanent or temporary location to suit their business.  For one client the temporary location caption is Job Site while another is Farm.   On those I renamed the label to be something like lblControlName and referred to it directly such as

me.lblControlName.Caption = SomeValue

Access 2003 - "Please wait while Windows configures Microsoft Office Professional Edition 2003"

GaryS started a thread titled All Applications work but Access.  I was stumped but he did some more sleuthing and figured out that the Access 2003 post-Service Pack 3 hotfix package: December 18, 2007 solved the problem.

To GaryS - thanks for posting back the solution.

An amusing, errr interesting, list of Honorifics

Need a list of the possible honorifics for your database?  All the possible combinations of Mr/Mrs/Ms/Dr/etc? See Harrods.com Account Registration and click on the Title combo box.

I'd never heard of Begum before.  Where is Adm and R. Adm? 

And what happens if you're a doctor and something else?   Nah, lets not go there.

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 Tables.