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

    User defined function fails only when VBA running

    I have a user defined function defined in a module in an Access 2010 DB that used to work fine when referenced to create a calculated column in a query. Now it has an odd behaviour! When I run the query manually, it works as expected. However, when I run it with a VBA program, it now fails...
  2. DonU

    Map Network Drive folder list empty

    In XP, when I map a drive to a specific path, then disconnect it and later want to connect it again I can select the path from the folder drop down under "Map Network Drive". When I do this in Vista it does not retain the previous path(s). Is there a way to turn on this functionality in Vista?
  3. DonU

    How do I tell in a program/script if Auto-Protect is running?

    As part of our PCI-compliance, I need to be able to tell if Auto-Protect is running on some of our companies computers. How can I find out for sure, from a program or script, that it has not been disabled?
  4. DonU

    Unable to return param.s from a Sub

    I have a prob. returning values from a Subroutine in Access 2000. I thought that the default was to pass ByRef which would allow the called routine to change the value which would allow the calling routine to see the new value. I am coding: Option Compare Database Option Explicit Private Sub...
  5. DonU

    CL *CHAR Variable undeclared

    I recently found a bug in a pgm where I had coded the following: ======================================================== /***** Program Variables */ DCL &Pfx1 *CHAR 1 DCL &Pfx2 *CHAR 2 DCL &Pfx4 *CHAR 4 RCVF...
  6. DonU

    AS400 LINKED SERVER FAILS ON INSERT/DELETE

    I have successfully setup a linked server from my SQL Server to our AS400 that I can use for SELECT's and UPDATE's. However I can not get an INSERT or DELETE to work. First what syntax should I be using. For the insert if I use: INSERT INTO OPENQUERY([R2D2-Test], 'SELECT ABAN8,ABALPH FROM...
  7. DonU

    SQL Mail w/Outlook hanging

    I am moving an application from an NT4 box running SQL 7 to a Win 2003 server running SQL 2000 (SP3) that requires mail for incoming data. I have configured SQL Mail (& Agent Mail) according to all the MS KB recommendations (domain account, admin, etc.). I can send & receive mail manually and...
  8. DonU

    Determine Router / Firewall external IP address

    I have a router/firewall combo and I need to know the external IP address of the router (obtained from my ISP via DHCP). Is there a way I can determine this without accessing the router administration? Idealy, I would like to be able determine this in a program from inside the router.
    • DonU
    • Thread
    • Replies: 9
    • Forum: TCP/IP

Part and Inventory Search

Back
Top