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 Mike Lewis 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: LAndy
  • Order by date
  1. LAndy

    advice? Passing ByRef...

    Hi Sunaj, thankyou for the reply, do you know anywhere i can look up the dangers of passing byref as opposed to explicit hardcoding? I've always been too scared of messing up Text1 and Text10 to do a global replace ( and no, i don't really name by controls quite like that but you know what i...
  2. LAndy

    advice? Passing ByRef...

    I would prefer ByRef as then when you change Text1 to NewText47 you only need to change the code once. Is there any reason they have to go ByRef instead of ByVal? What problems is it causing you? I'd be interested too as I'm not that experienced either, Andy
  3. LAndy

    keyAscci?

    or, used in the same place, the slightly less readable If Not (KeyAscii < 32 Or (KeyAscii > 48 And KeyAscii < 57)) Then KeyAscii = 0 End If Andy
  4. LAndy

    datediff question

    sorry,additional - i also meant to post that Not 0 is always true, so it is only checking if it is < 90
  5. LAndy

    datediff question

    hi, the problem is in your second if statement it works as If (HoldDate < 90) And (Not 0) Then when what you probably want is If HoldDate < 90 And HoldDate <> 0 Then HTH Andy
  6. LAndy

    Time Diff Question

    hi Ebee, it will use the full time, not just the seconds, similarly MsgBox DateDiff(&quot;s&quot;, &quot;25/12/01 5:42:18 AM&quot;, &quot;27/12/01 7:26:38 AM&quot;) will give you a LARGE number, HTH Andy
  7. LAndy

    Testing for a text file

    Hi Thom, you can use - if Dir(&quot;C:/PathToTextFileAndName.txt&quot;)=&quot;&quot; then doesn't exist, or if Dir(&quot;C:/PathToTextFileAndName.txt&quot;)<>&quot;&quot; then does exist HTH Andy
  8. LAndy

    Need help with Inet (Internet Transfer) in Access

    excellent, glad it helped! To play fair it came from http://www.vb-world.net/internet/tip501.html
  9. LAndy

    Need help with Inet (Internet Transfer) in Access

    Hi Brooks, i was trying to do a similar thing in vb the other day but using .Execute instead. It was really flaky. In the end i resorted to the below code, which generates a file on your local drive/server, which i then read back into a var. Strangely, it seems not only more reliable but...
  10. LAndy

    Time a Message Box to appear then close w/o user keys

    Hi Arden, there probably is but it may be just as easy to make a small form that looks like a message box ( you can even leave off the OK button if you don't want it ) and then use it's timer event to close after whatever you want, HTH Andy
  11. LAndy

    Repeated Inet v6 calls fail

    Hi All, i'm building an application in vb6 that i want to grab various pages from a particular website, run through them looking for a particular tag and then chuck out the data in my chosen format. I'm happy with the parsing and writing but only the first inet call works, any subsequent...

Part and Inventory Search

Back
Top