Search results

MajP Thanks appreciate the explanation. I have changed my Tools options so that explicit gets added to all new modules. I have googled and looked for the proper method to add explicit to existing modules. Where is the correct place to add the code? I do not quite understand what is meant by each...

Hey george, Really appreciate your feedback on this issue. I am not fully understanding why this is not working. Here I have used the code that you have suggested, yet the outcome is the same. The field is specified in the report: And the control is named correctly: But the result is access...

I have a similar issue and I do not have the skill to figure out how to solve it. I believe I am just not accessing the actual record somehow. I want a image to become visible if a boolean field is true My code is: I have the "seal" in a footer section of a report (invoice) called OrderSelect...

So I decided to take the risk and uninstall Windows Live Mail. Everything is working through outlook now. Problem resolved. Apparently even after setting Outlook as the default app there was still something either in the registry or somewhere else. Thanks for the help people.

Yes, have rebooted multiple times. Uninstalling WLM may fix the issue by removing whatever entry in the registry is making it happen, but I also fear that upon uninstalling perhaps the code will generate no action and no mail program will open.

Default mail app is set to outlook in the reg. There are other entries for outlook and WLM under protocols and other entries but I am not certain about the effects.

Default apps > email> Outlook (was WLM before)

I was hoping to not uninstall WLM because I would like to keep my old emails around for a bit until I feel they will no longer be needed. I just do not understand why Outlook will not take over as the default mapi

I have been using sendobject code for many years to send invoice copies through my email client which until last Friday was Windows Live Mail. The issue I am having is that I now want Outlook to send my reports. I have changed the default email app, but WLM is still opening when I run that code...

thank you! Let me review all and see if I can get it working on my project.

hi thanks! 1- i will hard code the email address into a value list for the control. It only has 1 or 2 options and will not change often 2- no formatting, just a control as text, line space, next control as text. Just to let you know in case it helps. We are emailing a freight broker for a...

I would like the user to be able to send an email based on values he entered into a form. I do not need to store the values as they are not going to be needed later. Will I have to generate a report first? Ideally I would like to.. 1- have user complete the form 2-press "send email" 3-List the...

Its a one shot, one kill. Thanks Man. I did try removing one set of " before Company name but was getting syntax error, coouldnt figure out which other " needed to be removed. Thanks so much!

Hoping this thread is still valid as It seems my issue is comparable... I get a type mismatch on the following. Truth is I never came to understand all the double quotes and quotes. I am working from similar statements but apparently not similar enough... Me.[Salesperson] =...

Works:) thank you Sir! Much appreciate

I have changed Product Description to a textbox and changed the code on SKU event AfterUpdate to: Me.[Product Description] = DLookup("ProductDescription", "Products", "SKU = '" & Forms![Orders2].[Order Details Subform4].[SKU] & "'" Now gives me this error...

Is syntax proper on the... Me.[Product Description] = Is the fact that the Product Description control is a dropdown that selects from a query an issue?

I am still getting a "object doesnt support this property or Method" error

Good day. Having issues getting the syntax correct on this AfterUpdate event featured on one of my forms. The code I am trying : Private Sub SKU_AfterUpdate() Me.[Product Description] = DLookup("ProductDescription", "Products", "SKU = " & Forms![Orders2].[Order Details...

I have a simple query that lists order history, one record for each Order Detail. I want to group all the same customer orders with a '+' (that acts as a dropdown) so that it will shorten the list and make it easier to view. In the above example All those records would combine into one and...