Search results for query: *

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!

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?

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.

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

I foolishy dared to run IE 7 on my pc, but the browser freezes everytime I try to go to a site. So now I've removed the browser from add/remove windows component and I want to install IE 6 again. Problem is that when I double click IE 6, I get an error saying that there is already a new...

if the query shows results like: Customer 1 1234 ABC Customer 2 4567 DEF Customer 1 1234 GHI Customer 1 1234 JKL Customer 1 1234 MNO The query above could be Select CustomerName, CustomerNo, PurchaseOrd from Table1 If 1234...

Think I've asked this question before, but cannot find the thread. Also tried searching for the answer. In Design Time, I created two radio button control arrays. Option1 has 3 indexes and Option2 has 2 indexes. Option1 doesn't have any values set to true before run time. Option2(0) by...

Gentlemen, Is IsNumeric the best function to validate whether the user has entered a numeric text in a textbox? Thanks!

I'm using the Kodak Scan Image Control. Certain documents are legal size and when they get scanned the documents saved are cut off. In the Imaging Software(Windows), before you scan you have to specify whether the paper size is of letter or legal size. This will not work because if there are...

How do I copy one table from one database to another?

Simple question.. The if stmt is [code] If (lngAffected < 1) then Msgbox "Record does not exist" Exit Function End If [\code] How do I change the if stmt so it's: [code] if (lngAffected < 1) then Msgbox "Record does not exist" Exit Function [\code] Thanks.

Table has two columns. I don't want to display columns that have an empty string. Select * From Program Where Location <> "" Or Description <> "" Something like that. Thanks.

Ok Cisco experts I need your help... One section of users had problems logging onto the domain. The ethernet card was working fine (had the green light on) on each PC. My supervisor pretty much turned the switch on/off (recycled the power) and everything worked fine. If that hadn't worked...

When I put a paper on the feeder, the Choose Application window appears giving the user the opportunity to choose a scanner application (Imaging or in-house app). I believe it's the TWAIN driver that triggers this window to appear. How do I make this window from not appearing? Basically, I...

In VB I want to find whether an Order # exists from the db. But my lack of vb coding with sql experience is preventing me from doing this. Here's the code: strSQL = "Select Distinct OhNo, CmImgRec, CmName, CmAddress From OrdHead Join CusMast" strSQL = strSQL & " On OhCus = CmCust Where OhOrd...

What is the best way to create a random number for a file? For example, I would like the file name to be "C:\Test42356.tif". The file is a temp file which will be later deleted from the drive. From MSDN I could try this: MyValue = Int((100000 * Rnd) + 1) ' Generate random number between 1...

I'm trying to annotate an image and then fax it using the Kodak image controls and the MS Fax Extended COM. Here is the code: [code] Private Sub ImageWODeleteCode() ImgEdit.Image = "C:\Scan\00015361.tif" ImgEdit.Display ImgEdit.SaveAs "C:\Scan\Test.tif" ImgEdit.Image =...