Search results for query: *

We have some Excel workbooks using VBA that are in Office 2000 and work perfectly fine with Outlook 2002. Some of our user base has migrated to XP and some to Office 2003 . Now they are getting General Mail Failure errors, irregardless of whether Outlook is version 2002 or 2003. There are no...

We have a function in Excel to return a Mainframe String ="T"&TEXT(G1,"0000000")&TEXT(H1,"0000000")&TEXT(I1,"0000000")&TEXT(J1,"00000000")&RIGHT(DOLLAR(J1,2),2)&TEXT(J1,"00000000")&RIGHT(DOLLAR(J1,2),2) The problem we are having is that J1 is a numeric value and this string TEXT(J1,"00000000")...

We have a powerpoint presentation that is several pages. I need to know if I am going from say Page 1 to Page 2,how to invoke a hyperlink automatically when I open Page 2. How can I do that in Powerpoint? Thanks

I have the following module DoCmd.SetWarnings False DoCmd.Echo False, "" DoCmd.Hourglass True DoCmd.OpenForm "z_FFil2_frmCustom_800_600", acDesign, "", "", , acNormal DoCmd.OpenForm "z_FFil2_frmCustom_800_600", acNormal, "", "", , acNormal DoCmd.Maximize DoCmd.SetWarnings True I need to open...

Thanks a lot Skip!!!!

Based on Date() I need to get the first of the year 10 years ago to use as a criteria in my query So for example for today's Date() I need it to get back 1/1/1995. I was trying to think of how to use DateAdd or DateDiff with the Date function but wan't sure how Thanks

I have a function listed below which works great. I need to add a condition to this because we may be in position to send all these emails out t once rather than displaying them one at a time. I need a condition that tests to see if a file exists based on the path created. If the path does not...

I have a table in Access named Tbl_Persons. This table has 4 fields Code EMail_Address Person Path When I click a button I want the module to do the following. Send an E-Mail to each email address with an attachment based on the path and place in the subject the Field Person Value plus the...

We have an Excel File where all 4 columns are formatted as Text. i need to save it as a CSV File for and upload. When I save it as a CSV File, the leading zeros disappear. How can I save this file as a CSV File and preserve the leading zeros? Thanks

Thanks for the advice. We will try that

We have the below code that runs on the button click. In excel 2000 the code runs fine and opens the Outlook Application to a new email and inserts the defined subject into the subject line and the send to information. We have a user that is using Excel 2003 and the code is breaking at the line...

We have the below code that runs on the button click. In excel 2000 the code runs fine and opens the Outlook Application to a new email and inserts the defined subject into the subject line and the send to information. We have a user that is using Excel 2003 and the code is breaking at the line...

If on my report I have the Year in field Txt_Year and I have the Week Number in field Txt_Week, what function can i use to determine the datae for Friday. Example Txt_Year returns 2005 Txt_Week returns 20 I need a text box named Txt_Date to return 5/13/2005 which is the corresponding Friday for...

What i meant was that I wanted to what happens automatically when you check the box for Cascade Update in the Table relatiobships, BUT I just wanted to do it for one specific user. I did not want every user to have the ability to change a Claim number in the main Table and have those changes...

I have a text box on my main form for a Claim Number. This field is the basis of seral 1 To Many Relationships in Tables in the database. What I need is in the After Update event for this Text Box, to enable a Cascade Update of all the Tables related to this claim number based on a specific...

When I invoke a filter I have the following code on my OnCurrent event fo the Form. Problem is that after they do a filterBySelection it always displays Filtered record 1 of 1 even though there are more than 1 total records. if they advance 1 record it correctly displays. How can i correct...

I have a formula below that works great to justify a group of data if it is exactly 5 rows high. I needed to adjust this formula to say however many rows my mouse has highlighted justify out 23 columns like the rest of the formula says. How can I adjust this so that the rows are not a fixed...

I need to modify this. I have a range of Row 2 to Row 371 always for this sheet. What I need to do is if there is not a value of 1 in Column D for Rows 2:371, I need the row to be deleted. How can I modify this? Thanks Sub DeleteLongQuoteRows() Dim c As Range 'Application.ScreenUpdating =...

Could you give me the specific code and how to put it all together?

I need a Macro that wherever my cursor is in any cell on a workbook that it goes and copies exactly 370 Rows down and 23 columns over from my Active cell's position. How can i do this?