I have a block of text with about 19,000 characters - alphanumeric,
punctuation, hard returns, etc... I would like to count the number of
periods ( Chr$(46) ) appearing in the document. Whats a good little
code snippet to do something like that?

I have a question on running queries via a form.  My situation is – I
have a query (qrysearch) and this query has a number of fields e.g.
(company, employee etc).  My form is linked into the query and has the
same fields as the query.  I would like to use my form as a way of

My report is based off of a table. I need a record on the report to be
highlighted if that record ID is in a different table. Something like,
if record ID exists in Query X, then conditional format this entry on
the report.

Hi, Anyone help.....
I'm using Dev Avish's code to download various web pages onto my own
pc. I play around with these pages and get them into a format I can
meaningfully use...so far, so good....

I have two tables (Access 2000). In the first table I have a column
containing postcodes. In the second table I have a list of all
postcodes for a particular borough. I'm trying to write an update
query that queries the postcode column in the first table and searches

I have a password management database in which I can scroll through a
list of employees for a specific location. I have a nifty generate
password procedure that we use to change passwords on a monthly basis.
The Problem:

I have a table that includes fields InspectionDate and BuildingNumber.
I would like to query the data to return records showing the most
recent InspectionDate for each unique BuildingNumber.  There are about
150 unique building numbers.  Use of either query criteria or VBA

stroccur = DCount("[cattype]", "empnotes", "[cattype] = " & Chr(34) &
Me.Rpt_Card_Type & Chr(34) & " And [SSN] = " & Me.SSN & " And #" &
[datetime] & "# > " & DateSerial(Year(Me.datetime) - 1,
Month(Me.datetime), Day(Me.datetime)))

I have an Access report that works well.  I need to add a prompt for
the user to input the month of data that the report will show.  I used
an InputBox and instead of showing that month in the report, it shows
all months in the table.  And the InputBox is automatically populated

I currently have vba code that ranks employees based on their average
job time ordered by their region, zone, and job code.  I currently
have vba code that will cycle through a query and ranks each employee
based on their region, zone, job code and avg job time. (See code

I currently have a form with 3 text fields that I wish to use as my
search criteria. I am having trouble constructing this. So, basically
how can I use the text in these fields to serach for the required
records in a table.

I want to make a message box appear on the NotInList event for several
combo boxes.  The message box will alert the user that if they need to
add a value they must go through the database administrator.  I have
some code that isn't working but I assume it's close.  I just don't

I'm pretty new to using access and I can't figure out how to sort dates by
month, then day within the month, but disregard year. When I try to put into
ascending order it always uses the year.
E.g.: What It should look like normally, and does is:

I am needing some help with a database I am putting together. The database
works off of a main Form, which then has buttons on it that will open up
other forms. The problem I am having is that if I am updating any
information on the current record, and then open one of the other ...

My client has a database that was written in Access97.  The database
is password protected.
If I try to open the database by double-clicking on it, it asks for
the password.  In Access97, I can enter the password and open the