Importing or Uploading file

S

Steve Voorhees

I work for a hospitality company. Regularly, our Quality Assurance
Department "shops" one of our various properties, records the call, and
grades them on several predefined "points".
I have created the database which is used to enter the information from the
call: Property, who "shopped" them, Date and Time, then the points required.
This is all working fine.
What I would like to do now is be able to let them "attach" their calls,
which are in a .wmf format on each of their individual hard drives. The
attached files can either be imported into a separate database or copied to a
subdirectory under the current "shop" database. The database is stored on a
network drive.
Any suggestions? Some type of example would be of assistance.
 
J

Jae Hood

Hi Steve,

If you don't need the .wmf files linked to a specific record in your db,
simply create subdirectory for each Rep, or "shopper", and have them name
their file using your record number.

I don't believe an AutoNumber reference would be appropriate here so you
would need to create a sequencing process that would number each of your
records based on the previous record number.
 
S

Steve Voorhees

I actually would like to have the file "linked" to the specific record in the
DB. That way, if they pulled up that particular record, then the call would
be there, and they wouldn't have to go searching for it.
 
Top