Search results

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...

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...

good point. Thank you,

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,

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...

: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?

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...

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

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...