I've created a listbox with multi select set to "none".
When I run the code below I receive a 2115 error on the setfocus when there is one item selected.
 For Each varItm In Me!lstJumpHeight.ItemsSelected
   Me!lstJumpHeight.Selected(varItm) = False

I have been told that using Dlookup is terribly inefficient and as a result
I am trying to replace all instances of Dlookup in my VBA codewith SQL.
How would I use an SQL SELECT statemenet in VBA to lookup a specific value
from a table?

I wonder if it is possible to take a clients address and zipcode and
hyperlink it from my form to a map sight?  I've seen it done with other
programs.
Can someone help please ?

We're offering all the latest factory pressed high quality dvd movies,
ps2, psp and xbox silvers with factory printed colour inserts at
fantastic prices, whether for personal use or reselling. We're shipping
worldwide with various shipping methods. For resellers, please contact

I have a calendar utility that can display a title.
My form has several date fields and when a user double clicks on a date
textbox my calendar pops up.
I'd like the title to be the label attached to the date box.

I was wondering if it is possible to split a textbox into an array for every
500 characters.
What I was looking to do is to take the text in a textbox and split it up
for every 500 characters in the current box - the "split" up text would then

I'm using a form with navigation buttons enabled...When I click next record
button right arrow) and I'm at the end of the table will add an empty record.
If I click next record 10 times will add 10 blank records.
How can avoid adding a new record every time when I click next?

I need a easy way to activate the scrolll bars when the number of records
exceed 4 on the subform.  I have placed this code in the on current event of
the subform:
If Count() > 4 Then

Say there are 3 buttons in an option group whose values are 1,2,3.
Say option 2 is currently checked. When option 1 is clicked I do a validity
check (in the option group OnClick event) and it fails. How do I know what
the previous value was so that I can set it back.

I have create an Access DB for client tracking but looking someone up is a
pain using the Binoculars.  Does anyone know how to create a field that has a
Type Ahead feature.  If the name you are looking for is Smith as you type smi
you are seeing all the Smi...

Is there a way on a form to put code on a label that when someone clicks on
the label it sorts the information on the form by that field.  Example:  If
you have 3 columns (First Name, Last Name, Employee ID).  I want to be able
to click on the label Last Name and it will sort ...

Is there a way to combine the data from 2 fields into one. For example, I
want to keep track of company name changes so I have a table of companies and
a table with the history of the company including name changes. I want to
search by old names and current names. Is there a way ...

Hi,
I'm using Outlook Express and Access XP.  Is there a way to type
"you@yourcompany.com" into a field and have the form change it to
mailto:you@yourcompany.com?  I would like to 'hyperlink' from an email

How can I click on a checkbox to indicate that a company has closed and then
automatically turn all fields in the form grey while still being able to see
the data in the fields.?
Thanks,

How do I export the code (from modules, from many controls on forms),
from one Access 2000 database?  I would like to capture all the code in
a text file.  Thank you.