Need "Browse for File" button

1. What is the name of your Primary/Main Table, the Table for which the Attachment Table, will be a Child to?
   
   Expand|Select|Wrap|Line Numbers

   1. ([Primary Table].[Primary Key]{1} ==> [Child Table].[Foreign Key[{MANY})
2. What is the Primary Key Field of the Main Table?
3. What is the Data Type of the Primary Key Field?
4. List the Fields and their Data types in thia Main Table.
5. Does your Main Form have the Main Table as its Record Source?
6. What is the name of your Main Form?
7. For now, create the Child Table and Name it tblAttachments. It should consist of the following Fields:
   1. [AttachID] - (AutoNumber) - {Primary Key}
   2. [ID] - (Data Type to be determined since it depends on the Data Type of the Primary Key Field in the Main Table. This will be the Foreign Key Field relating back to the Primary Key Field in the Main Table).
   3. [File] - (HyperLink) - [enables Link to selected File(s)].

SurveyWorkOrderID – Long Integer
DateCreated – Date/Time Priority – Text
QAQC – Yes/No
OfficeComplete – Yes/No
FieldComplete – Yes/No
NotifiedOwner – Yes/No
RequestedBy – Text
ProjectID – Text
Phases – Text
ProjectEngineer – Text
ProjectSurveyor – Text
CADTech – Text
SurveyPurpose – Text
ProjectLimits – Text
Description – Memo
KOMeetingDate – Date/Time
KOMeetingTime – Text
KOMeetingLoc – Text
DatumHorizontal – Long Integer
DatumVertical – Long Integer
Alignments – Yes/No
ControlNetwork – Yes/No
RealPropertyResearch – Yes/No
ExistingRW – Yes/No
SurveyOfRecordResearch – Yes/No
ExistingMonumentation/Boundary – Yes/No
TitleRecieved – Yes/No
Control_Other – Text
Suplemental – Yes/No
AppraisalStaking – Yes/No
PropertyMonumentation – Yes/No
DTM – Yes/No
WetlandLocations – Yes/No
UtilityCoordination – Yes/No
BoringLocations – Yes/No
CrossSections – Yes/No
SlopeStaking – Yes/No
CollectSystemMaps – Yes/No
AsBuilts – Yes/No
ExistingMonumentation – Yes/No
Design_Other – Text
StakeabilityCheck – Text
ErosionControlStaking – Yes/No
BlueTops – Yes/No
GradeStaking – Yes/No
RedTops – Yes/No
SanitarySewerStaking – Yes/No
StormSewerStaking – Yes/No
WaterMainStaking – Yes/No
CurbGutter – Yes/No
ConstStaking_Other – Text

1. You must Save a Record to the Parent Table (tbl_SurveyWorkOrder) before you can Save any Attachments to the Child Table (tblImages). This applies to New Records, naturally. The code partially looks for this by checking the NewRecord Property of the Parent Form (frmCreateSurveyWorkOrder), if it is true the code will then attempt to Save the Record before adding any Attachments.
2. It is up to you to see that all Required Fields are filled in and all Validation Rules are met before adding any Attachments. This can be accomplished by either the use of Data Validation and/or Error Trapping.
3. Do not remove the simple Error Trap in the code, it is critical it that it prevents the populating of the Sub-Form in the event of an Error triggered by a Main Form Save.
4. Referential Integrity (RI) with Cascading Updates and Deletes is enforced between the Parent and Child Tables. Should you Delete a Record in the Main Form ALL Attachments for that Record will be deleted also.
5. Remember, this entire system relies heavily on Hyperlinks, so do not Delete, Rename, or Move these Files or else the walls come tumbling down when you tray to activate them.
6. The code has been thoroughly tested and actually works quite well, can you believe that?
7. Whew! That's All Folks! - any questions feel free to ask.
8. Good Luck and Good Night!

Microsoft Office Access cant find the form 'frm_CreateSurveyWorkOrder' referred to in a macro expression or Visual Basic code.

Application-defined or object-defined error

1. Where exactly is this Error occurring?
2. Try using an absolute reference:
   
   Expand|Select|Wrap|Line Numbers

   1. Forms!frm_CreateSurveyWorkOrder

1. I need to know:
   1. Exactly where, on frm_CreateSurveyWorkOrder, does this code get placed.
   2. The way it is now structured this code exists in limbo, and is not associated with any specific Object.