Recent content by phantomCO

Transcend, Let's say I'm a PM who doesn't know how to interview programmers so I pick a question out of an MCSE course? Sorry, but I laugh when I see these because every time when it comes down to dollars and cents, the pure answer tends to go out the window in favor of practicality. But I'll...

Wyld, I was just remembering that in VB6 there were cases where we'd have to place an explicit Close prior to opening a file that had been opened and closed in another scope. It never made sense, and it didn't happen in every case but the workaround was easy so I never bothered to research it...

lynix, That's pretty slick. Slight correction: System.Threading.Thread.Sleep(5000)

jd, Here's one way: Dim a As Date Dim b As Date a = Date.Now b = Date.Now.AddSeconds(5) Do Loop While Date.Now < b phan

dig, To be honest, we set permissions on the system level, not in access. I'd hope OfficeXP is better, but 97 & 2K just seemed to never be predictable when accessing remotely from a front end. I'd like to see what everyone else's experience has been lately since I have a project coming up with...

Mojo, Yep. Keep in mind the font on .appendtext is set in advance of placing the text and that you may need to add controlchars.crlf to the text for spacing. .selectionfont is a font type so you can pick the individual elements as well (.bold,.name,.italic,.size etc.) If you have a large...

Mojo, The richtextbox is an optionally bound control, there are a few ways to set what it displays. Assuming you've dimmed it as rtf, you could do an rtf.appendtext. An rtf.clear does what it says. Gives you more control, just as an example: rtf.clear fnt = New Font(&quot;Arial&quot;, 12...

Wyld, The fault is with the other process having basically 'locked' the file. So it depends on whether the other process can be run without locking the file. I'm not aware of a way around it but maybe there is one.

Mojo, In the pure sense, setting it as a property is more efficient I suppose. But I doubt there's a lot of difference in operation, I'm sure it's negligible. phan

mojo, Why do you need to bind the RTF?

dig, I think we need more info to answer this one like what OS's, how are you reaching it locally and remotely (name, dsn, etc.) It is doable, I've done it in the past but there are some quirks depending on the OS. phan

Thanks Doc, I always forget substring. Is it more efficient than the mid function or about the same? I'm thinking that it should be: dim username as string username=textbox1.text data = sr.ReadLine() 'You will need to change the substring start and length Dim UName As String =...

wyld, Sub in fixed lengths for the split function: data(0)=mid(inputstring,position, len) data(1)=mid(inputstring,nextposition, nextlen) etc....... phan

wyld, Why not just read it as text (assuming it is) and Dim v As String ' where v represents what you read from the file v = &quot;firstitem&quot; ComboBox1.Items.Add(v) v = &quot;seconditem&quot; ComboBox1.Items.Add(v) phan

pao, What we've done in the past is to create a network loader exe, checking date and time of the program (or any other file you want), then doing a FileCopy(SourceFile, DestinationFile); then finally having the loader run the actual exe. Never tried it with a folder though. phan