I have two subreports based on queries that work fine when
independent of the main report but do not show any data as
subreports. I'm trying to get these two subreports to show
data in the main report during print preview.

My business has many deposits and withdrawls to post each
month.  Should I use one transaction table, or should I
use a deposit table and a withdrawl table with a jumper
table connecting the two?

How do I design a couple of fields in my tables for
recording the date and time that a new record is added, by
what user, and also record the last time a record was
updated?

I have a database with one table with 25 fields that
stores information from auto titles. I now need it to keep
track of the employees who pass it on for a different job
duty. I have to create a way for users to enter who has

I had to temporarily rename a table and now I cannot re-establish my back end links. It keeps wanting to point to the renamed name
Please help me, I have to roll out this system tomorrow AM and its hoplessly screwed up now.

For some time I have been trying to find the music collection database template on the microsoft site.  Half way down the music templates page (see this link)
http://office.microsoft.com/assistance/preview.aspx?AssetID=HA010345931033&CTT=6
&Origin=EC010553071033
there is another ...

I really do not know if this belong here but the other groups did not seem
to fit either, so here goes.
I want to use acSysCmdInitMeter, acSysCmdUpdateMeter, and acSysCmdSetStatus.
The first two to get the meter (blue dots) and the setstatus to change the

Office XP
Windows XP
I asked this question several days ago, but since I know practically zilch
about Access, I did not understand the response (thanks again to Mr. John

Is there a bug in Access 2003? Created a Unique Index on col1,col2,col3. With Nulls = Yes. I want the index to recognize the null on col3 to prevent the insertion of two iditinical records with the col3 null. The Unique Index dose not recognize the index. I am populating these ...

I'm creating a database for a department I work in.. and
I'm running into a problem with lookup data types.
The way I have it set up is that there is a table for
WorkOrders, and it references a table called Manufacturers

When I try to format a text field to a color it does not
work. The command I use is [red] in the format field
properties box.  The data type is text.  When I save and
go into datasheet view, the text is still black.  I'm

Running an Access 2000 db with embeded CR/LF control codes
embedded within the textof a Memo field.
What's the most direct route to remove them , other than
manually, line-by-line?

I have an Excel spreadsheet that I would like to link to
ACCESS, but there is one field that the linked table
insists is a number format.  I need the field to be
defined as a text format... but ACCESS won't let me change

I have an assignment for a class where I am creating a Database an assignment. The problem is that for one of the fields I can't figure out how to format the field to do what I need it to do. This is the infomation I have about it
Primary key, the ID of the table, including the ...

I'm creating a database for work and am pretty new to
Access. I'm also not sure how to phrase my question, so
I'll give a little background on what I've done so far.
What I have so far are 3 tables.