Browse by Tags

All Tags » Tips » Access (RSS)
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: , ,
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: ,
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: , ,
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: , , ,
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: , ,
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: , , ,
More Posts Next page »