Browse by Tags

All Tags » VBA » Access (RSS)
Friday, December 26, 2008 10:53 PM

A very interesting solution for Code 39 barcode

Jim at a client found the following a very interesting solution for 3 of 9 bar code which was done as VBA code by James Mercantile. Barcode Generator for Code 3 of 9, Code 39, and Mil-spec Logmars. The VBA code reads the size of the control and creates...
Posted by Tony | 2 comment(s)
Filed under: , ,
Sunday, November 30, 2008 4:18 PM

Standard NotInList VBA code

I finally got around to creating a Using NotInList in a combo box page at my website. I keep forgetting to make up same sample code and re use it as I don't care for the MS sample code in the Access help. A bit too verbose and it doesn't show...
Posted by Tony | with no comments
Filed under: , ,
Sunday, November 30, 2008 3:23 PM

Using pictures on a form and report

The following question was asked in the comp.databases.ms-access newsgroup. I'd like to add a picture in a report's detail section where the path to the picture is from a table. Incredibly easy. The same code works on a form as well. Using the...
Posted by Tony | with no comments
Filed under: , ,
Wednesday, November 26, 2008 2:37 PM

My muddiness when it comes to OpenArgs

I was getting an syntax error message when I clicked on a New button on the Equipment Quick Finder form . The equipment form in the Granite Fleet Manager executes a reasonable amount of code on startup. I had added that New button to the Quick Finder...
Posted by Tony | 3 comment(s)
Filed under: , ,
Wednesday, November 19, 2008 2:41 AM

I just love the Access Developers Handbook

I recently added the ability to view unit photo's on the main menu of the Granite Fleet Manager . However if the user doesn't have photos or doesn't want to view them on the main menu then I wanted the form to be centered. I figured that the...
Posted by Tony | 3 comment(s)
Filed under: , ,
Tuesday, November 18, 2008 1:08 AM

Watch out for Null OpenArgs

Well, I gave the problem away with the subject line. I had the following code which I thought was working quite nicely. If Left(Me.OpenArgs, 3) <> "New" Then But then I suddenly noticed when viewing a screen that a few fields were empty...
Posted by Tony | 1 comment(s)
Filed under: , ,
Friday, November 07, 2008 8:09 PM

Adding a record count to a tab caption on a tab control part 2

In my previous blog entry on this topic I stated "I also didn't bother putting any logic in to update the count of notes as the user was entering them. Hmm, for the sake of neatness and tidiness though I should." So I decided I'd better...
Posted by Tony | with no comments
Filed under: , ,
Tuesday, November 04, 2008 11:10 PM

Adding a record count to a tab caption on a tab control

I decided that it would be useful for someone looking at a particular part in the Granite Fleet Manager to know if there were any notes associated with that part. The idea being that there seldom would be any such and the mechanic wouldn't have any...
Posted by Tony | 1 comment(s)
Filed under: , ,
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 | 1 comment(s)
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: , ,
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, September 03, 2008 9:50 PM

SimplyVBA Global Error Handler for Visual Basic for Applications

Thanks to fellow Access MVP Alex Dybenko blog , for alerting me to Wayne Phillip's new product SimplyVBA Global Error Handler for Visual Basic for Applications . A very interesting product. Notice 1) that it will show you the call stack and 2) among...
Posted by Tony | with no comments
Filed under: ,
Sunday, August 31, 2008 4:31 PM

Still using VBscroll or Freewheel?

The problem is that the mouse scroll wheel doesn't work in the VBA editor in Access 2003 and older. VBScroll and Freewheel are the free third party solutions to this problem. Note that this is fixed in Access 2007. MS now has a DLL fix for this problem...
Posted by Tony | 5 comment(s)
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: , ,
Friday, June 27, 2008 4: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 Granite Fleet Manager 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, 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: , ,
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: ,
More Posts Next page »