Search results for query: *

Didn't have to add the 20 in: strdtEntered = Mid(strdtEntered, 1, 6) & " " & Mid(strdtEntered, 7, 2) & ":" & Mid(strdtEntered, 9, 2) & ":" & Mid(strdtEntered, 11) to have RODTCREATE show: 2006-09-25 08:26:26.000

Thank you, George. It worked perfectly. Will take a long at the thread for heavy reading. In Ts yyyy-mm-dd hh:mm:ss[.fff] what does the f stand for?

cTest = "06092508262" Debug.Print "20" & Left(cTest, 6) & " " & Mid(cTest, 7, 2) & ":" & Mid(cTest, 9, 2) & ":" & Mid(cTest, 11, 2) If I do it that way would I be able to insert that value into RODTCREATE which has datatype of DT?

Sorry George. I typed the numbers wrong. 060925082626 is YYMMDDHHMMSS Y - Year M - Month D - Day H - Hour M - Minute S - Second

Actually dtEntered = mid(strLine, 68, 11) gives an error so i tried: dtEntered = format(mid(strLine, 68, 11), yymmdd & hhmmss) but that doesn't work either.

how do I insert the string = '06092508262' (date and time) to a field (RODTCREATE) in sql server 2000 with datatype datetime? What I've tried so far: dim dtEntered as Date ... dtEntered = mid(strLine, 68, 11) ... Insert Into RORDER(RODTCREATE) Values('" & dtEntere & "')" I suppose the...

Hi Everyone, Does Windows 2003 Server Standard Edition put a limitation to the number of lines that you can assign to receive faxes? If there is any MS documentation that someone can pinpoint me to that would be the best. Thanks!

strongm: would this work? a) save the text of the 1st txtbox to a string b) Concatenate the 2nd txtbx to the string adding a "|" before you add the text c) repeat that for each txtbox d) save it to a file e) parse/split the string to each txtbox the same way it was concatenated.

Thanks Golom.

works, I'm confused. I thought an Unloading of a form would stop a form from executing afterwards. So shouldn't unload me close/exit FormA and prevent formb.show from executing.

As of now unload of form A happens in form B. Golom: I tried doing it the way you advised formb.show unload me (as it sounds the most logical), but after stepping through formb.show the precedence is given to that form and formA will not unload until I close formB. I had this code in a grid...

No, should Form A have Unload Me in queryunload?

Form A calls Form B, when Form B is loaded I want to unload/kill Form A. Vb steps through the code Unload FormA without a problem, but after running the code I still see Form A behind Form B. Any suggestions on how to unload form A?

Thanks for replying, Zack. Just wanted to make sure that if A1 contained the value '12345' and if A2 contained the value '12345', there is no way that I can have an message box saying cannot enter '12345'. Thanks.

So there isnt a quick option in excel? I can either write code or download the duplicate master?

How do I validate a column in excel to make sure it doesn't have any duplicate rows?

Has any used the thumbnail control to move images from one position to another? For example, using the control to move page/position 3 and dragging or dropping it to page/position 7. Thanks.

if anyone comes across this problem what I did was turn of the ability to copy from tray 4. Procedure: Additional Functions -> Common Settings -> Auto FDS -> turn off tray you need to.

Users make copies to a Canon i6570 and sporadically rather then going to Auto tray it jumps to the 4th tray. Trying to figure out how to prevent that from happening.

I'm retrieving faxes from the MS Fax Inbox and checking whether the file size of the message is < than 2 KB. If the file size is < than 2 KB then I would delete the file. The only problem I'm coming across is that the amount of messages in the inbox has to be predefined. So for example, I...