Recent content by SDuke

What makes you think using a timer is an unqualified reply? And should we not answer any questions at all with-out specifics? Assuming the purpose again, I would consider a timer and disabling the application, if nothing else is running it the app., and if the called programm is an application...

Timer vs. Sleep? Did I say that? I didn't say that. Timer vs. Loop Anyways, Timer vs. Loop or Timer vs. Sleep, Better? Guess it depends on what is being done. I just gave some options. Not much more help can be given with-out knowing if the called programm is a Visible task or not (because...

There is a Readme.Txt file which came with it which explains how to use it. Also, do a search in microsoft.com and your msdn help files. That's about all there is, as far as I know - obviously because it's not supported.

>re-written in VBA In Jet VBA! That means using a function which is available in the Jet VBA module and written directly in the sql statement, and not a function written in a VBA or VB proceedure! Say your Name field has: JONES, Fred James Then you need to seach for the position of the...

Haven't read your code - only the initial post. You cannot use a public funtion created in an MS ACCESS module in a "query" called from VB. You will need to try to accomplish this using Jet VBA functions such as: IIF(), Mid(), Left(), InStr(). etc. - however, not portable to other Dbm-systems...

-Use a Static recordset cursor. -Test the recordset independently of the DataEnvironment. Bound controls like the Data Control or Data Environment (yes - it is also a bound control) make it sometimes difficult to directly trouble shoot problems.

Just check first IF data exits (use Len() for strings or IsNull() on variants) prior to using the function.

The error description says it found more than one record identical to the one you are trying to update, and because you want to update only one record to the recordset at a time (non-bulk update) it prevents a mistake from happening. When a record is to be updated, ADO needs to know where it...

Windows Help file = *.hlp , and not *.chm. Two different things.

XRecordset.Find "ProductCode='" & XDataCombo.Text & "'" If ProductCode is not a text field, then drop the single quotes

use an API Timer - do a search here You say "check...if...still running". If your application has started another application and is to wait until it finishes, then maybe try and use the APIs CreateProcess and WaitForSingleObject - also do a search here.

'Use this in a public module (declarations) Private Declare Function HtmlHelp Lib "hhctrl.ocx" Alias "HtmlHelpA" _ (ByVal hwndCaller As Long, ByVal pszFile As String, ByVal uCommand As Long, ByVal dwData As Long) As Long 'hwndCaller = Caller's hwnd 'pszFile = the file and path...

> It doesn't even allow decimal points! Doesn't even allow negatives! >You can keep everything but numerals out of a textbox like this Not quite. It does not prevent non-numeric values from being copied into the control. So you still need to Validate the control.

I don't see why not. There is not redist file or such as far as I'm aware. MS doesn't support it at all. The NTService control was created so that developers of VB applications could run the apps as a NT service. IMO it can be used as you wish, as long as you keep MS out of the picture (no...