[rlh61233]

OBP:

Thanks for your RAPID response. Since I am a beginner in Access 2000 I will follow your instructions slowly and report the results. Peace be with you.

RLH

[rlh61233]

OBP:

Unfortunately I do not understand the nuances between databases “cemetery” and “cemetery v0.1” in the example you submitted wherein the latter will enable photo sharing. Perhaps it is easier to describe our desires to you for your recommendations.

Our homeowners association need is: (1) store each individual home improvement request (complete with all ancillary data; i.e., date, description, approval, etc.), (2) scan a maximum of four .jpg documents (written and/or visual) submitted with each request, (3) query the database on any desired address for all the requests submitted for that residence---then report the attendant tabulated data and the corresponding visual entries for each request. By assigning an unique number for each improvement description, one could also query on specific improvements.

Lakewind Final (Lakewind ACC.7z) is the basic design thus far created. I allowed for four attachments to accompany each request improvement entry. The four attachments associated with the 1 December 2003 4301 RR data entries were arbitrarily numbered 10023-10026. I scanned the four actual documents that accompanied that particular request (only 10024.7z included), renamed them 10023-10026.jpg, and stored them in a separate (not database) file folder. The goal is to query any residence for all the data and documents (jpg) associated with each improvement request for that address.

Attached are the above zips using 7zFM (I trust these can be opened with any zip software). I would appreciate any suggestions, improvements, changes, etc. to achieve the desired results. I appreciate your kindness in pulling me through this dilemma.

Peace be with you and yours.

Bob Heinrichs
Austin, TX

[OBP]

Bob, here is the modified version of your database.
I have made the following changes/additions.
Created a new Table/Query/Form for property and owner, which should only appear once in the table.
Used your Form as a Subform.
Added the Image Field to that Form with an option Group to select which one you want to display.
Added the VBA to the form to disply the chosen Image.
Created a new table to hold the Path to your jpg files, which is used to display them in the Form.
Created a Search Query/Form and a Search results Form.
Added my standard Splash Screen and Main Menu.
Created a "1 to Many" Relationship between the new Properties Table and your original Table.

The Search form works by selecting or entering data in the form and then clicking the Run Search Button, which opens the Search Results Form which displays any records meeting your criteria.
On the right of each record is a "view Record" button, which when clicked opens the Properties form to display the complete record.
The Search Query use "Wild Card" searching for Description, Material and Remarks. This means that you can enter a part of a word, a single word or a phrase and any feild conatining the entry will be displayed.
You have to be careful with these as leaving the Search form Field blank will show all records, hence the tilde "~" in them.
Let me know if you want more Search features an ddo not know how to do it.
Things that come to mind are Monthly or Annual Summaries, searching by Open date etc.
You could improve the database by adding tables for management entity and Materials.

[rlh61233]

Originally Posted by OBP

Bob, here is the modified version of your database.
I have made the following changes/additions.
Created a new Table/Query/Form for property and owner, which should only appear once in the table.
Used your Form as a Subform.
Added the Image Field to that Form with an option Group to select which one you want to display.
Added the VBA to the form to disply the chosen Image.
Created a new table to hold the Path to your jpg files, which is used to display them in the Form.
Created a Search Query/Form and a Search results Form.
Added my standard Splash Screen and Main Menu.
Created a "1 to Many" Relationship between the new Properties Table and your original Table.

The Search form works by selecting or entering data in the form and then clicking the Run Search Button, which opens the Search Results Form which displays any records meeting your criteria.
On the right of each record is a "view Record" button, which when clicked opens the Properties form to display the complete record.
The Search Query use "Wild Card" searching for Description, Material and Remarks. This means that you can enter a part of a word, a single word or a phrase and any feild conatining the entry will be displayed.
You have to be careful with these as leaving the Search form Field blank will show all records, hence the tilde "~" in them.
Let me know if you want more Search features an ddo not know how to do it.
Things that come to mind are Monthly or Annual Summaries, searching by Open date etc.
You could improve the database by adding tables for management entity and Materials.

[rlh61233]

Dear Distinguished OBP:
You are unbelievably amazing!!! One look at the VBA codes you included in the total program blew me away. Moreover, the final product does much more than I requested or expected. It will take me some time to digest its capabilities plus all the ingredients that went into the final "pie". In the meantime I want to thank you for all the energy and effort that you expended on my (and the homeowner association's) behalf. You truly are a very generous person.
Kind regards,
Bob H

[rlh61233]

Dear Access Guru OBP:

Words cannot express my and the HOA’s appreciation for your program package for our “Lakewind ACC Database”. Ultimately this database will be updated periodically with additional improvements as they occur, some different homeowners, and possibly field revisions. After a full day’s research of Access / VBA and tinkering with your work ostensibly to fit our needs, my progress has been ZERO. Could you please advise me what changes I should effect to create the following:
1. “Lakewind Final” renamed “Lakewind ACC” Database
A. Delete “Materials” field; add “Property ID” and “Owner” fields (see #2 below)
B. Reduce size of “Description #1 and #2 fields to two integers each
2. “Properties” Database Table
A. With some different owners at same address, is this db is needed?
3. Combine “Property Details” and the “Search” forms into one form titled “Search Details” that outputs ALL appropriate db fields
A. Two search criteria: “Property ID” or “Description 1 or 2”
B. Remove “Materials” field. How do field additions or deletions from the basic db affect this or other forms?
C. The “Show” feature creates a small, hard to read image picture---how to enlarge? Link to separate db to get larger image?
4. “Main Menu” s/b titled “Lakewind ACC Data” (ACC = Architectural Control Committee).
A. Additional input(s) to enable periodic updating of the “Lakewind ACC” database and/or an image db (if the latter) is needed
B. Combine “Property Information” and “Searches” input; or create a separate “Property Search” and a separate “Improvements Search”
C. If Images were stored in an image db and linked to the Lakewind db the path would obviously change
5. What is the importance of the “Improvements ID” field?

Thank you again for your continued work on our HOA project.

Kind regards,
Bob Heinrichs
Austin, TX

[MattyR]

Hi
I am also trying to insert images into my database - to be used for student records.

I have used this VBA code which displays an image on each form;
Displaying Images in a Microsoft Access Form

1. Use the AutoForm: Columnar Wizard to create a new form that is based on the ImageTable table.
2. Open the Imageform form in Design view and then add an image control to the form by using the Image tool in the toolbox. You are prompted to select an image to insert. Select any image available on your computer. Name the control ImageFrame.
3. Set the OnCurrent property of the Imageform form to the following event procedure: Private Sub Form_Current() On Error Resume Next Me![ImageFrame].Picture = Me![ImagePath]End Sub
4. Set the AfterUpdate property of the ImagePath text box to the following event procedure: Private Sub ImagePath_AfterUpdate() On Error Resume Next Me![ImageFrame].Picture = Me![ImagePath]End Sub
5. Open the Imageform form in Form view. Notice that the form displays the corresponding bitmap for each record.

However, it only updates when a different form page is selected. Therefore, when I try and print, I get the same image on each page.

Can you advise how to deal with this?

Many thanks,
M

[OBP]

MattyR, when you want the data to be "Printed" you should use a Report to do so and not a Form.
In the Report the VBA code goes in to the Report's "Detail" "On Format" event procedure.

[MattyR]

Thanks. I feared that this would be the only solution - I was hoping to avoid having reports and forms as it will cause some initial confusion for the teachers that would be using the information.

[OBP]

Provide them with a "Print" button and they will be non the wiser.