Search results for query: *

How do I run NewHireEmail.OutlookPump with the runcode macro action? NewHireEmail is the module name and OutlookPump() is the Sub's name. Do I need to create a new function to do this? if so, how? Thx! ___________________________ "I am what I am" - Popeye Travis M. Allen www.trav-ism.com

Still a great help thanks! ___________________________ "I am what I am" - Popeye Travis M. Allen www.trav-ism.com

Do I put this in a new function or directly in Function Name for runcode in my macro? ___________________________ "I am what I am" - Popeye Travis M. Allen www.trav-ism.com

There are 3 modules and all have a sub named "OutlookPump" but they do different things so I need to specify which one. I also read macros can't run subs and that I'd need to make a function that calls it. ___________________________ "I am what I am" - Popeye Travis M. Allen...

I have a module named "NewHireEmail" and a sub named "OutlookPump()". Can someone help me with the code for a function that runs this sub? I think I need to use something like... Call DoCmd.OpenModule(NewHireEmail, OutlookPump()) Not sure if the module and sub names need quotes though...

Hi all, I am creating a form that needs a 2 buttons:1 that runs 2 diferent Subs; each sub sends emails from query results, and 1 that runs 1 sub that also sends emails. (Note: I "inherited" this code and vaguely understand it as I'm not a VBA programmer, but I'm learning!). I think I have to...

Hello all, I've been trying to teach myself XML & XSLT and I've hit a spot that is beyond my knowledge. I'm trying to convert some XML output to MS Excel. I found the following XSLT, but don't understand how it works: <xsl:stylesheet version="1.0"...

Im trying to create a program that assigns a location after checking to see if it's used already, but I get this error compiling... Run Time error '3426': This action was Cancelled by an associated Object Here is the code, the bold part is where the compiler gets stuck...

I don't know, it just threw an error that it couldn't recognize the type for the variable 'rst'. I have Access 2000. ___________________________ &quot;I am what I am&quot; - Popeye Travis M. Allen www.trav-ism.com

I can't use DAO.Recordset with my Access and I need in a 'For/Next' Loop. This is the program: '------------------------------------------------- Dim Check Dim Counter Dim TempLoc Dim rst as DAO.Recordset Dim i as integer, NumRec as integer Set rst =...

I'm trying to write a program that creates locations using a counter for example: Counter = 0 TempLocation = Me.section&&quot;.&quot;&Counter but I want it to check if the location has already been created. I suspect there's a built in function to check for duplicates and returns a true or...

I have a spreadsheet with 3 columns, item, cost, and diminished value. I was wondering how I could create a condtional that shows the diminished value only when the filter isn't showing all(the filter would be on items). I've never in VB for Excel so detailed info would be great. Thanks. T...

If you'd like to try some different mouse over code... put this in the head: <script language=&quot;JavaScript&quot;> <!-- if (document.images) { image1on = new Image(); image1on.src = &quot;home2.gif&quot;; image2on = new Image(); image2on.src = &quot;bio2.gif&quot;; image3on =...

I think what you're saying is you want the link that leads to the page to the second image when they're on the page. I would just to that in html on the page - change that piece of javascript/link to just an image(or a link with only one image and no mouse over) of the &quot;highlighted&quot...

I have a table that keeps information about a client. There are 2 fields relating to the company they work for. One is the company name and the other is the type of company. They are jioned : [client].[companyID] to [company].[ID] and [company].[typeID] to [type].[ID] In a form for this...