Search results for query: *

Hi Everyone, I have a few reports which have embedded images/pictures in them. When I Publish the report to Word, the pictures are not displayed. Can anyone explain how to resolve this issue? Thanks, Scott

Thanks to Robert Johnson for your patience and in depth explnation. I look forward to learning more and more!! Thanks to PHV!!!! AGAIN!!!!! I realized that I did not have the full document path at first, but was able to get your code to work!!!!! Robert I tried your coding and may have...

Robert, Thanks for the post. Pardon me, but I have merely sccratched the surface of Access and am an infant in programming. Can you explain the meaning of "shell" and where I would use: Shell('full path to access' 'C:\Documents and Settings\Scott Miller\My Documents\Maverick\Scott.doc')...

Hi Everybody. Can anyone help with how to Open a specific Word Document with a button on a form? Document path = C:\Documents and Settings\Scott Miller\My Documents\Maverick\Scott Thnaks, Scott

You are a GENIOUS PH!!!!!!!!!!!!!!!!!!!!! Everytime you have responded to a thread of mine you are a single and straight shot!! Excellent! Thank You, so much!!!!!! Scott

PH, Thanks for the input. It gave me an Expected end of statement error at the (..." _ )of & " WHERE B.CustomerQuoteID=" & Me![CustomerQuoteID]" _

Its on its way.......Thank you!!!!!

Ace Man. I wish there was an easier way to communicate with you and have you walk me through this. I understand the code you had written. [CustomerQuoteID] ALWAYS existed on the Sub Form, NOT the Main Form. This is why originally I had written the code to ONLY refer to [CustomerQuoteID] in...

Can Anybody Help?

Hey Darrylle/Aceman!. ACE MAN: No, there is NOT a matching [CustomerQuoteID] field in the Main Form. Originally, I had ONLY an unbound field [CustomerQuoteID] in the subform, which [roductID] was dependent on. The columns in [ProductID] showed, but it asked for "parameter value" Is there no...

No, there are 6 columns, as set in the above SELECT statement. NONE of them are showing. Scott

Hello Again Ace Man! Well, it eliminated the "Enter Paramater Value" BUT now [ProductID] is not displaying any data, wher before I had to enter the parameter and it yielded the correct data. Any idea why this would happen??

Hi All..... I have a small problem with a dependednt cbo box [ProductID] asking for parameter value, where the value SHOULD have been set in the [CustomerQuoteID] field. PROBLEM is that after I enter the value in [CustomerQuoteID] it asks to Enter Parameter Value...

Ace Man..... I think I will have to sleep this one off and start again tomorrow. I admit, and as you can probably alraedy tell, i am still naive with most of this. And I am a bit confused now because I don't presently have a criteria for [ProductID] in the subform Query, so I don't quite know...

Scratch that last statement..............I am tired. OK, I set the subform Record Source to the Query. What code do I use for the criteria in the subform? Scott

Ok you lost me there. Main form Record Source IS based off the query and What I have now for the subform= Source Object: popVendor Quotes by Product Subform Link Child Fields: ProductID Link Master Fields: ProductID I created this pop up with the form wizzard. Do I need to create the...

Ace Man... You would not believe how much and how little I have learned in the past 6 weeks. I have actually learned about the naming of objexts and using "_" for spaces and brackets and have toyed with the idea of going back through EVERYTHING and renaming. Oh Man! Would you suggest I do...

Yes, I did. Everything matches up. Query Name = qryVendor Quotes by Product Pop UP Form Name = popVendor Quotes by Product AND has a popVendor Quotes by Product Subform For Double Click Event for [ProductID]in Customer Quotes: rivate Sub ProductID_DblClick(Cancel As Integer) Dim frmName As...

Ace Man..... Followed all of the above. When I double click on [ProductID], the form opens, BUT there are no records. Any Ideas? Thanks!

Ace Man.....I'm doing good, buddy. I was very happy to see your post there. I am going to get cracking on it right now. I'll get back to you and let you know how it went. Thanks!!!!! Scott