Search results

  1. D

    Export to word and multiple word document

    Thanks for your response, however as per our requirement I can not close the active document all the export to word which has been generated as per search criteria should open, for example if there are 10 matching candidates 10 word documents (resumes ) should be open at the end of the operations.
  2. D

    Export to word and multiple word document

    Hello I have been developing a resume builder database and based on criteria resume is being exported to word, exporting vba code as below what I see problem is that when there are two matching records found means two candidate resume should be exported to word, but when first export is...
  3. D

    insert paragraph within table and vba

    Hello I would like to add N number of paragraphs in table cell in word doc using VBA ( NOT after table ), can anybody please help me with snippet of code for this ?? Thanks
  4. D

    Error no 13, type mistmatch

    Can anyone answer me at this thread ? please https://www.access-programmers.co.uk/forums/showthread.php?p=1535783#post1535783
  5. D

    Error no 13, type mistmatch

    can you please help me what should be alternative here like in cell I want to assign Certi1 certi2 certi3 ... and so on...
  6. D

    Error no 13, type mistmatch

    Hello I am assigning an array to word document table cell using vba code. below is the code Dim getEducation() As String p = 0 While Not rsGetEducInfo.EOF p = p + 1 ReDim Preserve getEducation(p - 1)...
  7. D

    Search

    Thanks, I did as per your say. My questions, Can I build a view wherein in one line I can see all the information related to one person/candidate in one row ? Or since it is one to many it will have different row ? for each certification and each education record ?
  8. D

    Search

    Here is the attached relationship diagram. What I want is when user is presented list of choices to be selected from education, certifications & Positions. I want to get Candidate Name and their all the information like Eudcations, Ceritification & Positions. We would give the choice select...
  9. D

    Search

    hahahahah :) lol Sorry Uncle Gizmo for my bed English. What I want to convey is that I have one to many relationship between Candidate and Certification/Educations/Positions Now in Search there would be three list box namely Education, Certis & Positions which would be filled up using...
  10. D

    Search

    Hello I have one developed one database wherein I have done one to many relationship, please see attached screenshot for the same. In this database user can enter N number of certifications for given candidates. Now I would like to have search functionality wherein user can select...
  11. D

    One to many relationship

    No it is not working, I mean it is not populating related records in it, could you please create sample database and send it to me ? Just for two tab table one for resume ID and name and one for Education.
  12. D

    One to many relationship

    Thanks Missingling, but frmRecordDisplayer is secondory form and that needs to be fixed, can you please help me creating a seperate database wherein One resume ID & Name can have multiple educations records, I want to see what I am missing here, thanks for your help.
  13. D

    One to many relationship

    How does this happens, resume ID and qry_certifications would populate automatically.?
  14. D

    One to many relationship

    Hello I am creating a resume builder database, below is attached work I have done till date What I want is given resume ID (one) and name I want to add educations(many) and certifications(many) to be entered in tab table. When I create a new record for resume and add educations and...
  15. D

    Resume Builder database questions

    Hello, here is the attached database, Open the db use shift key, open form main menu create new record, what i want is I want is I will enter all the details for Name and ID in first tab and educations/certification and so on in rest of tab. Once I enter all educations and certifications...
  16. D

    Resume Builder database questions

    Hello I tried that way but it is not working, sorry for late reply as I was on vacation. My concern is one resume ID can have many education, certifications, positions. Would you please help me on this ?
  17. D

    Resume Builder database questions

    Hello there I am developing a resume builder database wherein HR would enter data for employee into the form and then they can generate a resumes in the PDFs or word documents. Attached is the relationship diagram and one resume ID can have N number of Educations/Experiences/Current...
  18. D

    Resume builder database

    Hello I am gonna develop a resume builder database, anyone has any sample database for this ? Thanks
  19. D

    Text field and IN clause

    It is just one query: which comprises of country table Country table has following field country id country name country name is text field in table and data is being entered from FORM and that is free text field and user enters the data with line feed/enter. like below UK Canada Australia...
  20. D

    Text field and IN clause

    Hello I have text field in table which stores value like this. UK United States Japan Now I have sql query which is like this; SELECT * FROM qry_maindata WHERE [Country] in ('UK','United States') It returns only UK rows for example if it is first entry in record, some table row which has...
Back
Top Bottom