Search results for query: *

Ooops - The function code is in a module. I tried it in the form but the function was unrecognized by the query when it was placed there.

Well that didn't work! Here is the function code from the test. '********************************************************************* ' Purpose: Get a count of stores from the given field w/ delimter ' Inputs: Ref. to string ' Delimiter to split by ' Returns: Number of store in...

Here is the test db I created. If you click the button on the form it runs the query with #ERROR in the calculated field while the STOP command is in effect. As soon as you continue (and the code completes) the values fill in

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

Unfortunately no. This is still dealing with retaining previous drive mappings. I'm only trying to get the ones they have mapped previously to appear in the dropdown so they can reselect it.

No. I was wondering if it might be a policy or registry setting that I haven't found yet.

The settings are that connections WILL be remembered, but this I beleive controls whether the system will try to automatically recreate prior connections and I don't want it to do that. I just want the path to show in the dropdown so the user can select it when required as it is a drive that...

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?

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?

Thanks, That works just fine. Too obvious for my overworked brain I guess. Don

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

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

Hi I was using the IBM ODBC with the IBM DB2 UDB OLE DB in th linked server. I have created a new ODBC and an new linked server using the MS OLE/DB for ODBC but am still having problems. If I use the Delete from [R2D2Test]..CRPDTA.F0101DAU where aban8 = 100 syntax I get: Server: Msg...

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

You need to set the Cancel var. to True to not allow the update to the field & thus leave the cursor in the field. Don't bother with the SetFocus.

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

We have these routers at many remote locations that we need to contact via PC AnyWhere. In order to do this we need the current IP address of the outside of the router. The users in these locations are less that computer literate in many cases and are also often extremely busy running their...

Unfortunately neither of the above suggestions works (Grc.com or traceroute) as I really need to be able to record this address for users that are "less than technically challenged"!

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.