Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Fiat77
  • Order by date
  1. Fiat77

    Outlook 2002 and Office2000 OK-- Using it with Office 2003 or XP Bad

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

    Text Function Rounding Up

    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")...
  3. Fiat77

    Invoke a Hyperlink on a Page in PowerPoint

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

    Turn off a system message in a module

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

    Need function to get programmatically get the first of the year

    Thanks a lot Skip!!!!
  6. Fiat77

    Need function to get programmatically get the first of the year

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

    Test To see if attachment exists and if not append record to table

    ...if an attachment for this basepath exists and if not append a reord for the Code field with no attachment to a table named Tbl_NoFile? Thanks ************************************ Function ProductionFile() Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Dim rs...
  8. Fiat77

    Looping Module to EMail Attachment Based on Path

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

    Preserve Leading Zeros when saving XL file to CSV

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

    Problem migrating Excel 2000 File to Excel and Outlook 2003

    Thanks for the advice. We will try that
  11. Fiat77

    Problem migrating Excel 2000 File to Excel and Outlook 2003

    ...Sheets("Level 2 Support Manager").Unprotect Sheets("Level 2 Support Manager").Range("b22").Value = Now() Sheets("Level 2 Support Manager").Protect ************************************************************ Application.Dialogs(xlDialogSendMail).Show "FFAudit@gaic.com"...
  12. Fiat77

    Excel 2000 File with VBA Problems in Excel 2003

    ...Sheets("Level 2 Support Manager").Unprotect Sheets("Level 2 Support Manager").Range("b22").Value = Now() Sheets("Level 2 Support Manager").Protect ************************************************************ Application.Dialogs(xlDialogSendMail).Show "FFAudit@gaic.com"...
  13. Fiat77

    Determine the date for the Friday of a given Year and week Number

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

    Enable a Cascade update of tables Based on Windows ID in After Update

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

    Enable a Cascade update of tables Based on Windows ID in After Update

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

    Fitered record display not correct

    ...if they advance 1 record it correctly displays. How can i correct this so that my text box instantly displays the correct filtered record count? *************Code********************** On Error GoTo ErrHandle_Err If Me.NewRecord Then Me!txtRecDisplay = "New Claim " & Me.CurrentRecord...
  17. Fiat77

    Justifying data of varying row numbers

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

    Help with a delete Function

    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 =...
  19. Fiat77

    VBA Macro to Copy a Specific #of Rows and Columns Using Offset

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

    VBA Macro to Copy a Specific #of Rows and Columns Using Offset

    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?

Part and Inventory Search

Back
Top