I found the following code which allows me to sort on the click event
of a labelbutton.
The problem occurs when I try to call the function directly from the
ClickEvent, instead of having the ClickEvent run its subroutine.

I have a small database, where names of applicants are recorded with
some other data. If an applicant telephones twice, he can be recorded
twice.
I am trying to check - by name.

I need to make a report that will list my client's monthly revenue and
the year to date.  I want it to basically look like this
                 Jan                  Feb
March              etc.                YTD

A colleague has just installed a large Access 97 application on Vista
and hit some problems.
For example, on a subform showing a list, the lower part of the list
shows as blank.  As you click in a control, its value appears.

I work with a highly programmed Access
database (some 15,000 lines of VBA code, much of it automating data
entry on forms -- and believe me, it's very tight code). In Access
97,

I have a simple query.In one colomn I make a new field out of two.
COLUMN
ID: [MNR] & " " & [TASK]
Group By

Imagine a restaurant which we want to store information about. Two
types of people are related to it.
1)    People who simply call and the foods are delivered to them.
2)    People who actually come to the restaurant and eat their food

I am trying to pass a form lookup that is built in code. I will give
an example below.
Truncated to only show the relevent information.
Dim PDate as String

I have a 15 LookUp Tables tied to 15 ComboBoxes.
Some of the Tables contain 3 to 10 Recs, and a couple contain up to 50
Recs.
1- Is it a CommonPractice to link the field that gets the ComboBox

I'm trying to do a selective deletion from an 'Archive' table based on
dates.
Here is the setup:
Table 'Archive' has a date field ( [DateArchive] ).

I have several buttons that show their button info when you move over them
with your mouse. I addes 3 new buttons and added button info but for them
the info doesn't show up. The settings seems to be the same as the other
buttons. Any idea what's going on here?

I needed a report so I used the report wizards to make it based on a query I
made (also made with a wizard).  That all works great.
However, now I need a identical report only based on a subset of the data I
used for the first report...plus, a little other info (from another ...

Greetings!  My situation is this.  I currently have a database of
which in a form displays jpeg pictures (one at a time) which are
linked to the db and stored in a separate folder.  I have set up a
report with an image control do display/print 4 pictures on a page.

I'm new to Access and need some help. I made a database for my school w/
all the studentsnames,class,etc.. I want to know how and if I can
highlight a column. Also I need some help setting up a query using theie
ID#s.

When I came in on Monday and tried to open my database, everything
worked fine until I tried to run the database splitter.  It didn't
work, but when I tried to go back into my database, it says I have no
permission.  It doesn't even recognize me as the owner anymore.