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!

Register Log in
  • Congratulations Rhinorhino 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: rds747
  • Content: Threads
  • Order by date
  1. rds747

    string to date conversion

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

    limitation to receiving lines

    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!
  3. rds747

    form unloading issue

    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?
  4. rds747

    duplicate rows

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

    Kodak Image Thumbnail Control

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

    Canon 6570 copying issue

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

    question on FaxCom

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

    delete IE 7

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

    sql query

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

    radiobutton control array

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

    validating text as numeric

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

    question on scanning

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

    copy table from 1 db to another

    How do I copy one table from one database to another?
  14. rds747

    if stmt

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

    sql query

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

    basic troubleshooting

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

    Scanner window

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

    searching for value through VB

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

    Random generator for file

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

    Image Control and Fax Server code help

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

Part and Inventory Search

Back
Top