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 derfloh 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: SDuke
  • Order by date
  1. SDuke

    Using the IsNumeric() function - exponent sign

    The IsNumeric() function will determine if a string or variant holds a numeric value or not. It is useful, among other places, to be used in an edit control's (textbox) Validation or Change event. However, it also recognizes the exponent sign of Scientific format, such as 1E2 (= 100). or...
  2. SDuke

    Checking if a programm is still running.

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

    Checking if a programm is still running.

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

    Legal to distribute NTSvc.ocx in an application

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

    Problems with VBA SQL to VB

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

    Problems with VBA SQL to VB

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

    Error 8577 in Data Report Designer

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

    Using Replace when opening Excel from VB OCX

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

    Ado update through Datagrid

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

    Problem calling Help File

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

    DataCombo control question

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

    Checking if a programm is still running.

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

    Opening CHM Help file without using commondialog control

    '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...
  14. SDuke

    IsNumeric is not working

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

    Legal to distribute NTSvc.ocx in an application

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

    CreateProcess

    Thank you rudejohn for your input! (yes - my function performs similar) Thank you Hypetia! I feel stupid now - but still smarter than before! :-) The loop with a 250 ms wait interval and disabling the calling application did the trick.
  17. SDuke

    CreateProcess

    Hi! Who can help me? I am using CreateProcess - (Creation flag=NORMAL_PRIORITY_CLASS, Start flag = STARTF_USESHOWWINDOW, and NormalFocus) - and WaitForSingleObject - (INFINITE) - to start another application (for this example: Notepad) Everything works fine and the program starts and exits...

Part and Inventory Search

Back
Top