I'm trying to make a table tracking all of the files in a certain
folder in my computer, one record for each file.
I'd like one of the fields to be a hyperlink to the actual document.
Is there a way to copy or import all of the files in a folder from

I know this must have been answered before but I am new to Access 2000.
I have a incrementing AutoNumber field set up for an Invoice Numbering
System.
How or what formatting code would/could I use to accomplish this?

Today, I opened my database and discovered that all dates are 02/05/2/01
which should be 02/05/01.  I checked the date format without any errors.
Can someone advise me the possible errors.
Thanks,

I'd like a field for date stamp to indicate when a record
was first entered into a table.
Thank you in advance,
Ellen

I am trying to create  database for the first time, and
one of the things I need it to do is to hide or geayout
some of the fields dependant on a tick being places in
anouther field.

I want to use data from other tables to form a new table
dynamically.  Data exists in other tables, but it's not
organized the way I need it to generate a chart.  I would
like to create a new table that is always current and is

thanks to jessestoneceder for your previous help
i'm trying to combine multiple update queries (1 for each
field in a table) to a single update query.
the SQL for my update queries is:

Is it possible to have one Table, (let's call it A,) related to two
tables, (B and C,) both of which have would have a one-to-many
relationship. "A" being the one and "B" and "C" being the many. If so
is there anyting I need to watch for? I have never had a need for this

Why is it that the text box field is limited to 255 characters?
In filemaker Pro 7 the text box limit is 2 Gigabytes
Am I missing something ?

I have designed a new address system for an application but for the moment
this is separate from the existing system.
Now I want to replace the 'CustID' primary keys thought the old system with
the 'PeopleID' of the new system so as to retain several years' records.

Can I make other fields autofill information from another table upon entering information in one field on the form?
Example: One table holds property information address, seller, phone numbers, etc. A form created to log showings for this property has a drop down for address and ...

We have an access database on our server. We recently installed a new server. The links in the split database from the front end to the back end all reference the old server. How do i change the link? In design view I can right click (in the front end table) to view the ...

I know one can enter data directly into the tables themselves, but...logically after creating the table, setting up relationships, to enter the initial test data --- should one build queries, or go right into creating a form?  What is the logical progression?

Hey Group,
I have a table with the following Feilds:
MobilePhoneID, PrimaryUser, DepartmentID, CallOptions, MobileNumber, SDC,
GPRSTarrif (Lookup to Another Table), INumber, & ContractStartDate.

hey group,
Hope Somebody could possibly help?
I have a Table:
FaxID(Primary Key), Serial, Make, Model, Department(Lookup Table),