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 Shaun E 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: Som76
  • Order by date
  1. Som76

    Want to read a HTML file.

    Thanks john. But can u tell me innerHtml is property of which object?
  2. Som76

    Want to read a HTML file.

    Is there any way to read a HTML file line by line through a VB program by skiping HTML tags? Som :)
  3. Som76

    Run a Stored Procedure in VB

    Hi your code looks perfectly correct. Please check if there is any issue because of user. Since its a access violation, there might be conflict because of the user. Please let everyone know when ur problem is solved, and how it is solved. Regards
  4. Som76

    search with the first Word

    Could not understand what is your problem. Can you tell what problem u r faceing?
  5. Som76

    Assigning one value to multiple variables

    Hi Everyone given u some way to solve this. I thought I will give the way I do, I always use this. My answer is again use Array. But you said u will have a problem of keeping track of index of the array. For that i will give u a solution. VB prvoided enum to solve this. You can make an enum...
  6. Som76

    complex date time conversion

    Hi The above reply will help u to get date from the VMS value. If you need in the other way ie VMS value from date the try this: Dim dteDate1 As Date Dim dteDate2 As Date dteDate2 = "16-MAR-2004 14:53:30" dteDate1 = "17-Nov-1858 00:00" Debug.Print DateDiff("s", dteDate1, dteDate2) This will...
  7. Som76

    Combining date and times

    Hi try this dteNewDate = dteDate + dteTime Regards
  8. Som76

    How to Unhide Notes Database Design...

    Hi All, I have a database, its database design in hidden while replacing from *.ntf and checked the property 'Hide Desugn and Script'. Now I don't ve the *.ntf to again replace the design. Is there any way so that I can unhide the design of this database again. Thanks a bunch. Som :)
  9. Som76

    Fetching Registry Settings

    Hello, U have written: SaveSetting App.Title, "User Settings", vObject, sValue GetSetting App.Title, "User Settings", "Highlight State", g_bButtonHighlight Here what is "Highlight State", is it the default value? Actuall ur code should have been GetSetting App.Title, "User Settings"...
  10. Som76

    incorrect record count ...

    Hello, Ur recordset is not client side record set, so all the records are not yet fetched to client, thats why u get recordcount -1. To get proper record count, u must define the recordset as client side by saying its a clientside recordset, buit that will not alow u to update anything in the...
  11. Som76

    Need a sample client/server application in VB.Net

    Hello All, I need a small sample Client/Server appliation in VB.Net. The database will be in one machine, the data access leyer & business layer in one machine and user service layer & user interface in all clients machine. Please can any one send a small application with this architecture, if...
  12. Som76

    Need to insert around 65000 records, pls help to improve performance

    Hello Everyone, I need to insert around 65000 records to my database. Please help to improve performance. Currently I am calling Insert for every record one by one. 65000 insert call is badly slow. The data is currently available in an array. Thank you. Kind Regards Som
  13. Som76

    How to make querystring in view.FTSearch method(urgent)

    Hi there, I am searching a set of documents from a view.The search criteria is that I have documents having Items 'client1,client2,...,client16' and also 'EmployeeName' so I want to search those documents having ItemValue 'EmployeeName' and a 'Client' provided through UIdocument. So I am...
  14. Som76

    Having problem accessing a Webservice from Lotus Notes

    There is this very simple webservice, which takes an array as an argument. this service has to be consumed by domino. i tried with soapconnect (i found an example while searching on net) Endpoint="http://compname/myservice/myservice.asmx" Dim MyWS As New...
  15. Som76

    How to get Excel sheet data into an Array in VB, w/o reading each Cell

    Thanks Tony for ur efforts. I just did a trick here. I got time in any of the columns, for that column I read the text again which gave me proper data. The way we did returns xlsheet.Cell(lRow,lCol).Value so time was not returning proper. for the time column i wrote a loop and read...
  16. Som76

    While reading Excel file, time value eg 00:30 display me 2.0833333E-02

    Thank you for the suggestions. Dyarwood, I cannot have the option to format the sheet, since the xlsheets are output of a separate application from another organisation. I am developing a application to transfer these excel sheets to our company Dataware house. The transfer work will be done by...
  17. Som76

    While reading Excel file, time value eg 00:30 display me 2.0833333E-02

    While reading Excel file, if a cell has time value for eg 00:30, it display me 2.08333333333333E-02 instead of actual time value. 01:30 display 0.0625. and so on. All the time are displayed as decimal value instead of the proper time. Please help. Regards Somu
  18. Som76

    How to get Excel sheet data into an Array in VB, w/o reading each Cell

    Hello Tony, I tried taking the way u said into a variant object, and I got the result. I am using VSFlexGrid which has a method LoadArray, and if I pass this variant object, it display me the excel sheet data very fast. Previously i was scrolling through all the rows & cols of Xl Sheet which...
  19. Som76

    How to get Excel sheet data into an Array in VB, w/o reading each Cell

    How to get Excel sheet data into an Array in VB, w/o reading each Cell? If I read each cell one by one, it takes half a minute to 5 or 6 minutes to load the file since my excel files have too much data. Is there any other way I can read the excel file? Thank you in advance for the kind help.
  20. Som76

    Index for Help not found error

    Thank you for the suggestion, but there is a problem. For security purpose non of the machines has CD Drive enabled. Only administrator can enable the CD drive and do any installation. But to our bad luck he is not in country currently. If someone can suggest the file name missing, we can copy...

Part and Inventory Search

Back
Top