Browse by Tags

All Tags » Granite Fleet Manager » VBA (RSS)
Sun, Nov 30 2008 15:23

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 | 1 comment(s)
Filed under: , , ,
Wed, Nov 26 2008 14:37

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: , , ,
Wed, Nov 19 2008 3:41

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: , , ,
Tue, Nov 4 2008 23:10

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: , , ,
Sat, Oct 4 2008 14:58

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: , , ,
Wed, Sep 10 2008 22:47

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: , , ,
Sun, Jul 13 2008 15:23

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 | 1 comment(s)
Filed under: , , ,
Fri, Jun 27 2008 16:15

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: , ,
Sun, Oct 21 2007 16:27

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: , , ,