I have a replicated databse that is used in both 2003 and 2007. Most
development is done in 2003. I have stability problems with
replicated/synchronised databases when running in 2007. The database normally
opens with a switchboard menu, but on occasions the following error ...

How can I get my print button to just print the form I am looking at?

Our school is reporting demographics to the district and I'd like to build a
query that is stumping me.
We have a Yes/No field called "Free Lunch" and another called "Reduced
Lunch".  I'd like to add the total count of both lunch fields, separated by

Hi,  I am having problems in getting data to fall into a particular date range.
I initially tried to query on the date entered however, because we don't use
calendar months this proved challenging when working with progressive
quarterly and yearly figures.

I have ten tables that I want to merge into a single table. As of now,
they do not have a unique primary key.
They have the same field names.
There are not any duplicates, so the end result will simply be a

I have a large table and want to export from that table into lots of
others...
In my table I have a CatNr field which I would like to name all my
exported tables as - there's over 1600 entries which will end up in 95

I have a data base that tracks all of our machinery "lubrication Due" by
dates. Is there anyway they cane be made to show up in Outlook on a monthly
calander or even better yet, pop up as an apointment reminder?
Any advice would be a great help

I am entering records in my Microsoft Access database .. many of the entries
are the same .. is there a way to turn on a feature such as AUTO COMPLETE? ..
not sure if that is what I am looking for .. just looking for something say
for example if I type the name of the company in ...

I am running a query based on two tables and have created the outer left join
relationship in the query which works beautiful.
when I run the Query, It returns Quantity Shipped this month and Quantity
shipped todate. If an item does not shipped in this month, it would return a

Does anyone know of a way to permanently stop the Default Value of a table
from defaulting to 'ZERO' for Number data types?  Of course, I can manually
remove them, but sometimes I forget - and as a result, averages are skewed
with summary calculations.

I have these 28 colums in a 2007 accdb table.  When I display the table or
run a query, cols 1-8 and cols 20-28 are displayed; cols 9 - 19 are not.  The
columns show on the query design screen and grid and are found if I reference
them in the query; they just don't display.  Can ...

I have written a function that performs a search through Outlook's GAL using
a person's name as the search field and returning their email address.  It
works fine, except for the pesky Outlook security prompt.  I have a copy of
Redemption with which I can bypass this, but am ...

I have an Access database that I would like users to be able to see reports
from or enter data into forms remotely.  We have a VPN but even with a T1 the
performance is just too slow to realistically use the database.  Can I
accomplish this with Sharepoint Services?

I'm trying to import an excel file using a macro and a field on a form.  I
would like for the macro to reference a field in a form to capture the path
of the spreadsheet.
This is what I entered under the File Name argument:

I have a table of Propert Addresses, and a Table of Tenants within the
properties, and I am trying to build a table for maintenance issues.
The first column of the new table is a straightforward lookup combo box
derived from the addresses table.