Search results

Thanks RX & Brianwarnock! RX, I did have Excel checked in references. I was able to piece together what I needed with your references, and everything is working perfectly now!

I am brand new to the VBA world, and am using a macro I found on another website. I have been able to modify it so far to run, but it is erroring when it gets to the red text in the code. Any idea what is wrong with the code below? I basically want it to copy cells A2 through the end of the...

I did look at her post, but mine is a different issue. I am getting a Run-time error '440' The item with the specified name wasn't found. Which dosn't make much sense because it found and ran the Excel macro.

I have a VBA code written to call an Excel macro. The code runs, and it runs the Excel macro just fine, but for some reason in Access the code is erroring on the Excel macro even though it ran. Not sure what is happening. It is erroring on the red line of code. I did not write the Excel code...

I am trying to make a yes/no box in VBA. I have no idea what I am doing in VBA, so please provide a dumbed down explanation. So far I have this saved in a Module, but I can't get it to run. I get an error that says "Compile error: Wrong number of arguments or invalid property assignment." I have...

Thanks! Wish I could restructure the data, but it comes from a SharePoint list, so I'm just stuck with what I have, was hoping I could find some way to automate around manually adding the numbers together.

I know this is something that is probably pretty simple, but I am still new to Access and can't figure it out. I am trying to create a totals query that simply groups all the unit types into 2 categories (FL & TR) and gives me a total count for each type. However, the column that contains the...

Thank you so much Beetle! That was exactly what I needed and fixed my problem, now my email is sending!

Can you tell me how to add the Outlook Object Library reference to me DB? I am using Outlook and Access 2007. Please note that I am extremely new to Access and VBA so please explain in newbie terms :)

New to the forums, and pretty new to Access. I know absolutely nothing about VBA coding and am trying to learn more (any advice on a good class is appreciated).