Programming

Repost - checking Forefront updates
Using VBA does anyone know how to retrieve the latest Forefront updates date? -- Steve ... 10 Mar 2010 16:28

not like syntax in querry not working
Hello all- I am pulling data from an access dbase and have ran into a syntax issue. Does anyone what is wrong with the last line? The data pulls, but ignore the not like statements and i get all the items with gfm and cfm in the material name along with the data im looking for. I need to exclude all records ... 10 Mar 2010 11:58

How to print with a gap in the middle of a sheet
I am trying to setup a print button with code to print a range of data on a 11x17" sheet of paper, portrait layout but to have a break in the middle of the sheet always so if you fold it in half you will not be folding over text. I need something like a footer in the middle of the page. I have 2 seperate parts of t... 15 Mar 2010 19:30

Conditional Formatting VBA Multiple Numeric Ranges
I have a worksheet with hundreds of rows of data in columns A through AV, and want to have the color of columns A through J ONLY change for each row based on a numeric value in column J. For example, if the value in column J <0, color = red, if between 1 and 30 = yellow, if between 31 and 45 = blue, if between... 10 Mar 2010 11:58

Modeless User Form Is Blank
I want a modeless user form to appear, then my program does some work (clearing the screens of all drawing objects, which takes a while), and then the user form to unload. I've gotten this to work, except that the user form is completely blank and white. The label control with my message doesn't show. I've tried... 10 Mar 2010 15:21

How do I add numbers in two column based on the date in another?
Hi Please help. Using Excel 2003, I am trying to find a way to determine if a date changes in a range, total amounts in two columns, by date, by route otherwise return a blank. A=Route# B=Date N=Total Hours(of a call) O=Time Between Calls P=Total of N+O A B N O ... 10 Mar 2010 10:50

Call Stack Available ?
When browsing the Locals Window, I happened upon the call stack display. I looked in Help but could not find a way to access it with VBA. It might be handy in error processing in knowing how you got somewhere. If it's available, how do you access it? Thanks. -- Neal Z ... 11 Mar 2010 13:28

MS Excel VBA Pivot table link cell fetch records
Sorry to get your hopes up but my reply is not for the problem you had but rather a query about whether you solved this as I want to do the same thing that you asked about. asxastro wrote: MS Excel VBA Pivot table link cell fetch records 08-Dec-09 I have a table 'tbl_Final' in MS Access 2007 where the dat... 10 Mar 2010 00:53

ShowDetail
When data is extracted using ShowDetail, the data is always extracted to a new sheet. Is there any way that this data can be extracted to a named range? ... 12 Mar 2010 00:42

LookUp Returning more than one rows
You can also use an array formula: {sum((A2:A5="john")*B2:B5)} or if you have more than one criteria, you want john and steves totals: {sum((A2:A5="john")+(A2:A5="steve")*B2:B5)} remember to hold ctr+shift when you hit the enter key for array formulas. "Sam Wilson" wrote: Hi, You can use =S... 9 Mar 2010 19:16