225     If 1 <= MyCount <= 4 Then GString = "a few days ago. "
230     If 5 <= MyCount <= 10 Then GString = "a week or so ago. "
235     If 11 <= MyCount <= 17 Then GString = "about 2 weeks ago. "
240     If 18 <= MyCount <= 24 Then GString = "about 3 weeks ago. "

Here is a chunk of code that works for an individual record. It
evaluates dates and checks or unchecks boxes as it goes along. It may
not be pretty but it works. What my problem is that I need it to
evaluate all the records(200+) in my db and change those which need

Since I have no desire to be either compared to RantMan nor
used by him as an example, I have taken the painful step of
having my sig surgically shrunken as can be seen below.  I
felt no pain during the procedure thanks to copious

I created a report that contains a OLE Unbound object that is a graph.
I added the code below to the Detail, Format event.  When I run the
report it takes approx. 50 seconds for it to open.  If I run the query
that is it's data source, the query opens quickly.  Is there anything I

I've created a student database for our program that I also need to
get statistics from.  It's in Access 2003.
The statistics would be things like Male-Female percentage, percentage
of students from various parts of the world, that sort of thing. I was

I'm hoping someone can tell me what I'm missing about how to open a browser
and go to a website from a button or a link in Access 2000.
I've tried designating a field as "Hyperlink type" and typing in an URL.
I've tried using the Hyperlink field on the Button Properties sheet, and ...

Using Access ADP and MSDE.
can some one please tell me what is wrong with this SQL string using
ADO. I get an error somewhere around the LIKE statement.
           .Source = "SELECT tblCustomer.FirstName,

i got a a query that gives me the following results:
Month                       2003                 2004         2005
Aug03                      11,000            
Aug 04                                               3,200          

i can't get this working.  in vba i tried to set visible to false in an if
statement that looked like this:
Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Forms!formquerybuilder.Controls!cboxdepartment) = False Then

I have a database of address that are downloaded from the internet to excel.
I have imported the data to access to create mail-outs easily, however, it is
necessary for me to keep the excel worksheet- as this is my only application
option when downloading the data.  Some addresses ...

I have an Access application that is being used by 150+ clients. I
develop in 97, convert to 2000 and distribute as a 97 or 2000 mde, or 97
runtime. This limits me to 97 functions. My clients may use any one of
Access 97, 2000, 2002, 2003 or 97 runtime.

I hope someone can help with this strange problem I've encountered:
I have an Access interface that is used to access a SQL database.  The
interface uses some stored procedures to display information from the
DB.  If I edit the underlying tables of the SQL DB using the ALTER

I am trying to read Unicode (Kanji character) data from a text file.
When I store unicode data into variable my Kanji character gets messed
up.
I am using following code

Does
Date = Date + 1
mean
Date Statement equals Date Function plus 1?

I have a project in which I only need read access to a Microsoft Access
database (.mdb file) via JDBC and unfortunately, the file is frequently
locked by another application when I need access to it.  I figured that
I could bypass the lock file by creating a symlink (my os is Fedora