I need to take a table of records ie:
total records 70
I need to range them based on 5, 20, 50, and 20 percent and need to update
based on the number so the first 5% will be updated with a Blue and then the

I have been reviewing the groups for ways to validate a phone number,
and I have found various techniques...
The one that seems to make the most sense is in the after update event:
If Me.Phone Not Like [###][-][####] then

While working with one of my database applications this morning, Windows
threw an error which kicked me out of Access.  When I got back into Access, I
highlighted a form, clicked on View-Code and the form opened in design view,
but the VB Editor did not load.  When I did it again ...

My form detail shows a list from a table. In the header there is a combo box
to set a limit on the display. When users open my form there is no focus on
any control. However, after making the combo box selection, the focus stays
on the selection and the cursor blinks. It would ...

How can I code my form so that when checkbox 1 (located on Form1) is
clicked, any information entered in textbox1 (located on Subform 1) is
completely cleared?
Thank you in advance for any assistance.

I am new to the Microsoft Access developement environment. I cannot seem to
get to select a row in the list box via the VB code. In VB.Net I would use a
command similar to this, I cannot remeber the actual command at the moment.
e.g.

I have a list box on a form that looks up values in a query and would like to
double click a value in the list box and bring up that record on the active
form.

Can someone point me in right direction
I want on Click of a button to open appropriate ticket in Remedy
Only way, That I can think of right now, is to create a Remedy shortcut and
then execute it.

I have a form that requeries data every 20 seconds based on a timer event.
When doing that I display the requery time as well - and I can see that
sometimes the requery intervals are longer than 20 secons - sometimes as long
as 60 seconds.

What would be the best way to round a currency value to the next highest
hundreth dollar? For example, $3,569.23 to $3,600.00 or $802.32 to $900.00.
Any help would be appreciated.

I am using the standard code provided by the wizard to go to a record on my
form based on the selection in a combo.  The code is as follows:
Private Sub Combo66_AfterUpdate()
   ' Find the record that matches the control.

In Excel, both my columns and rows are showing numbers.  Columns usually show
letters.  A user got this once before here but it went away when we rebooted.
Not this time.  How do I get the columns to be letters again?

My company decided to incorporate a bar code system into our access database.
I have been an access programmer for long time, but I have never worked with
bar code. Does any one know how it works with access? Is there a literature
on how to incorporate this into access database. ...

I am tring to display data on a second form based on a selected value in the
first form.
Open FORM works fine (this code is run from the first form):
   DoCmd.OpenForm "Form2", acNormal

Sorry to post again. I must complete this database for tommorow and am
getting frustrated, as I am evidently so bad at VBA.
This is very simple:
I have 1 Table made for a school. One of the fields, has the