Browse by Tags

All Tags » Tips (RSS)
Mon, Oct 5 2009 5:09

Is Nothing

I’m working on some largish updates to the Auto FE Updater and I wanted to ensure that the new routine which logs errors would properly handle the situation if there were errors in the error logging routine.  A great deal of searching a dimly remembered...
Posted by Tony | 1 comment(s)
Filed under: , ,
Wed, Sep 23 2009 15:32

InStrRev

I’ll be darned.  I had no idea InStrRev existed in VBA code.  It is new in Access 2000 so it’s been around for nine years.  I had to build this function myself in A2.0 or A97 to get the file name from a string which had the path and file...
Posted by Tony | 1 comment(s)
Filed under: , ,
Tue, Sep 22 2009 22:32

Queries and the 3061 "Too few parameters. Expected 1." message

Your query is working just fine referencing a form to select some records: but when you run it in code you get the dreaded 3061 "Too few parameters. Expected 1." message. One option is to evaluate the Forms![Form name]![Field Name] expression...
Posted by Tony | 2 comment(s)
Filed under: , ,
Thu, Aug 6 2009 14:55

An approach to sending text messages from within an Access application

Steve Schapel, fellow Access MVP, answered a question about sending SMSs with a page on his website.  An approach to sending text messages from within an Access application    I can see this capability being quite useful in some consumer...
Posted by Tony | with no comments
Filed under: ,
Thu, Jun 18 2009 16:16

Steps to think about when doing a data MDB back up, compact or zip.

I have a button on my Granite Fleet Manager app which allows the user to do a backup of the backend data MDB. I also have two other buttons which zip and email the backend data MDB to either themselves for backup purposes or to me for support purposes...
Posted by Tony | with no comments
Filed under: , ,
Thu, May 21 2009 20:31

Redimming an array 1,000,000 times takes 4.63 seconds

The following question was asked at StackedOverflow. How do you redimension an array in VBA? . One response was some detailed code showing how to redim an array efficiently by doubling the number of elements. This took 0.41 seconds for a million records...
Posted by Tony | with no comments
Filed under: , ,
Sun, Apr 26 2009 15:35

Access Demos, tutorials and basics

Thanks to a posting by Bill Mosca Access (2007) Demo Videos can be found at Access Demos Also see Access Basics by Crystal fellow Access MVP. She also has some Video Tutorials
Posted by Tony | with no comments
Filed under: , ,
Sun, Apr 26 2009 15:18

Some code to tame the Office Ribbon for Access (2007)

Albert Kallal, fellow Access MVP just announced the following: "The office ribbon is an amazing new interface. The problem with the ribbon is that takes a lot of code to change the ribbon at runtime. Solution: With my ribbon class you can enable...
Posted by Tony | with no comments
Filed under: ,
Sat, Apr 25 2009 15:32

Overflow error 6

A newsgroup poster had the following very standard lines of code strSQL = "SELECT Mytable.Field1, Mytable.Field2, Mytable.Field3 FROM Mytable" SET rs = Currentdb.OpenRecordset(strSQL,dbOpenDynaset) The error was Overflow error 6. He then replied...
Posted by Tony | 2 comment(s)
Filed under: , ,
Mon, Apr 20 2009 23:36

A bizarre report problem

So Jim phones me with a very strange report problem as per the below portion of the report. It's impossible to have the PM010-03B as a duplicate as that is a no duplicates allowed index in the table. Besides where is the data in the field to the left...
Posted by Tony | 2 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: , ,
Fri, Apr 10 2009 15:19

Which control has the focus?

Sometimes when you're tabbing around a form the focus disappears. Dirk Goldgar , fellow Access MVP , has a very useful and simple solution to determining which control has the focus in a newsgroup posting . "If you want to know where the focus...
Posted by Tony | with no comments
Filed under: ,
Tue, Mar 17 2009 14:28

What is the best way to understand the tables,queries, relationships,etc?

KrispyData asked the following question in the newsgroups What is the best way to understand the tables,queries, relationships,etc. I am new to Access and taking over an entire database. Philip Herlihy had an excellent reply well worth reading. Jeff Boyce...
Posted by Tony | with no comments
Filed under: ,
Mon, Mar 2 2009 20:34

Hiding 70 controls based on a value

At the blog entry Getting a list of control names on a form Nate posted the following comment: Thanks for the great tip! It doesn't seem to include labels and command buttons, but it is still a great help. I have a form where I am hiding 70 controls...
Posted by Tony | with no comments
Filed under: , ,
Sun, Feb 22 2009 23:32

Using record selector on a form to select multiple records

A fellow Access MVP asked if there was a way of using the record selector to select multiple records and perform an action on them. Tom Wickerath, also a fellow Access MVP, responded with How to enumerate selected form records in Access 2003 and in Access...
Posted by Tony | 2 comment(s)
Filed under: , ,
Sun, Dec 28 2008 22:56

Why Do So Many Programmers Use One Character Index Variables?

Why Do So Many Programmers Use One Character Index Variables has a very good point for those of us of a certain age accompanied by greying hair, bifocals and ... And yes I did learn Fortran as a teenager at the local college. Although it was actually...
Posted by Tony | 4 comment(s)
Filed under: ,
Fri, Dec 26 2008 22:53

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: , ,
Tue, Dec 23 2008 15:36

The case of the form which took 30 seconds to open

The client had two transaction file forms which took 30 seconds to open while a similar form took 3 or 4 seconds to open. I went through many of the items on my Microsoft Access Performance FAQ page and none made a significant difference. The list of...
Posted by Tony | 2 comment(s)
Filed under: , , ,
Sun, Nov 30 2008 16:18

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: , ,
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: , , ,
More Posts Next page »