I have a table that shows:
Serial Number    Date Returned
2333005Y    8/15/2006
2333005Y    7/18/2003

what function or code i should write in order to get the number of
records/rows in the form application?

The scope of a boolean query displays -1 or 0.
You can modoficare to show a checkbox?

Please excuse the basic question, but I am new to access.
I have just changed a machine form NT4 to win2000 and moved an Access
2000 database as well.
When on NT4 when the database was open, if someone else on the network

Hello...
I'm new to MS SQL, so please be nice... LOLOL
I decided to go from Access 2003 with the MS SQL Express Edition (I
really don't need all the features of the full version, if so, I can

I have code that current sends spreadsheets by email from a user's
Outlook.  I need to modify the code to send the email from their group
email box, so the recipient can respond to the group email.  Any ideas
how I could do that? Here is part of my code:

I am trying  to use windows scheduler to compact a database. In the task run
line I have the following:
"C:\Program Files\Microsoft Office\OFFICE11 MSACCESS.EXE" _
"C:\Files\Access\Sacroc.mdb" /compact

Hi all--
Does anyone have any insight as to how I might create a search form
that allows a user to select criteria based on any related table in
the whole database. The search form I have now only allows me to

I have a table looks like this:
PKID   SomeData SomeMoreData  IntegerValue
1             Stuff         More Stuff         300
2             Cool         Very Cool          400

If I want to retrieve a full version information for an ms access
databases, I use (from vb6 code) the "Access.Application" object and
SysCmd method. Whit the number returned by the method I can identify
the service pack applied to database (e.g.

I have suddenly gotten several replication conflicts where in the
winning conflict box, the following is shown:
"This row contains data that violates a table or fields level validation
rule that was added at the design master, after the time the data was

In my database I have a 'control table' in which basic info is stored about the application, for instance the application's path and the name of the company that is using it. In all of the application's reports I have a page footer with an unbound field that retrieves and shows ...

I'm trying to find how to know if there is a current transaction
(after using DBEngine.BeginTrans).
Is there a property or function that indicates me that????
Thanks.

These one may be a bit tricky, and what I'd like to do may not even be
possible. I would love to hear any ideas you guys have for solving
this.
Here is the situation: I have a form that displays the high-level data

The organisation I work for is on the verge of buying Microsoft Office
2007 Pro Plus OLP NL. We currently use Office Pro 2003. Our business
system is written in Access 2003 with a SQL Server back end.
I've heard that it's possible that the version of Office we are buying