Hi,
I am using VB and excel and I would like to know how to add a watch to
an expression in VB for some lines of code. When I select a value in
excel and add a watch on a variable, I get Value: <Out of Context>.
Could somebody please explain how to add a watch expression properly
when i select a value in excel. Thanks in advance.
Swamy
nsharish20
Last Activity: May 31 '07, 05:32 PM
Joined: Apr 15 '07
Location:
-
How to add a watch to VB expression
-
Thanks a lot for your help. Everything worked fine and I owe it all to you. -
Hi
Your code works. Thanks a lot.
One more thing. Can you please tell me how I can convert a module into a macro. The previous version of the code I gave you came from the macro which I converted to VB. In the macro, I had the option to select the action called SendObject and fill up the parameters.
Now I want to create a button in the toolbar to execute this code. If you can tell me that, that would be awesome. ...Leave a comment:
-
Does this lookup function copy the report # from the query and put it in the subject line? I'll be testing your code tomorrow to see how it works and i'll report back to you. Thanks
Here is a picture of the query if it helps.
Thanks for your help...Leave a comment:
-
E-mail macro
Hi,
I am a beginner with Access but I have managed to play around with VB and macros.
I have a query called "qryClosure ". In this database, I have fields like Report #, Customer #, CA Resp, Defect Code etc.... and only ONE record. This query is linked to the report called rptCloseout and Report # from qryClosure is in this report. Now what I want to do is when I send a snapshot of this report to someone using... -
Is there a way to attach my files in this forum so that I can show what I am talking about?Leave a comment:
-
So I'll brief you on the problem and I'll give you some excel files that has all the rough work. Later, I can show you the excel file with all the VB codes (to be quiet frank, I haven't changed much in this as I was working a lot on excel). I dont know how I can attach them in this forum?
So I have a big circle that consists of 32 small circles called sensors oriented at different places. On top of this I am going to put a blue print...Leave a comment:
-
Thanks a lot for your help. I wonder how you are staying up all night to work on this.
I am coordinating with excel and VB. In VB, my friend has written some coding and all i do is to put up the conditions for the sensor to read the holes (larger circles) and slots (slot is a hole shape that consists of a semi-circle and a rectangle. There is more that I have to tell you about this assignment and I'll tell you more later as I am busy...Leave a comment:
-
If I have 4 coodinates of the rectangle: x1,y1,x2,y2, x3,y3, x4,y4 and the radius of the semi-circle, what mathematical approach should i use to determine whether the sensor is in or out or mid? The width of the rectangle is always equal to 2 times the radius of the semi-circle.Leave a comment:
-
Hey,
Sorry for my late reply. Your logic seems a little right and I have solved this problem with your help. However I have another problem with another kind of shape design.
I have a rectangle with a semi-circle on top and I am given X,Y coordinates of the center of the semi-circle. Now I want to come up with conditions that will check whether the smaller circle is in the boundary region of this shape, out of the boundary...Leave a comment:
-
What I want to do is to come up with two conditional statements that will check two cases and produce a result X if it is very close to the edges.
Case 1: If the small circle is in the range of the larger circle and is very close to the edge of the large circle by 0.03, then the result should be X. What I mean is the distance between the smaller circle edge and larger circle edge should range from 0 to 0.03. So far I was able to...Leave a comment:
-
I don't understand what you mean by a and b? I want to write IF conditional statements for the two cases. I have already written for one case that is if the sensor (small circle) is close to the edge of the larger circle by 0.01 from the inside, then that will be identified as X. This if my IF conditional statement. Please feel free to correct me
IF(0<=ABS(SQRT( (X2-X1)^2+(Y2-Y1)^2) - ABS(R2-R1))<=0.01) THEN RETURN X
...Leave a comment:
-
Shape coordinates logic
Hi,
I have a sensor in the shape of a small circle and a hole which is larger than the sensor circle. Basically i have a small circle and a large circle. Now i would like to check these conditions:
(1) IF the small circle is in the range of the large circle, then the result should be 0.
(2) IF the small circle is not in the range of the large circle, the result should be 1.
(3) IF the small... -
Shape coordinates logic
Hi,
I have a sensor in the shape of a small circle and a hole which is larger than the sensor circle. Basically i have a small circle and a large circle. Now i would like to check these conditions:
(1) IF the small circle is in the range of the large circle, then the result should be 0.
(2) IF the small circle is not in the range of the large circle, the result should be 1.
(3) IF the small...
No activity results to display
Leave a comment: