Search results for query: *

Mybers! Thanks for the good tips. Right now I am working on developing Resume Database which includes Biographical Data, Education/Work Info, Location Preference, EEO Information, Resume History, and Interview information of the applicants. And have developed a search form for Names, Highest...

Mike, Yes our HR department gets documents in .RTF, Doc, .PDF, and inline text in e-mail messages. So they're all in different format. Hymn and Ken: Actually, that's how I have it set up right now - where I have a hyperlink to the actual Resume file. HR is debating on to purchase either the...

Thanks Mike and Ken for the quick response! I have about 500 Resumes and would like to import them in to the Access Database without doing data entry of each resume. I really don't know any VBA. Can you suggest any other way to accomplish this task?

Hi Everyone! Is there a way to extract data from a .Doc or .RTF file to the Access database?

Thanks Marcus! I just read about the Ominipage Pro product details. Its a great tool to turn PDF files into editable documents while retaining their layout. I will definitely put the request to the employer to purchase this software which really saves time and money when there are tons of...

Thanks Thomas and Marcus! I apologize for replying back so late. I got heavily involved in other projects. For now I am saving each PDF Image file as TIFF by using 'Save As' command. Then using 'Adobe Capture' software I convert those individual pages as one file to PDF Text file. Then use...

Hi Everyone: I have some scanned files saved as PDF format. I would like these files to be converted to the Ms Word RTF format. I will be using Adobe Capture 3.0 software to make the file modifiable . I tried to save the flie type as *.TIF format but once the file is saved in TIF format it...

Roy-Vidar: Got it! The ControlSource was unbound. Thanks a lot - !!!! :-)

Roy-Vidar, The ResumeNumber generated doesn't get stored/saved into the table. The number is only displayed in the forms. Any idea? Pleae help! Thanks in advance!

John, Thanks for the prompt reply. I am not quite sure how to write AfterUpdate code to insert the field data to the tblJobBank. Actually, tblJobDataBank would already have all the data but what I need is when the position number is entered for the Applicant I need that somehow linked to the...

Hi everyone: I am building a Resume Database in Access 2000. I have about 7 tables linked together. I have a one main table called tblApplicantBioData. This table is linked with tblApplicantEducationInfo, tblWorkExperience, tblLocationPreference, tblEEOInfo, tblResumeHistory, and tblJobBank...

vb5prgrmr: The problem is solved with the following: The default value for the ResumeNumber field is set to =resNum(). The resNum Function is as follows: Function resNum() If IsNull(Forms!frmApplicantData!fsubResumeSubRevInfo!ResumeSubmissionDate.Value) Then...

Roy-Vidar: Thanks for the quick reply. Yes its a subform where the ResumeNumber should be auto generated. I had once changed the subform name that's why it was not finding it. And yes I am using the code in the Module. Here's the corrected code and it works great: Function resNum()...

I am using the following code but I am getting run-time error 2450 - MS Access can't find the fsubResumeSubRevInfo form refered to in VB ... : Function resNum() If IsNull(Forms!fsubResumeSubRevInfo!ResumeSubmissionDate.Value) Then Forms!fsubResumeSubRevInfo!ResumeNumber.Value =...

vb5prgrmr: Thanks a lot for taking time and interest on solving this problem. I'll try your suggestions and will post on the VBA forum for further help. Thanks!

Hi Everyone: I am building a Resume Database in MS Access 2000. I need to have computer generate the autonumber/Sequence number based on when the Resume was received at the HR as (Year/Month/Sequence = 200401-001). So the number should be generated from ResumeSubmissionDate and 3 digit...

vb5prgrmg: I should have mentioned that I am buidling the DB in Access 2000. The code you have provided above set to be as a default value of the ResumeNumber field? ResumeSubmissionDate is Day/Month/Year and I just need YearMonth-sequence number. ResumeSubmissionDate is manually entered by...

vb5prgrmr: Thanks for the prompt reply. I am getting error message "Object Resuired" The following code is highlighted: SomeVariable = Rs.Fields("Cnt").Value + 1 How do I 'open recordset pessimistic locking? Actually, the ResumeSubmissionDate is manually entered by HR...

Hi Everyone: I have a Resume Database. I need to have computer generate the autonumber/Sequence number based on when the Resume was received at the HR as (Year/Month/Sequence = 200401-001). Can anyone help how should I do this? Thanks in advance!

The problem is solved with the following solutions: I have the following SQL statement on the row source of combo box (cboFullName): SELECT [tblApplicantBioData].[ApplicantID], [tblApplicantBioData].[ApplicantLastName] & ", " & [ApplicantFirstName] & " " &...