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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kainite

  1. kainite

    SQL backup

    You could of course revert back to SQL Server 6.5 because you could do table only restores in 6.5 .... that's progress isn't it! Best solution I have found is to have a low spec big disk server (i.e. not fancy/costly disks just "normal" PC ones) that has buckets of space and restore to that...
  2. kainite

    Setup Officeconnect 531s with NAT

    1. Setup NAT CO NA NAT enabled Trans own addr enabled NAT IP Address = INTERFACE NAT Masq net = local net addr yours = 192.168.67.0 NAt Masq mask = 255.255.255.0 2. Enable DNS Proxy (so DNS requests sent through to ISP) CO DN PR and set first field to Enabled 3. Set up ISDN call table...
  3. kainite

    System Date Format

    If it is a data bound control that you are concerned with just use the DataFormat property to set format as "yyyy/MM/dd" - if this is not in the list of possible "Date" formats choose "Custom" and type that in
  4. kainite

    Field names in recordset

    To see what fields you have in a recordset just use Dim rs as Recordset Dim f As Field open rs as normal then e.g. For Each f in RS.Fields Debug.? f.Name Next Of course aliasing as in earlier replies removes ambiguity of calcualted fields so is obviously what you should have done oin the...
  5. kainite

    test existence of a source class at run time

    Use "CreateObject" to create the class defining object as just Object e.g. say your different object names where in a string var sObjName (in your e.g. this might be AZC_WRD, AZC_CRT etc Dim objTest as Object Set objTest = CreateObject(sObjName) Of course this means app is fully late bound -...
  6. kainite

    macro fails because of variable number of rows

    You need to post your macro code - but I think you will find Macro Recorder cannot handle CtrlA sensibly and has changed it to e.g. Range("A1:B9").Select where you need something more like Range(Selection, Cells(1)).Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select...
  7. kainite

    OLE and Notepad

    Notepad itself does not support OLE so it can't be used to display the object - problem is .txt files are associated with Notepad so it is a no go. Process for determining OLE server for an extension is: In registry look up extension in HKEY_CLASSES_ROOT - and take the "(Default)" string for...
  8. kainite

    Type Mismatch

    Sounds like you are barking up the wrong tree here but first - a hint on finding out which MDAC a machine has Go to C:\Program Files\Common Files\System\ado and look at the file properties for msado15.dll - if this is e.g 2.71 then you have MDAC 2.7 etc However back to orginal type mismatch...
  9. kainite

    Mercury not accepting attachments more than 2mb

    This is probably a limit imposed by your ISP so all Mercury is receiving is the notification from ISP that email cannot be received
  10. kainite

    Mercury Mail for Exchange?

    You seem to have the relationship between Exchange and Outlook a bit confused - Exchange is the "server" product much like Mercury is a server product and Outlook is the "client" product much like you are currently using Pegasus as the client. There is no problem substituting Outlook as the...
  11. kainite

    Disabling delivery receipts

    Thanks Zaphod4242 - that seems to have done the trick - guess from your handle you have a mind the size of a planet!
  12. kainite

    Out of memory error VB6

    It would help if the question had the details of what the error actually said. Have you got access to a Win NT/2000/XP machine to test on? If it works fine on one of those probable problem is due to "resources" which often get reported as out of memory errors - Win9x had a 64K memory allocation...
  13. kainite

    Disabling delivery receipts

    Thanks Steelburner - sadly the network broadcasts are just to do with Netware LAN messages that pop up on screen of local user's who have received incoming mail
  14. kainite

    Disabling delivery receipts

    Spammers often use delivery receipts to confirm addresses are live - I want to turn off delivery recipts in Mercury to deter this - I can't seem to find any such option - any ideas - mail is being picked up by the POP client module
  15. kainite

    Mercury MTS and Outlook XP on same PC

    I run in this mode - no problems - what I have is a static IP addres set on the machine running mercury (i.e. on the local net card - no need for static IP from the ISP) so that the other machines will always be able to find it (dynamic IP would need some sort of name server) - then in all...

Part and Inventory Search

Back
Top