Browse by Tags

All Tags » Granite Fleet Manager (RSS)
Tue, Apr 14 2009 19:43

New version of the Granite Fleet Manager - V1.63

A new version of the Granite Fleet Manager is available for download . Nothing major. Mostly a lot of updates in the temporary locations forms to make it easier to move equipment from job site to job site or back and forth to your main yard.
Posted by Tony | 1 comment(s)
Filed under:
Fri, Apr 10 2009 16:00

Updating backend MDB tables, fields, relationships and indexes

Short posting I like using the Compare'Em utility which creates the necessary VBA code to create/update tables, fields, relationships and indexes. It works by comparing your last version of the BE MDB with the latest development version of the BE...
Posted by Tony | with no comments
Filed under: , ,
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 | with no comments
Filed under: , , ,
Sun, Nov 30 2008 15:08

I never knew that - view linked table file path and name

I was in the table view in Access 2003 and accidentally hovered over a linked table. A tool tip (mouse over tip) displayed itself a second later telling me the backend linked MDB file path and name. Cool! I never knew that. I should add that I go to great...
Posted by Tony | with no comments
Filed under: , ,
Sun, Nov 30 2008 14:13

New version of the Granite Fleet Manager

Ten year annual maintenance costs report Email feedback form Added meaningful error 2114 screen Minor UI improvements and bug fixes http://granitefleet.com/ Commissions paid to sales agents.
Posted by Tony | with no comments
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: , , ,
Sat, Nov 22 2008 19:32

Email feedback

I got to thinking about how to make it easier for folks to send me feedback good, bad or ugly. And I realized it would be quite simple. While my software does have SMTP email code this requires users to configure the system for their email account, SMTP...
Posted by Tony | 1 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: , , ,
Wed, Nov 19 2008 2:35

New version of the Granite Fleet Manager available for download

I just uploaded the latest version of the Granite Fleet Manager to the website. Added customer invoicing including labour rates, markup percentages on parts , parts types and external invoices and sales taxes. Added internal invoice number and customer...
Posted by Tony | with no comments
Filed under:
Tue, Nov 11 2008 0:40

Losing the [Event Procedure] on a command button

I just added a tab control to my standard File Locations form in the Granite Fleet Manager program. I added the tab control and cut and pasted all the controls from the form to the page on the tab control. I then discovered that I had lost all the [Event...
Posted by Tony | 1 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: , , ,
Thu, Sep 25 2008 16:00

The sordid life of software bugs, exposed!

The sordid life of software bugs, exposed! is a very interesting look into the software bug process within Microsoft. While this is about another MS product my impression is that this a very common approach within Microsoft. If you are going to report...
Posted by Tony | with no comments
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: , ,
Thu, May 1 2008 23:39

Background colour of forms

In a comment to my Multi Row Tab control posting Diana asked: "Just curious, is your form really that blue color? Is it in production? How do your users feel about that color? Would you design a web page that color? I'm always curious why Access...
Posted by Tony | 7 comment(s)
Filed under: ,
Mon, Feb 25 2008 3:24

Multi Row Tab control

In my Granite Fleet Manager I'm soon going to be adding enough tabs to the following form that I'll run out of space. I didn't like the looks of the default behavior. So I asked in the private MVP Access newsgroup how you could get multi line...
Posted by Tony | 2 comment(s)
Filed under: ,
Mon, Dec 24 2007 13:25

Write a list and check it twice

A very interesting post on relating drastically reducing hospital infections and smooth code check ins. Write a list and check it twice . Now how does this apply to us Access folks? I'm not quite sure. I do testing as I add new features to Access...
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: , , ,