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

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 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...

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...