I'm approaching the 2GB size limitation. Compacting the
database has no effect and the other workaround to split
the database is not an option (for us).
Does anybody has any other recommendations?

Wolud like to print queries and their join relations, without using the printscreen shortcut (eg. some queries don't fit in the "design view" window, without a pagedown ...)
Thanks

What would be the best way to handle a client listing
with contacts multiple and addresses

I have a database which is basically a list of consultants.  My boss would like to have a link in each person's record to their CV.  I have seen a database which does this but can't work out how to do it in mine.
I added a field in table design view and selected OLE object as the ...

I am look for a way to change en masse the format that is
assigned when you store a hyperlink. For individual
records you can right-click and edit a hyperlink (in this
case I want to change to an email address) and select

I created a db some time ago which allows users record incoming invoices and
Direct Debit payments. the Db works fine but now there is a requirement to
create a report which lists transactions between 2 specified reference
numbers.

A really simple one, I'm sure.  How can I set up a table in Access so that it capitalises the first letter of a word enters, so that a surname, say "smith", when entered becomes "Smith"

Where would you put the code and what code, to have
words "auto-complete when you type in the first and/or
second word?
i.e. g(reen), t(om) and so on.

I need to create a database to track the rental of motel rooms.  The user
would click on a date to reserve a certain room, and check customers in/out,
and keep track of payments.
I've created many databases before, but I'm at a loss how to begin one that

What expression will generate a Default value date for the
next day?

I have a form that needs two fields added onto it.For one field, i was thinking a drop down list using the lookup wizard with the following values--- the days of the week  Mon,Tues,Weds,Thurs,Friday.Another field with a drop down list using the lookup wizard for each day of the ...

Im putting together a database to track inventory and
sales of some records.  Im trying to group the records by
artist, and then individual record within the artist group.
The end result im shooting for is to be able to display,

Why does the record number keep advancing even when I
delete a record prior to the last record?  (i.e.,  jumps
from 28-29-30-33 when I delete the original 31 and 32)?

I need to create a validation rule with the following
parameters. It is a text field with numeric characters
and it is required to be 9 characters long. Here is what
I think it should look like, but it does not work.

Please forgive me for asking about a calculated field in a table. I know it
shouldn't be done but I'm getting leaned on to figure out how to do this.
The controlling field can have a number of values. If the value is one of
three items "A", "B", or "C", they want another field in ...