Comments by theskiguy (Top 27 by date)

Yes I do. As I mentioned above, I did reprogram it just to make sure. I first removed all suffixes and tested the output in Notepad and noticed there was no tab. I then added the tab suffix to the barcode reader and tested it again in Notepad and I could see the tab added.

If it try it on my original "ChartPage" chart object, I still get the "Unable to set the leftfooter Property" error. If I define a new chart object after moving the chart to a new sheet, then it will work. Everything seems to be working great now.

I was able to figure out how to get the footer on the chart sheet. I just made a new "chart" object after moving the chart to the new sheet using your first example above. For some reason, it would not work with my original chart object "chartpage". Thanks for your help.

Thank you for clearing this up for me. I was unaware that my chart worksheet wasn't an actual worksheet but rather a chart object. I do, however, have another question. The reason why I was trying to create the Worksheet object for the chart was because I wanted access to the page setup so I could add a footer to my chart when someone printed it. I noticed that the "chart" object has its own page setup so I'm thinking I don't really need the worksheet object anymore. I already have a chart object declared in my example called "chartpage", however, when I try to access the page setup, I am getting the following error: "Unable to set the LeftFooter Property of the page setup class"

chartPage.PageSetup.LeftFooter = "Printed On &D &T" 'Add Date/Time

Any suggestions?

Thank you very much. This is very close to what I need. I did make a few minor changes. I only wanted to show only week's work of data so I added another item to the final WHERE clause. Also, I had to change the syntax dealing with the column acronyms for the shifts columns.

My only problem I have now is trying to figure out what to do if I want to display this same week's worth of data for more then 1 machine at a time sorted by machine. If I add the additional machine into the WHERE clause, it creates duplicate results. I guess I could UNION the results for each machine together but with over 50 machines, I am trying to figure out if there is a better way.

From my initial tests, it looks like XMLAGG works but it puts all the values into one column separated by commas. I really need a separate column for each value so I can display in my data grid. Am I missing something?

Sorry but I forgot to mention we are still running Oracle 9. It appears this command requires Oracle 11. I updated my question to add the Oracle 9 requirement.

Your solution works great but I still can't figure out while mine doesn't work. I guess I will have to start a new project from scratch and keep it simple at the start until I figure out the cause.

As a side note I did have a few syntax errors in your example that I had to address so I thought I would bring it to your attention so you could update your code. I had to update the syntax for the "With" statement in your AddToolTip sub. I also had to declare the "Index" variables in mouse_move,Recalc and paint subs. Thanks for your help. If I finally figure out what caused my issue, I will let you know. Thanks.

You are correct. See improved question that now includes some code that show the control painting. As far as Invalidate, the problem I am having is determining the proper time to call it. If I only call invalidate when the mouse is not over the icon, the control will not repaint if I move the mouse to a different position on the icon. If I move the invalidate to the beginning of the mouse move event, my user control completely disappears even if I stop moving the mouse when it is over the icon.

Exactly what I needed. Thanks

I only need to have one instance of the class available, however, I need to have the instance available throughout the project, not just the parent. I don't really think I want to instance the class because the new instance would just be a copy of the original instance. Can you please elaborate on your comment about creating it in a module?

Thank you very much for providing such a nice example. It really helped me understand how everything works. I do have one question. In the example you provided, it is keeping track of the totals every time the AddData sub is called. In my real life example, I am not really interested in the totals, just whether or not any of the values changed. With this in mind, I made some minor changes to the AddData sub to compare the newly added values to the existing values. If all 3 variables are the same, I exit the sub without calling the event because I don't need to update the database. If one or more variables have changed, I then update the class variables to the new results and then continue on and call the event. Is this the best way to handle this or would you recommend some other method? Maybe add a Boolean called DataChanged to the class and eventargs?

Ok, please bear with me, I have never done this before so I need a little guidance. I copied the example you provided in the link and it works but I am having trouble figuring out how this example can be applied to my situation. There are 2 classes in the example, the counter class and the event args class. I assume I would need to change sub new in the counter class to accept the 3 vars I am tracking? Is this where I should also keep track of whether the variables change to work similar to my example above? Then what is the purpose of the event args class?

Peter:

I have never used Property Change Notification before. Can you tell me what is the advantage of using it versus the way I raise the events in my class?

Your solution works but it is basically the same as the first solution. Thanks for you help.

Works great! I was trying something similar to that but I wasn't using the Group by. Thanks for the help.

I am using the Microsoft Excel 14.0 Object library which I believe is correct for Excel 2010? I have also found that my existing code will size and position certain pictures correctly but not others. In Excel 2007 it worked all the time. Don't know what is going on.

Thanks for the info Sergey.
What is your opinion on using the Perfmon tool thats comes with WinXP and Win2000? I've read other articles on this site that say you can find issues by tracking Private Bytes, Working Set and Number of Bytes in all heaps?

I am trying to switch to using a background worker but i'm having difficulties updating the UI. My UI mainly consists of an unbound datagridview and a progress bar. I was previously updating the UI after I post process each file but now I can't do that on my worker thread anymore. Any ideas on how I can update my datagridview using the processchanged event? I found examples on how to update a progress bar but I cant seem to find any on how to update a datagridview.

Thanks,

That worked, I just had to use the Fwlib32.dll rather then the FwLib64.dll in the function call. You must be on a newer controller then the Fanuc F150i. The only issue I got is that the IODBMR1 structure needs to be hard coded to the number of variables you want to read. In the above example, the IODBMR1 structure is set to read 5 variables because it holds 5 IODBMR_data structures. What do I do if i want to read 10 variables one time and 50 variables the next time. Is there a way to code the IODBMR1 structure so it can hold a random amount of IODBMR_data structures?

Thanks,

The structure and the function call are both in a public class called FOCAS1. Sorry I did not include that in my original post.

I also tried adding an unhandled exception event in my application events but I still get the "Sorry for the inconvience error"