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 strongm 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: *

  1. brailian

    Why are stored proc params being passed NULL?

    Actually, VB Intellisense did not reveal that there was a SetCurrentValue method, so I was using the AddCurrentValue method instead which appears to do the same thing. However, when I typed out SetCurrentValue, it accepted it. Same problem, though. However, I just solved it. On a hunch I...
  2. brailian

    Why are stored proc params being passed NULL?

    Actually, it is 1 not 0. You are probably thinking of the API. The RDC appears to be 1-based. And like I said, it doesn't give an error, it just passes NULL to my stored procedure.
  3. brailian

    Why are stored proc params being passed NULL?

    VB6, RDC, ODBC, SQL Server This is probably very easy, I'm just new to RDC (been using OCX for years) I have a VERY simple report using ODBC, based on a stored proc with 1 char param. It works fine in the Crystal Designer. In VB6, I add the viewer to a form and add this code: Private Sub...
  4. brailian

    Disabled Text with the Etched/Sunken look

    I've noticed that the text of a disabled command button looks different from a disabled label or textbox. It turns a lighter shade of gray as opposed to a darker, and it gets an etched or sunken look to it. Does anyone know how I can make the text of a label look that way? Or, if the label is...
  5. brailian

    How do I close forms w/o letting them run any more code?

    Hmm, I was afraid that would be the only answer. I can't use End because (a) I hate it and (b) I'm actually just exiting all but the first form. Unfortunately, if I were to call form3 from a proc called by a proc called by a proc called by the form2 command button, then I would have to play...
  6. brailian

    How do I close forms w/o letting them run any more code?

    This might be a tough one. Does anyone know of a way to close a bunch of modal forms without letting them execute any more code? For example, I want to close forms 2 and 3. Form3 is called modally from a command button on form2 (see code below). How do I kill both forms but prevent the...
  7. brailian

    Can you have a timer without using the control

    Heh, unfortunately, SetTimer seems to require an hwnd argument which you only get if you have a form/window, therefore...back to square one. Might as well create a form, drop a timer on it, and load it w/o showing it. Aesthetically repugnant, but that's life. Seems my question has been...
  8. brailian

    Can you have a timer without using the control

    I want to put a timer into a class that has no user interface (i.e. no form to drop the timer object onto). Does anyone know of a simple way to do this? Do I have to use an API call? (if so which?) Thanks, AJ
  9. brailian

    Trying to make a simple counter using a timer

    He meant put those 2 lines at the VERY top of the program (in the General Declaraions section) not in the Form_Load event.
  10. brailian

    Apostrophes in SQL Statements

    Use the replace function to replace single quotes with two single quotes on strings you wish to add to your SQL statement. Most SQL compilers will treat 2 quotes in a row as one. For example: UPDATE mytable SET myfield = 'isn''t' will set myfield to the value "isn't" Replace...
  11. brailian

    Two modal dialogs in VB hangs the IDE

    Here is a weird one that locks up both my program and the IDE. It's VB6. Can anyone explain the behavior described below? (and please, no one say you can't have 2 modal forms at the same time, you can, I do it all the time) 1. Create a DLL project. 2. Add a form, place a command button...

Part and Inventory Search

Back
Top