In a table I have two numeric fields (e.g. FieldA and FieldB). Both fields
have double precicion (field size "double"), Format "Fixed" and Decimal
places "3" since I want to calculate with at least 3 digits precision (e.g.
values might show as 0.123).

I have the following problem:
I have a query (a) using another query (b) to get the amount of records
of this other query (b), means:
select count(MNR) as Number from Jahrbuch_Einzelversand_Komplett (while

I'd like to create an Access database for my the central filing system
of my office. My boss can never find where files are. We have approx.
2000 files in a dozen file drawers, each drawer with a master category
(company, goverment, organiations, archives, etc.) and containng ...

I have a student database where all details of students are entered directly
onto a main form, there are a number of subforms on this that record each
students activities.  One of these is an absence form that is based on a
small table as follows;

User needs to be able to send an emailmessage from an emailaccount other
than his own. The rights are set so that he is authorised to do so. The
sendobject doesn't seems to give the option to set a different emailaccount
as sender. Is this even possible in Access?

I have the code beneath to create a mail message. It needs to be edited
manually before it gets send. It works well if the editor indeed sends the
message. But if he cancels the message, Access will give an error message
saying the sendobject command has been canceled. I tried to ...

Question:  How to put access data base onto a web page?

I have a 2 field table. Field 1 is Category (unique) and field 2 is
FilenameToOpen. In code I would like to search for a value in the field
Category. When the record is found I would like to pull out the value of
FileNameToOpen of that same record, in order to open the particular ...

Learn how to optimize and tune up your system, get rid of boring
errors and uninstall unnecessary  thing with very useful tips and
tricks
http://windowsxpsp2pro.blogspot.com

I'm trying to set up a query that runs from a command button on a form
(simple enough so far), what I want the query to do is take values
from the fields on the form (seven fields in total) but sometimes not
all the fields will be filled.  If a field is empty then the

I have a problem with pages being printed out of order. An example is
a 15 page duplexed report.  Title page fine back of title page blank.
(As it should be) SEcond page front, bottom says Page 1 of 15.  Second
page back says Page 10 of 15.  Third page front says Page 3 of 15.

Hi, I use Access2002 SP3. I have taken ownership of a mdb which I
would like to redesign. I want to repoint all current queries from a
daily table to a new historic table. There are over 30 queries
pointing at the old table. Does anyone know of a quick way to repoint

I have got an access file and I have set the persemission which logically
has got registered in the system.mdw in the machine I have set the users
permissions - but I have noticed if this access file is copied with all its
permissions to another machine there are no restrictions ...

I've been using OdbcConnection, OdbcCommand, etc to do work associated with
an Access 2003 database - is that the best?  What are the other
alternatives - and their pros/cons?
Any/all insights - much appreciated.

Is the any way to convert an equation in Excel to something Access will
understand other than manually rewriting the code?
Basic equation has several *MOD(A,B) and several IF(AND(C,D)...
simply changing MOD(A,B) to (A MOB B) and changing