Search results

Hope This Helps DoCmd.SendObject acReport, stDocName, "RichTextFormat(*.rtf)", EmailAddress, , , SubjectLine, _ "Please log this call and return details to sender." & vbCrLf & vbCrLf & "Internal Reference: ", True At the end of this line of code you have the word "True" If you look up the...

Sorry - - -just excited.

WORKS!!!!!!!!!!! OF COURSE!!!!! CAN'T THANK YOU ENOUGH. BEEN BANGING MY HEAD ON MY DESK FOR 2 DAYS CAME VERY CLOSE TO SCREAMIMG AT MY MONITOR AND THROWING IT OUT THE WINDOW! GAIL

Thanks in advance to anyone that can help. Background: I'm working with WorkOrders (Parent form), each of which can have several invoices (1st subform), each of those can have numerous parts (2nd subform shows all of the parts for the WorkOrder). All come from 3 tables: WorkOrders ->Invoices ->...

Invalid page fault in module MSJT3032.DLL I have a form that is opened to a specific record determined by a main menu selection list. This form has a subform that lists out all of the parts from the parts table that are associated with this particular record by ID number. The subform also needs...

I am now totally befuddled!!! I commented out all of the code that was giving me the problem, as I have told you, and continued working. Just for the heck of it, I just went and removed the apostrophies and tested the code one more time to track the path and pinpoint exactly where the message...

Thank You Again Yes I have stepped through the code. When I move the record from the Watch to the Contract I leave the Watch form open but not visible and open the Contract form. The close button on the Contract form checks if the Wach form is loaded, if so, makes it visible, then closes the...

Hello Anyone Again! I guess I'm full of problems this weekend. As always, thank you in advance to anyone who might have the time to help me out. First: the tables in question are described under the recent topic "Relationships" 10-13-02 with my name. That problem has been solved, but seems to...

Thank You Your understanding of the situation is correct. These records are "Published" as a report every month. Eventually I want to be able to request this report for any published date. Without a complete record of every field as of that date, I don't see how I would be able to do this. I...

Hello Anyone . . . Thank You in advance for any time you might spend helping me with this problem. Here it is: First set of tables: ContractTable KeyField = ContractID and 30 or so other fields. ContractHistoryTable Keyfield = ContractHistoryID...

Thanks Again Please don't loose patience with me. I certainly appreciate you taking the time to help me. However . . . The form and the report are working. I can have my users browse the network and link to a file. This OLE Linked file is stored in the database as is normal for Access. using...

Thanks ElsVanMiert The link you provided was very interesting and I'm strongly considering this 3rd party solution; however it does not answer the problem I'm having. The form and the report deal with both graphics and OLE files such as .doc, .xls., .ppt, etc. It's these OLE files that are...

My form is used to associate both images and files to a record. The subtable that contains this information only holds the record index as a foreign key (number), the image or file description (text), and path to the object (text). The form has both an image box and an unbound object frame...

How do I set the page setup paper size from code? I'm looking to set it to "Legal" at some point when the report opens or at "Report Header: OnFormat". Thank You in advance for any help.