I have a join problem I can't figure out.  I have two back-end databases
joined on their control numbers through a front-end query (db2 on the left,
db1 on the right).  No other relationships exist between these tables.  The
control number for db1 is a primary key; the control ...

I would like to set a 'default value' in a table that updates feild with the
'current year only'!
Thanks

I have set my database to Compact On Close.  It compacts and closes ok BUT it
then creates an all new database.  You cannot open the database and it is a
massively smaller database but it is still like 62 MB (the original is 2 GB).
Has anyone else had this problem and does ...

Hi all.  I have several tables in my database and some are linked.  I want
to modify Table1, field4 to have a lookup to another table I created
(Table2).  However, the Table1will not let me make any changes to any of the
fields saying that you cannot modify a linked table.

I am designing a wages/salary access database and I need to be able to round
their salaries/wages to the nearest 1000 - up or down. Does someone know how
to do this
Thanks

Im trying to assign auto date(current date) to the date field.However
everytime I do this, there is an error, saying im trying to assign a null
value to the variable that is not a variant data type.Im using: =date(). Is
there a way I can change the date variable to a variant ...

I've recently installed Office 2003, and added Access 2003, and they run
fine, but, when I try to open an Access database I created in Office 97, I
get a message telling me I need to join certain Workgroups/User Groups. As I
created the database on my home PC, I am the ...

I need to develop a database application for a client that uses 2002 and I
have 2003.  It is a simple application that will have a user front-end and
data file back-end.  What kinds of issues are there for the client with
running a previous version of Access?  If I design the app ...

I have a person table and a business table that I (think I) would like to
keep separate. But I want to able to create an invoice (or similar) that has
a customer field that can point to either a person or a business.
This is just one example of this problem, so I'm looking for a ...

I have many addresses in Microsoft Outlook which I want printed  on Avery
5160 labels. How do I do this?

An employee we fired put his name all over the reports he did in Access.  All
reports open with a cover page with his name there.  How do I remove his name
and title from all these reports in Access?

I have a report that calculates the difference (in no. of days) between two
dates, but need to figure out a way to exclude weekend dates if they occur
between those dates, without having to sift through hundreds of records and
make the changes manually.

Hi all - Access 2002 XP - W2K
I am a regular responder on a few newsgroups and forums, and needless to say
my resource and reference files are getting quite large, and take some time
to sort through.  I would like to develop an Access database for easier

I am posting this in both Database Design and Forms Coding
I have been asked to create a database application that is
turning out to be way beyond my knowledge and experience!  
I'm not sure if the problem(s) are with the data structure

In the event of a corrupt database(like now), how do you recover the records
from the several tables within that database and transfer those records to a
new database with the same structure?
thanks