Browse by Tags

All Tags » Tips (RSS)

Several VBA coding tricks

An interesting question was asked. How to make the following code simpler with Arrays    Now the poster was asking about arrays which I felt was going in the wrong direction so I replied with the “tricks” I use.
Posted by Tony | 2 comment(s)
Filed under: , ,

Making a search form much easier to use

This organization, among many other things, provides counseling.  The receptionist books the appointments and over the years they’ve accumulated a lot of names.  The counseling manager stated they were cleaning up the data and inactivating individuals...
Posted by Tony | with no comments
Filed under: ,

Queries On Steroids ... Part IV

I was reminded of this article in a discussion in a newsgroup/forum.   As I’m always interested in the hard core details of anything computer related but especially anything to do with Access or Jet I thought I’d share this with you. Queries...
Posted by Tony | with no comments
Filed under: , ,

Kicking out users after inactivity

I just received an email thanking me for the Auto FE Updater and expressing a certain amount of annoyance at users who don’t exit Access at the end of the day. I use the following to kick users out so I can make changes to the back end after hours. HOW...
Posted by Tony | 2 comment(s)
Filed under: , ,

Excel To KML - Display Excel files on Google Earth.

Excel To KML - Display Excel files on Google Earth .  “Import a spreadsheet of lat/long coordinates to Google Earth.  Pop-up balloons, icons, and paths are easily created from the spreadsheet data.” It doesn’t take much to create a spreadsheet...
Posted by Tony | 2 comment(s)
Filed under: , ,

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

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 | 3 comment(s)
Filed under: , ,

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

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 | 1 comment(s)
Filed under: ,

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

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

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 | 1 comment(s)
Filed under: , ,

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

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 | 3 comment(s)
Filed under: , ,

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

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

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

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

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

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