All -
Is there a way to show the number of records updated/added/deleted when a
query runs?  I know that if  you leave the system messages on, it will show
that, but by leaving the messages on, you get all of the crap you don't want

I have a tabel which shows how many days of holidays an employee is
entitled to.  It shows the date the amount was established as well as
the value itself.  This is to track changes throughout the employement
(ie) an increase in vacation time as the years of service increase.

Access 2003
User can choose options in a form to generate a report based on
specific criteria. Originally, user was required to choose one book
and one profile type and could choose one province if desired. I have

I have a query which I need to put into a form. I continue to get
#Name? in every control source. I am not sure what i am doing wrong.
My form is based off a table and a query. I have never had trouble
like this before. Not sure what I am doign wrong. Any suggestions?

I have a split FE/BE A97 mdb. The BE (278mb) is on a server, with 7 FEs
(115mb) on 7 PCs: the PCs are running W2K professional, with 512mbRAM on
each. This is all starting to creak a bit: we are increasingly frequently
getting database corruptions and "can't open any more tables  ...

I have a database which is shared between different users on a shared
network drive.  I wanted to make some modifications so I uploaded it onto my
computer (so it will run faster).  However, I am having a problem with one
table.  One of hte things I wanted to change was the main ...

I have 2 tables
1. Called TblProjects (key: ProjID autonumber). It contains ProjectName,
ProjectNumber, ProjectStartDate, ProjectEndDate, etc
2. TblProjectIssues (key: ProjIssueID autonumber). It contains ProjectNumber

I would like to insert a counter, for exemple in F_Main, to count how many
times the DB was loaded.
Is it possible in Acc2k7, please?
Thanks in advance.

I have to do monthly report form, due to the weakness of Report within Access
and the complexity of the monthly report form, the best way of achieving it
I’ve ever thought is:
1. To do some queries (for example one query for calculating one column in

I have a database for apartments.  One table lists all the amenities for the
units.  There are two fields from this table that I require for a report and
several rows for each property.
I know how to append two data fields( Amnt:=data1 &" "& data 2) but I'm

I am using the Access 2007 Developer Package Deployment feature to deploy a
package using runtime.  It seems to work, but two things are wrong.
1.  I am uing the package Deployment feature to add a registry key. I wand
to add "HKEY_CURRENT_USER\Software\Microsoft\Office\12 ...

Hello all!  Thanks for all that you do ahead of time.  Without getting too
far into detail I would need some direction as to how to keep some data.  
Please let me know if I need to get into details.  
I currently have a database with salesman information and from time to time

In my worksheet, there are "A" and "B" located at different cells.
After running my macro, these two data will be changed to other cells
randomly.
I would like to write another macro that find the location of cells of these

I currently have a table in SQL.  One of my fields is a MONEY data type
field.  Is there anyway to drop off anything after the decimal point and make
the values in there whole numbers?

I use an excel sheet to send data to an MS Access table. Basically, I fill
the form out and it sends the data from specific cells to an access database
when I click "submit". It has been working fine for almost a year. Now i get
an error that the database can not be located, and ...