Is it possible to assign an On Click event to a label on a subform which will
allow you to sort the records displayed?  For example, the label for the date
field on a subform: click on it the first time and records are sorted
ascending. Click on it a second time, and records sort ...

I have a table that I want to query on.  In this table for some reason,
the original designer used separate fields for Month/Day/Year.  So one
field for Month, another for Day, and another for Year.
The form I created has two calendars on it.  The calendars allow the

I am building a form for data entry into a table with
about 4000 names.  I know the user can use the ctrl + F
to search, but can't I just add either a field or button to
do a find that will populate the fields on my form so

I did not get any response to a similar posting last night so I am trying to
state my problem more clearly.
I have several Option Groups on a Form.  One Option Group has 3 Option
Buttons with no defaults.  The first time I click a button, the first option

Does anyone know if there's a way to get a value to pop up like a tooltip
when you mouse over a field? I want the contact's phone number to pop-up in a
tooltip fashion when you mouse over the ComboBox with their name in it. I've
got a ton of info on a screen & it's way too busy ...

I am an MS Access newbie.
I have a form with two subforms. Main form and subform both quries the
SQL db though ODBC link. When I run main form and subforms
independently, they are very fast but as soon as I put them together in

I have a form with a command button which does the following:
[bprice] = [rprice] * 0.77
[rprice] is $12.50 and when you do the above, [bprice] is 9.625
It works fine.  When you view the field it shows 9.63 but when you click

In a continuous form, I'm finding that the vertical scroll bar has a "bug"  
in it where if don't have enough records to fill the form, the scroll bar  
remains visible and if you use the mouse to scroll down, I'm finding that  
you can't scroll back up again to view the first ...

when I use RTFheight in the Change-Event, the cursor disappears.
It is still there, but invisible. How can I get my cursor back?
Michael Bruschkewitz

Ok..so I was on yesterday, and I received some gracious assistance, and after
really working on it, I can't figure it out still.  Basically, I am not able
to enter info into my form and have it save in the form.  The info goes to
the table, but it doesn't create a new record in the ...

We have a students table [tblStudents] with approximately 4,500 records. On
frmStudents, we have a "Find" Combo Box that works 99% of the time. the Combo
Box uses the value of StudentID to find the student.
When two people have the same last name and a different first name, it ...

I have a simple flat file db that tracks Time & Attendance for me at work.
All of the fields have default values so I wrote a short "dirty record'
script that saves the new record. Without that script, the record won't be
saved.

I am new to the Access game and run across issues that I just do not
have a clue how to do...
On my form I have a Combo Box where the user selects a store number and
all the pertinent information in the textboxes fill in...this is for

Looking for a quick bit of advice ... I have a Form which currently contains
numerous buttons. I change the colour of the Font on each button using and If
loop ... ie if 0 then Green if greater than 0 red
If Startup.btn1.Caption = 0 Then

Although Access provides many options to customize the look and format of a
Form, the "Command Button" is defaulted to grey with no optons to change its
color. It would be great it the user had the ability to change the command
button color/design in order to coordinate the look ...