Re: .doc formatted text in Access

Are these people entering the Resume information in on their own? If so you
could just allow them to submit a Word file as their resume and just store a
link to it in the database. Then when their information is recalled you just
supply a link to their resume file. If they are on a Microsoft machine the
document will appear in their IE browser, but if they are in another browser or
OS it will allow them to download it and view it. This is what I would do for
ease if the people submit their own resume information.

Also, if they submit the information seperately in a database you could just
format the information into seperate fields, such as "work history",
"interests", "goals", etc... and even let them name some of them. Once you
seperate out the data then you could just format it in HTML to appear as a
resume should if you are not actually worried about people being able to
download the information.

Just a few suggestions to get you thinking,

Daniel

Are these people entering the Resume information in on their own?

Yes, what I am looking at is having the person's resume on the website. It
would be easier, on the person submitting their resume, to be able to cut and
paste most of the information into a field themself. I have already got fieds
such as Work History, Education, Salary, etc. However, like most people's
resumes there needs to be more information on it such as the sample resume I
have included below.

Objective: To gain employment as?(specific job title)
or
To use my skills and experience to benefit your organizations needs.

Profile:

This should be a brief summary of your qualifications focusing on your area of
expertise, amount of experience, industries worked in and educational
background. A profile should be brief (3-5 lines) and summarize yourself as a
candidate.

Skills: This should be a point form listing of the skills you possess which
are
sought after by employers in your industry. Please see below for examples of
marketable skills

? Installation(of what) Design(of what) Drafting(of
what; software?)
? Document Control Management Cost analysis
? Checking(specify) Supervision Project Management
? Client Liason Tech Support Process engineering
? Tooling Finite Analysis 3D Modelling (software?)
? Materials Management Scheduling QA/QC
? report writing Estimation Machining
? Purchasing Planning Calibration
? Testing Programming(specify) Commissioning



Employment history: (Current listing of your work history in reverse
chronological order)


Dates (from to) Name of Company

Position Title

Job Description:

? Focus on what you did there as opposed to what the company did (sell your
skills not the company)
? What were your specific duties
? What special projects did you work on and what was your role in them
? What software were you using and what specifically did you do with it.
Ex: drafting using Autocad, Microstation; designing using Rebis, PDS,
Solidworks ProEngineer, programming using C/C++, Java etc?, writing reports in
word,
using excel, access to make tables, databases.
? What products was the company producing-how did you contribute

Keep in mind that a job description is very important. It allows a recruiter
to see how much experience you have in your field and eliminates questions in
the recruiters? mind as to what you are capable of. It also validates your
skills section.



Software Knowledge/Training:

List your software knowledge
What special training do you process which would make you an attractive
candidate to potential employers


Education:

Dates attended(from to) Name of school Degree(major)

List any major projects, relevant courses you were involved with/taken.

Step back a bit here for us.

Are you attempting to build a site where people can submit their resume for
others to search and view the information on it?

Here's what I'd do:

Make a form with a standard set of fields (education, work experience, name,
address, etc.)

Add a few custom fields for the end-user to modify.

Include an option to upload a file (PDF, DOC, whatever). Store the link to
this doc in another field.

Now, people can search via the database for specific fields, and then have a
nice HTML page returned to them, or the option to download the file that was
included.

-Darrel

Are you attempting to build a site where people can submit their resume for

Yes.

Make a form with a standard set of fields (education, work experience, name,

Have those basic fields done already for the search purpose to find the
resumes eaier

Include an option to upload a file (PDF, DOC, whatever)

Don't want to do this option as it does not look professional as well as has a
potenial for macro viruses.

there is just too many fields that the end user would have to put their info
into that most people would not want to bother. A sample of the way i want to
have the info formatted is like the following:

"Mail resume to: ATS Technical Group
Suite 730, 10655 Southport Road, SW
Calgary, Alberta
T2W 4Y1
Email resume to: emailname (AT) atsrecruitment (DOT) com
Or fax resume to: (403) 111-1111

All applicants may not be interviewed. Only applicants selected for interviews
will be contacted."

But it comes out like the following:

"Mail resume to: ATS Technical Group Suite 730, 10655 Southport Road, SW
Calgary, Alberta T2W 4Y1 Email resume to: emailname (AT) atsrecruitment (DOT) com Or fax
resume to: (403) 111-1111 All applicants may not be interviewed. Only
applicants selected for interviews will be contacted."

Don't want to do this option as it does not look professional as well as
has a
potenial for macro viruses.

I'm confused as to why you want a 'word formatted' file then. Either you
want a word doc or not, right?

I guess I'm not quite sure what the actual issue is you are trying to
resolve.

But it comes out like the following:

"Mail resume to: ATS Technical Group Suite 730, 10655 Southport Road, SW
Calgary, Alberta T2W 4Y1 Email resume to: emailname (AT) atsrecruitment (DOT) com Or
fax
resume to: (403) 111-1111 All applicants may not be interviewed. Only
applicants selected for interviews will be contacted."

Oh! I gotcha. You just want to format data from the database, right?

Well, then you need to store HTML in the dabase. The easiest way to do this
would be to use a WYSIWYG editor to replace the TEXTAREA box where people
enter the content into the database.

-Darrel