Search results

  1. J

    Scan muli-page document in Access database

    A Sharman, Thank you for the test database. I am finally back on this project. I receive a compatibility warning between Access 2010 and 2007 when I open your test database. Would it be possible for you to save a copy compatible with Access 2007? When I try to create a new Access 2007 database...
  2. J

    IIF Statement with many Values

    Paul, On another subject. Are you similar with scanning to an access 2007 form? I have a business group looking for the ability to scan invoices, docs, ext. or attached PDF files to a form. They would like to see the scanned image on the form so they can approve it electronically. I have the...
  3. J

    IIF Statement with many Values

    good point. Thank you,
  4. J

    IIF Statement with many Values

    Just tried =IIf([HRID]>"" And [SCat Text] In ("BRR_Restructuring","Building_Common","Floor_Common","Vacant_Available"),"Check Occup") which seems to be working.Thank you,
  5. J

    IIF Statement with many Values

    I am trying to create an IFF statement in a query that if the field HRID is populated and the space category field equals the wrong space type than my results should be "Check Occup". I have tried several combinations but I still cannot get this to work. Any ideas? =IIf([HRID]>"" And [SCat...
  6. J

    Validate field data

    :banghead:I have a form that contains two text fields i.e.; [Scat_text] and [STyp], which each can be changed by the users. I would like to combine the results of the two fields together and validate if the results exists in a query. What would be the best way to accomplish this?
  7. J

    Scan document; hyperlink to record

    Dave, I have business group in my company who is looking for a simple process to log invoices they receive into an Access form, and have the ability to scan these documents to be saved as PDF files and place in a shared network folder rather, than actually storing them in the database. Which...
  8. J

    Scan muli-page document in Access database

    Ashok, Thank for the quick response. A sample database would be great. I greatly appreciate all your assistance.
  9. J

    Scan muli-page document in Access database

    I have business group who wants the ability to scan documents into an Access database form I administer for them. They want the scanned documents to be saved in PDF file format and place in a shared network folder rather than actually storing them in the database. Currently this business unit is...
Back
Top Bottom