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 Chriss Miller 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: alanf
  • Order by date
  1. alanf

    Windows 2003 and DI-30 not working

    DavidMcSpadden had it right on the money. The two KB articles are 828402 and 817688.
  2. alanf

    Data type for negative percentage

    Thanks, folks.
  3. alanf

    Data type for negative percentage

    Hi. What data type do I need to represent a negative percentage? Everything I have tried returns an error or zero. Here's a simple example of what I want: declare @a int declare @b int declare @c numeric(15,2) select @a = 1450 select @b = 1650 Select @c = ((@a - @b)/@b) * 100 print @c
  4. alanf

    Forget My last post on Output parameters

    Scratch the last post. Code works fine. I have spent several hours on this, and the whole problem was I wasn't grabbing the input params correctly from VB! D'oh.
  5. alanf

    Output parameter problem

    I am running a stored procedure from VB with ADO to SQL Server 7, and returning some output parameters. The proc runs fine from the query analyzer and returns values, but no matter what I try, I only get a value of NULL for my output params in VB. Help, please?? Here's some slightly cleaned up...
  6. alanf

    DTS Help

    Can you do this in SQL Server 7? I can't find the option to save as a VB module.
  7. alanf

    Passing multiple recordsets

    I am returning multiple recordsets from a SQL stored procedure, and using the ADO NextRecordset method to retrieve all of them into my VB app. Does anyone know if there are any problems created by passing too many recordsets back this way?? I am passing 7 recordsets back from one proc (I'm...
  8. alanf

    VB Data Report Designer

    Schmendrick...Have you checked the results of your query before it goes into the report? Maybe everything is coming up twice in the query because of your join condition.
  9. alanf

    Dynamically assign name of Data Report

    Thanks for your input CClint. The problem is, I want to take an existing report, pull it's name from the database, and get a handle to it. No matter what I try, I can't get a handle to it, using its name in a variable. So if the reportname is passed from the db to a variable, say sReportName...
  10. alanf

    Dynamically assign name of Data Report

    That's exactly what I'm trying to do, but in a VB/SQL Server app, not Access. I wanted to be able to generate multiple reports from a single routine, instead of having to write a unique routine for every report. I have figured out a workaround, but it still does not allow me to pull the name of...
  11. alanf

    Dynamically assign name of Data Report

    Does anyone know if there is a way to dynamically assign the name of a data report at runtime. I want to have a generic procedure to populate multiple reports at run time. But when I try to dynamically assign the name of the report I get errors. Set rptReport = sReportName gives me an...
  12. alanf

    IE 5.5, CSS and garbled text

    Thanks. That is interesting stuff. It does seem to deal with layout, rather than font, but it's certainly worth a shot. I tried working with it a little, and it seems to break the site in Netscape 4 (part of our spec is to be compliant with version 4+ browsers). Unfortunately too, I don't have...
  13. alanf

    IE 5.5, CSS and garbled text

    It almost never happens. I only know of this one person having the problem. He sent me a screen shot so I've seen that all of the text is garbled. It happened to me a couple of months ago in one text box, but the problem disappeared.
  14. alanf

    IE 5.5, CSS and garbled text

    I have a website with all the content in DIV tags using CSS absolute positioning. On most computers and browsers (IE 5.5, IE 6, Netscape 5+) everything is fine. But on one person's computer using IE 5.5, all of the text appears as junk symbols - squares and other symbols. The Font-family in the...
  15. alanf

    Combo Box - Reset to first item

    Combo1.ListIndex = 0 should work.
  16. alanf

    How do I Manage Form Modes

    I have used the form.tag property to identify what mode a form is in. You could set that tag based on the global suggested above, and enable/disable form features based on the tag setting.
  17. alanf

    Set Focus after validation

    CajunCenturion, Thanks for your input. In fact, that code was only to validate the 0th control, and I do check the index as you suggest. I had simplified the code for posting to the forum. Thanks for clarifying what the Cancel parameter is doing. Any guesses as to why the code does not leave the...
  18. alanf

    Set Focus after validation

    I have a masked edit box on a different form. There the code does not work. Private Sub medDrvr_Validate(index As Integer, Cancel As Boolean) If Not IsNumeric(medDrvr(4)) Then Cancel = True MsgBox "You must enter a valid number." End If End Sub This fails to send...
  19. alanf

    Set Focus after validation

    Well, I have a control array, so there is an Index parameter passed to the sub. But I had not noticed that there was a Cancel paramter too. Based on CajunCenturion's suggestion I set the Cancel to True, and that succeeds at keeping the focus. Private Sub txtDSA_Validate(index As Integer, Cancel...
  20. alanf

    Set Focus after validation

    Hi everyone. I have been unable to set the focus back to a control (i.e., textbox) after validating. Once the textbox fails the validation event, I pop an error message, but then I can't seem to set the focus back there. Any help is appreciated.

Part and Inventory Search

Back
Top