How do I write a basic Statement of Purpose to School Application?

Hi there, I'm doing a Access database for a college asignment and i'm stuck
on problem with a booking form.
Is there a way of when a membership number is added into the booking tabel
that it checks the membership number exists in the membership table. If it

Is there a way to specify a particular worksheet when using the VBA
"Transferspreadsheet" command? I tried simply placing the worksheet name in
quotes in the Range parameter, but only got the first worksheet tab in each
instance.

I would like to link Access with Quickbooks and share information between the
2 programs to write reports. One of the first problems I need to solve is how
to put a field containing a customer ID into Quickbooks. With that common
data, I feel I should be able to link the programs ...

I would like to link a QIF file from Quicken but do not see this as an option
within Access' linking capabilities.  Is there away around this?   Can it be
done?

I am setting up an Access application to automatically read and parse .csv
files that are generated via script on a remote server.  
The catch is that the .csv file name changes everyday according to the date.
For example, the files look like:

I use the following to import data to Access:
DoCmd.TransferDatabase acImport, "ODBC Database", _
"ODBC;DSN=CamraTS;UID=Admin;PWD=;LANGUAGE=us_english;" _
& "DATABASE=CamraTS", acTable, "admin.security", "dboCamraSecurity"

I have a slight problem importing an Excel table into Access 2003.
The table has more than 100 records. If I try to import it into Access the
last row does not appear in Access. If I go to Excel file hide about 100 rows
then the last row is seen in Access. So every time I want to ...

I have several very old Access 1.1 databases to convert.  I only want the
data and queries, not the forms, reports or any Access Basic in there.  
ANyone know of a conversion utility other than Access 2, as the oldest
package I have is Access 97.

Is someone have experience with the use of short name vs long names
over a network?
Is it really easing the load on the network?
I am about to modify a lot of table links to use short name.

The Linked Table Manager does not display currently linked tables. I followed
the recommendation from the KB article 835519 and I get the error
"LoadLibrary("C:Program Files\MicrosoftOffice\Office2003\OFFICE\acwiz.dll")
failed - The specified module could not be found."

I created two mdbs.  One contains my BE data and will reside on a share
network drive.  The other contains the FE reports/forms, etc.  THe FE mdb
contains all table links to the BE database.  
My question is do I ever have to refresh the table links?  

Looking for a way to export tables from Access 97 directly
to Excel 2000/2003 format, instead of the default Excel 95
format.  Anyone know of a way to do this please post!
Thanks

I wish to import a list of invoices into excel and keep the order of invoices
intact.  Some invoices begin with letters and they are all of varying
lengths.  

I'm using Access 2003 SP1.
When I'm in the Tables object area I click on NEW and choose IMPORT TABLE.  
The  Import window opens, I change the Files of Type to Excel, navigate to
the folder holding the file I want to use, select the Excel file and click on