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!

  • 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: adrikev
  • Content: Threads
  • Order by date
  1. adrikev

    Outlook 2002 Security and Email Automation Problem

    Outlook Experts, I'm having an issue with Outlook 2002 XP that has me baffled. Background: I have an Access database that automatically sends bulk email to 100+ people at odd hours of the day i.e. 3:00 AM (This way normal daily traffic is not dirupted). Each person gets a different report, so...
  2. adrikev

    Upgraded Gentran Server NT to 3.1.1 map compatibility

    I just upgraded Gentran Server NT from 2.1 to 3.1.1. Everything was working fine until I altered a map. When the new map started generating errors I rolled back to the old map. Now the old map is not working correctly. I read in the release notes that old maps by default had a compatibility...
  3. adrikev

    Truncate - Not round

    I'm trying to truncate the decimals from a calculation that I'm making in a query. I have the following function but it returns 0 (zero) for all of my values. Public Function RndDn(MyNum As Double) As Integer Dim lngResult As Long lngResult = Int(MyNum) MyNum = lngResult End...
  4. adrikev

    Programatically unhide columns based on cell color?

    I have a range of columns that are currently hidden. I would like to unhide a column based on a cells color. Here is the code I have so far (it doesn't work). Range("R2:DQ2").Select For Each Item In Selection If Item.Font.ColorIndex = 35 Then With Item...
  5. adrikev

    Type Conversion Failure

    I'm importing Excel files via the TransferSpreadsheet method in a mod function: DoCmd.TransferSpreadsheet acImport, 8, "tblImport", sFileName, True One of the fields that is being imported is a zip code field. Some of the zip codes are Canadian consisting of alpha and numeric...

Part and Inventory Search

Back
Top