It would be nice to be able to select part of text in a field and make it
bold, italic, etc., or even change its color without affecting the rest of
the entry.  I use a subform where I'd love to be able to accentuate a word or
two in it without the whole subform taking on the ...

I have a form "Clients" and a subform for the multiple projects under a
specific client. I want to be able to create a checkbox in the subform where
I can check the box for one project and not all the others. So far I've found
if a box is checked all projects/boxes are checked. ...

I recently changed the appearances on an XP machine for a visually impaired
individual. After making all the changes, the only thing that does not work
properly is printing anything out of Access. The black background prints
along with the document. The appearance settings are ...

Hi Access MVPs,
I'm using Access 2003.  I have a bound form with subforms that's used
for creating and revising records.
My issue is on the side of revising existing records.  Once the user

I am using MS Access 2003.
My database consists of anglers(fishermen) and their catches.  My query
produces a list of anglers and the date and time and weight of each fish
caught by that angler.  I want to produce 2 reports: summary & detail.  I can

Does anyone know where I might obtain a (free) database template for a
personal collection?
I need to be able to include several photographs of eah item and include
those photos in a report (one page per item).

I have SQL Server 2005 Developer Edition installed on my PC. I can connect to
it with SQL Server Management Studio and with a Visual Studio web Project
running on the same PC. However, when I create an Access 2007 Project (same
PC) and set the SQL connection to connect to the ...

I have an Access database in which infomation on trapshooting contestants is
stored.  Is it possible to link to an Excel spreadsheet so that when we
update the records in Access, it will automatically update the spreadsheet?

If I change a Table field name in the Design View, will it have a cascade
effect and Automaticaly change all the names in the queries, forms and
reports?

We receive data from our corporate office, in an Excel spread sheet with the
date and time the data was collected in one cell. That data is then appended
into Access. We need a query that will filter out all records except the ones
from yesterdays date. We have tried using ...

Hi, I'm building a stock management system, which lists all the items which
my client's company use, and how many they have in stock.
Should they want to reorder some products, they can search the product's
name and description to show a list of products that match keyword.

I have some email templates created in outlook that are saved on my desk top.
Currenty I copy and paste the email address into the template.  Can I use VB
to write something to open that specific teplate and insert the email
address.  I was thinking of putting it on the doubble ...

in a Data Access Page? So that a default value appears in the dropdown
--
justme0010

I am trying to wrap my head around a record couting delima.
I need to count the number of records in my table for "Total", "Open", and
"Closed" using a "Reporting Period" which ends each Quarter.
The user submits their report at the end of each Quarter and I use that

I am trying to use the folowing code as per Microsoft article 210239,
but I get a compile error "Method or Data Member not found". It stops
on the first C.
Any ideas?