I must admit, all I do in Access is puddle around. But I have been
searching for how I can correctly show age in a database I am making,
and have discovered, as Allen Browne says,
"These examples do not work reliably:

Have recently installed Spysweeper. Performance of Access has
deteriorated. Example. I use a function to swap from one of our
companies to another by delinking and relinking to a different set of
backend tables. With Spysweeper not running process takes 1+ seconds.

I am trying to calculate tax on my form, but the value in the unbound text
box is x.xxx , how do I get this to just x.xx ?
TIA

I have the following filter in a report:
[MonYer] = 'August 2005' and [RepresentativeTeam] = 'Client Information
Center' And Left(PolicyNumber,1) = 'Z'  or 'H'
My intention is to have records returned if in August 2005 with the

I have a database that has a "settings" form that is always open and
hidden unless an "Admin" user chooses to view it. The form is bound to
a "settings" table that has one record and several fields related to
the settings on the form. I use the info on the "settings" form to set

I have a query that references abn unbound textbox on a form to get the
criteria.  The unbound textbox can read 'Brian' or 'Dave'. Or just
'Brian'.
However, I think the query is seeing this as "'Brian' Or 'Dave'" and

Hi Everyone, hope you can help.
Our company has recently migrated from NT and Access 97 to XP and Access
2003 and in the process a number of problems have surfaced.
The team I work in are responsible for managing a number of databases, some

I suspect this isn't possible, but I recently moved a app to SQL Server
and it contains a Project table.  Now I have a new CRM tool that needs
to be mobile, but should also synch with the Project table on SQL Server.
I really like the idea of replicating an Access database for the ...

I have a table and one of the field is  a text one
In this field I have something like 00-D1-06  or 142-451-A3-001
those represent drawing number
As each one represent also the name of a pdf file somewhere on our

How do I concatenate two fields in the same table... For example, I
have two tables, first one is called familynametable that has a
familyID and familyname field.  This table is connected to a
individualnametable that contains three fields: individualnameID,

Looking for suggestions ----
A database was designed for a national automobile inspection program. In
it's simplest form, the database has two tables:
TblOwner

Is there a way to do partial replication of data?
I'm looking at having a central back end data file which contains all the
data from all users. But when each user synchronises the mobile data files
with the main data file, I only want data which is relevant to that user to

I have a form with a button that opens a report "RepBilling"
In the OnNoData property of this report I put msgbox "There is no
record"
When i click on the button, if there is no record the message box opens

I want to be able to loop through all the controls on a form, get
their names, and then check if they contain a date, number, or string.
Is there a function to test the contents of a field or control?  I am
using Access 2003.

I am trying to print a contract for a customer specifying use of their
credit card number.  For some odd reason the number is being rounded.
I checked - it's a text field. On the other hand, I format it as:
CCNO: Format([CCNum],"0000-0000-0000-0000")