|
LittleEd wrote: o although not solved some progress. Going to check Excel versions across machines and that .NET frameworks are consistent.
My next two suggestions!
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
OK think we are there ...
Client machines were looking to run (& debug) using a V1 release under NET. It was quite a pain finding how to amend this setting.
Tried editing the registry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\8.0\AD7Metrics\Engine\{449EC4CC-30D2-4032-9256-EE18EB41B62B}
and adding & setting this entry:
CLRVersionForDebugging=V2.0.50727
..with no effect.
Stumbled upon a solution: edit (or create if necessary) excel.config.exe.xml file to look like
<configuration>
<startup>
<supportedruntime version="v2.0.50727">
<requiredruntime version="v2.0.50727">
& I placed a copy in the same dir as the excel.exe file. All COM classes now available, debugger works fine etc.
Should be *careful* on backward compatability issues but that's not a concern for me.
thanks for your interest,
GH
|
|
|
|
|
I should have added that i've tried to register the type library itself - the code ran fine but the still app didn't let me instantiate objects
the code I used was in the spirit of the link below
http://www.devx.com/vb2themax/Tip/18443
|
|
|
|
|
OK, there doesn't seem to be a concise definition of this anywhere, particularly on MS's pathetic excuse for help.
With the Mod operator, I've always thought that it return everything after the decimal point. Eg,
12 / 5 = 2.4
Therefore I'd expect
12 Mod 5 = 4
In practice, the result seems to be a random number, dependant on the current temparature in Kelvin, the number of times you have double clicked in the last six seconds and a random number between 12 and 47. From some testing...
12 Mod 5 = 2 ??
In fact, from the source code on MSDN, they say that
10 Mod 3 = 1
All I really need it for is working out if a Byte is even or not. If anyone can dare to explain, I'm sure it'll be useful.
Yet another spam post on yet another forum!
I am the lazy one, who sleeps as it suits him, codes what he wishes, and has many years to look forward to.
I love being a student.
|
|
|
|
|
MOD Returns the remainder left over after the first number is divided by the second number
12/5 is 2 with a remainder of 2 Therefore 12 MOD 5 is 2
10/3 is 3 with a remainder of 1 Therefore 10 MOD 3 is 1
and so forth.
Don
|
|
|
|
|
So it's the actual difference...dang. Been thinking in decimal too long. Well that was clever - especially since it's only taken me 3 years to notice...
Ooo...this could have new uses.
Thanks muchly.
Yet another spam post on yet another forum!
I am the lazy one, who sleeps as it suits him, codes what he wishes, and has many years to look forward to.
I love being a student.
|
|
|
|
|
Yuppers such as a quick and dirty way to check to see if the current minute is a multiple of 5 without all the fancy if minute/5 = int(minute/5) and so forth. Use it for all sorts of cool stuff.
Glad to be of help...
|
|
|
|
|
|
Hey out there,
I have a Sequential workflow I have written and published as a web service. I need to implement tracking for the workflow. However, every example I have found shows hosting the workflow inside another ASPNet application. I have tried multiple iterations and variations on this theme and nothing seems to work correctly. I don't get any faults running the WF, however, Microsofts "WorkflowMonitor" sample app crashes with a "GetWorkflow" error every time I fire up the workflow. I then have to MANUALLY clean up the tracking database before it will run properly again.
Does anyone out ther have a SIMPLE VB.Net based example of doing this?
Thanks,
Don Trainer
|
|
|
|
|
Hi to all,
I have create a little client to test a webservice called EuroCv.eu
The problem is the connection and the time of the connection to the server. I need to create a simple progressbar to show the progress of the request to the server.
Is it possible?
Thanks
|
|
|
|
|
Hello!
I would like to know how can I check the following listed below in runtime: I need these before user runs the application.
a. If a keyboard exists in puter
b. If a mouse exists in puter
c. What is the current screen resolution
d. What is the total available memory
3. Operating System (addressing numeric values)
Thank you.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
You can access the last three in my.computer but the first two i'm not sure.
Posted by The ANZAC
|
|
|
|
|
Hello,
VS 2005.
I have created a typed dataset. I have dragged some tables from the server explorer on to the designer.
However, one of my tables it doesn't auto generate the update and delete statements. I have tried configuring the table adapter. I have clicked the advanced options and checked all 3 options. And on methods to generate I have checked all 3 options again. I click next and it will tell you what statement it will generate, but the delete and update are not included.
Also, when I use this in code for finding by the primary key, it doesn't have a method for it.
i.e
<br />
datarow = me.dataset.software.findBySerialID(serialID)<br />
The method FindBySerialID doesn't exist.
Does anyone know why this is happening.
Thanks in advance,
Steve
|
|
|
|
|
Hi.,
How to call a webservice using javascript in vb.net, inline code using Ajax. I am using Atals, i have two textbox, first text box is autocomplete, autocomplete done using ajax, after the first text box is filled, the second text box should be filled depending on the first text box values.
Please guide me with examples.
Thanks and Regards
Shyam
|
|
|
|
|
This is a question better suited for the ASP.NET or Web Development forums.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I am posting the same problem 2nd time. Sorry for that but the strange thing is happening in the function. It suppose to display a message but it is giving me "An error occurred creating the form. See Exception.InnerException for details. The error is: Object reference not set to an instance of an object." error message. It loads the file there in no problem. Either keys and values exist in the file also. The message boxes display nothing. What is causing the problem? Thank you. Here is my code:
The file is under application.startuppath /bin/debug directory
Private Function GetCnfgParameter(ByVal MyKey As String) As String
Dim DocXml As New XmlDocument
Dim NodeXml As XmlNode = Nothing
DocXml.Load(Path.Combine(Application.StartupPath, "app.xml"))
NodeXml = DocXml.DocumentElement.SelectSingleNode("//configuration/AppDefaultValues/add[@key=""" & MyKey & """]")
If TypeName(NodeXml.Attributes.GetNamedItem("value")) <> "Nothing" Then
NodeXml = NodeXml.Attributes.GetNamedItem("value")
MsgBox(NodeXml.Value)
Else
'No @ mykey attribute in attributes collection
MsgBox("Could not find the @mykey attribute as in a <add mykey=''> element.")
End If
Return NodeXml.Attributes.GetNamedItem("value").Value
NodeXml = Nothing
End Function
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
JUNEYT wrote: NodeXml = DocXml.DocumentElement.SelectSingleNode("//configuration/AppDefaultValues/add[@key=""" & MyKey & """]")
This line is prone to "Object reference not set to an instance of an object" error. You will have to check whether NodeXml is nothing before using it further.
JUNEYT wrote: TypeName
What is this used for ? and what does it returns ?
JUNEYT wrote: <> "Nothing"
If you are trying to compare returned value for nothing / null then you will have to write -
not ({expression} is nothing)
or
not ({expression} = nothing)
Use the 'is' keyword if the return of the {expression} is a reference type else use '='
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
coolestCoder
|
|
|
|
|
Thank you very much I solved the problem. The back slash was causing it.
cheers!
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
Also,
I got two Table Name Volume and VolumeLessons .
I have used a Query to make a SingleTable name Query_Volume_VolumeLessons, now this table is inside my code or Prject not in SQL SERVER DataBase.
Now I need to pull data from Query_Volume_VolumeLessons to make another two table name Query_Volume_Sector and Query_Volume_Themes for further work and then lots of thing....................
Please help me
Sarfarj Ahmed
|
|
|
|
|
In my opinion instead of making a table, populate a dataset with your query as because you can easily loop through your dataset to do your operation....
Tirtha
"A man can ride on your back only when it is bent....."
|
|
|
|
|
Thanks for your reply
I have alredy added a DataSet name Publications where I have add three tables.
Table(0) is Query_Volume_VolumeLessons
Table(1) is Query_Volume_Sectos
Table(2) is Query_Volume_Themes
Also put data on Table(0) from SQL SERVER DataBase
Now How can I put data to Table(1) From Table(0) , using a sqlQuery
Thanks
Sarfarj Ahmed
|
|
|
|
|
Sarfaraj Ahmed wrote: Urgent 002
This is a useless subject line. Please use more appropriate subject lines in future. Hint: No appropriate subject line will include the word "urgent"
|
|
|
|
|
Thanks for ur Email
Can you help me?
Sarfarj Ahmed
|
|
|
|
|
This is the 6th post you've title with "urgent" or "please help." Many people will avoid answering these questions with such subjects.
_________________________________________
You can't fix stupid, but you can medicate crazy.
|
|
|
|
|
I need some instruction and help
Customer Table
CustID CustName
01 ABC
02 ACB
03 ADB
Order Table
OrderID CustID
1001 01
1002 01
1003 01
1004 02
1005 02
1006 03
1007 03
1008 03
1009 03
1010 03
I want those output like below
CustID CustName OrderID
01 ABC 1001, 1002, 1003
02 ACB 1004, 1005
03 ADB 1006, 1007, 1008, 1009, 1010
Please help me. Thanks
Sarfaraj
Sarfarj Ahmed
|
|
|
|