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
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...
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...
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 :)
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"...
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...
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...
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
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...
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...
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...
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...
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
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.