Currently, each option is a separate field in my table, and the users can
select yes or no for each individual option. To save space on my form, I'd
rather have a drop down box with all the options and have the user CTRL+click
to select multiple options. Is this possible?

I've been asked to look at speeding up a monthly data import procedure which
imports data from a linked text file into an Access database (it's done by
an append query). The database just has the one table in it (which is
cleared and compacted before each import procedure). There ...

I have a lot of queries, forms, and reports that involve multiple tables or
sub-queries, -reports, -forms, etc.  The Object Dependencies function is
useful to a point, but is there some way to get Access 2003 to print out a
list of objects with their dependencies?  My boss wants ...

I have been struggling with this for sometimes. I have main table (tblPerson)
and Event table (tblEvents) where I want to store events, FY and check box to
"Invite"
tblPerson (personID, Name)

I'm trying to construct a track meet database.  I have 5 tables:  tblMeet
(fields are MeetID, MeetDate, Event); tblEventDetail (fields are
EventDetailID, fkParticipant, fkMeetID, Minutes, Seconds, Feet, Inches);
tblEventLookup (fields are Event, Type, Type2); tblParticipants ...

Here's a new twist to the problem I've been working on.  I have about 50
tables with contact information.  These tables will be used to send out
faxes.  There are duplicated contacts throughout the tables.  I do not want
to send a fax to the same number more than once and when ...

Why Database an option in one database on the same PC and not there in
an-other..
When I type "Dim As DA" on one PC it lists 4 or 5 options, DATABASE, and
DATABASES are 2 of them.

I can't seem to get a date format with leading zeros such as 06/01/06.
Instead, it gives me 6/01/06.  How do I design my table to provide me with a
leading zero format?

Hi my name is Omar, im from puerto rico, im student, and i need to know how
to create a contacts database for a project. the database should be in this
format :
1.client

I have a field in my Zip Code table called Current_Vendor_Count.  This value
is a calculation - it is calculated on a form.  Is there a way I can store
the calculation at the table level?  Am I wrong to want to even do this?  Are
values that are calculated on the fly in a form, ...

i'm looking for a way to create the equivalent of a SQL trigger in MS
Access 2003. is there such a thing.

First, my apologies to this lengthy email, as it seems these news groups are
more focused on short-term problems and perhaps my email is inappropriate for
this newsgroup, but I’m going to try anyway ;)  I think what I’m mainly
looking for is either validation I’m on the right ...

I am new to Access. I entered product information to the "Products Table" how
do I link the information to the "Inventory Transaction Table"?

I have designed a database that imports data from an external data source and
also accepts user inputted data. Sometimes records from both the data sources
may have to be modified. I have to create several multi-table queries to get
the data normalized and to be able to produce a ...

Is it possible to do a drop-down within  a table?