Browse by Tags

All Tags » Granite Fleet Manager » Access (RSS)

Accessing external data using the IN clause in SQL

I happened to come across this article Accessing external data using the IN clause by the Access product group recently again.  I thought I’d do a blog posting describing how I use the IN clause to update tables in the Granite Fleet Manager when...

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

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 | 5 comment(s)

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 | 1 comment(s)

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)

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)

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)

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)

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)

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)

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

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)

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 | 2 comment(s)

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)

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 | 3 comment(s)

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