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

    How to cycle through Recordset 500 records at a time

    Thank you to BNPMike and PHV for the replies, they have been very helpful. Thanks again Sheriff
  2. Sheriff

    How to cycle through Recordset 500 records at a time

    Thank you for the reply, this is the query, I don't think it will qualify as multi join. The Client just want to have the complete recordset in the grid. It goes without saying that all variables are dimed. I am trying to make it faster. thanks again MySql = "SELECT Pawns.*" MySql =...
  3. Sheriff

    How to cycle through Recordset 500 records at a time

    Hi, I have about 6600 record is access db and it is beginning to bog down when all of the record are selected. Is there a way to get 500 or more records at a time in grid form until you reach EOF Thanks in advance Sheriff
  4. Sheriff

    Cmd fired on one computer made to fire on another using VB

    Thanks Andy, I will look @ Winsock control. Sheriff
  5. Sheriff

    Cmd fired on one computer made to fire on another using VB

    I haven't had much experience with computers that are networked and I am trying to write an app that when an event is fired on one computer it will fire on the other computers. I have tried "Function SendMessage" and it will send msg but not event. Anyone has any ideas or know how to...
  6. Sheriff

    convert string data type to checkbox data type

    Set varChb = rst!CheckboxName You might try this Set varChb = val(rst!CheckboxName)
  7. Sheriff

    Net work

    I haven't had much experience with computers that are networked and I am trying to write an app that when an event is fired on one computer it will fire on the other computers. I have tried "Function SendMessage" and it will send msg but not event. Anyone has any ideas or know how to...
  8. Sheriff

    Winsock Control or API for E-mail speed ??

    Thank you Schroeder, I will try that Sheriff
  9. Sheriff

    Winsock Control or API for E-mail speed ??

    Hi, I am undertaking a project that requires the ability to send email. I'm not familiar with this aspect of programing and help would be appreciated. The ability to send fast is also a factor. Thanks Sheriff
  10. Sheriff

    please help newbie understand combo box

    jono, You could try this code. This needs to be in the form that will display the results, in the click event of the combo box call the ShowRecord. You could use a list box for the same results. You (may or may not)need the myRS.AbsolutePosition in the click event of combo box. Good Luck...
  11. Sheriff

    Windows XP Default Colors

    Thanks ViperGTS, I Did that, and tried several others thing and I still come up with the same standard gray on the form. Thanks for taking the time to help Sheriff
  12. Sheriff

    Windows XP Default Colors

    Thanks ViperGTS, I placed in the main form Activate: frmMain.Backcolor = &H8000000F& and I didn't see any change. If it needs to be placed else where please advise. If you have a code sniplet that does this or a link that I get the code sniplet from I would greatly appreciate having it. Any...
  13. Sheriff

    Windows XP Default Colors

    Thanks Norris68, I'll Try Both Sheriff
  14. Sheriff

    Windows XP Default Colors

    Thanks Norris68, The problem is, those colors are not in the palette colors or the system colors, at least I can't find a match of Win XP default colors and I have a degree of color blindness and unable to create an exact match. Thanks Sheriff
  15. Sheriff

    Windows XP Default Colors

    Hi, I'm using Win 98, I want to use The Win XP default colors in the design mode. The color property in VB6 dosen't have that color. Does any one have the Color numbers for the title bar and the form to make your app with these colors. I know you can create custom colors, however I have some...
  16. Sheriff

    Send Email from VB app

    sb@cableone.net
  17. Sheriff

    Send Email from VB app

    Hi, I want to send email from VB,can any one help, is there a site that may have tutorials using the winsock control. any help would be appreciated. thanks Sheriff
  18. Sheriff

    Help with Query

    Hi, WildHare Yes it is Strings, However the exact Query (except table name) produced correct results in another VBP, that why I'm baffled, I'm still in the learning stage. The Mask Edit controls allows set setting a mask (##/##/## and the format ddddd) in the properties. I'm always open to a...
  19. Sheriff

    Help with Date Quuery

    I'm having a proplem with Query for access with vb6. The Query returns records that are the range but the year is off. example if sBeginDate = "01/01/02" and sEndDate = "03/31/02" the records also include 01/01/01 as well as 01/01/02 I am using the MS MaskEdit control to...
  20. Sheriff

    Help with Query

    I'm having a proplem with Query for access with vb6. The Query returns records that are the range but the year is off. example if sBeginDate = "01/01/02" and sEndDate = "03/31/02" the records also include 01/01/01 as well as 01/01/02 I am using the MS MaskEdit control to...

Part and Inventory Search

Back
Top