I am importing data from Excel to an Access table and some of the "timed"
data is longer than 24 hours. I need to be able to calculate, or run a query
based on what the longest time lapse was -- as well as other important
information about the event. If I format the Time field as ...

I am in the process of designing an access file to sort and analyze data from
a survey. There is one survey question that has multiple answers (respondent
can check up to 25 selections). I was going to just create a query that
searches within each record using wild cards, but the ...

Access 2002.  I have a table with a hyperlink field that I want to populate
with drawing image files related to the records (inventory parts).  Our
drawing numbers coincide with our part numbers.  So I wrote an update query
to trim and merge the part numbers with the network path ...

I have a temp table that is created from code to use for printing a report.
It works great except for a field used for middle inital.  If a middle
initial is not entered into the field a Zero Length error pops up.  How can
I make this fiel allow zero length from code?

How do I create a Data Dictionary report (table name and description + column
name and description) from either Access or Visio after the database has been
reverse engineered?

How can we apply the valdation rule to the new records only.
This means that the old ones should not be affected by this rule at all

Some authors always make the foreign key also a primary key;
while other authors make the foreign key a non-primary key.
Question?  what is the difference in effect (operation)?

Well, not really...but my front end doesn't show them anymore.
I had to add some security, which for me a databse password was enough.  I
ended up relinking all of the tables from the BE after I added the pwd to the
BE.  All the new links were named the same save for the "1" ...

Ive been a bit to ahead of myself, and i need to add some buttons to my form
- but, ive set up within start up to have all my menus dissapear (all i have
is file, format, window and help) - so i cant get them back........can anyone
help?

There must be a way to get a list of a database's tables into a text file.
Any list of the tables I see in Access can't be tagged and put into the
clipboard. I'd rather not have to type in all the names. So how?
Don <www.donwiss.com> (e-mail link at home page bottom).

I am trying to design a table that has the current database user defaulted
and validated in a "UserName" field.  But, when I put the "=CurrentUser()"
expression in the Default Value or Validation Rule I get an error when I save
the table that says "Unknown function ...

I am wondering if there is software out there somewhere that can be used to
run elections for associations board of directors?  Any suggestions?
ERIC

I am designing forms which will have a text box that users will change the
fill/back color to signify that topics status.
My question is: can I design the form so that after a color is selected it
will appear in the table as text?

Sorry this is first posted in Public.access before I saw that there is a
special tabledesign group
Who can help me...?
Jan

When should a field be indexed?  If a field is used in a relationship,
either as a primary or foreign key, an index is created as part of the
process.  If you need to search a table will the index created as part of a
relationship be used in the search or should a separate index be ...