Recent content by vyper78

Hi I've got two sets of data that I'm attempting to run some statistical analysis on. Col A contains different capacities of truck and Col B contains the rates at which they were loaded. I'm attempting to group the capacities into groups of 4, i.e: 0-1 tonne, 1-2 tonne, etc, and getting an...

I'm not too sure that a lost focus event is the way to go - I'm doing something similar with my application and don't want the child to disappear just because the user clicked on the menu. Instead, when you are going to open a new form, unload all forms in current view first, then go ahead and...

Thanks for the suggestion AMACycle, however, this didn't work .. keeps coming up with the same error. Is it essential that a child form gets "unloaded" while the parent is still running? Is it taking up a lot of resources?

thank god for that - I was going to dred having to go through the code to remove all the "opens" and "closes". Thankyou for the response. V.

I'm hoping a discussion can be started on the following situation that I face in my program. Many times throughout my program, I need to query the database for whatever reason. Each time I do this, I open a new connection and after I get the results, close the connection. Are all these open...

I've recently changed my command buttons over to Extended Command Buttons, however now I get an "Client Site not Found" error when I attempt to unload the form. Private sub cancel_click() Hide me Unload me <-- no error when this line is commented out end sub Is it neccessary to...

Hi I'm wondering if anyone out there has actually used the vbAccelerator toolbar thing before. I seem to be having issues findout out how to hide some parts of the menu. IE: at start before login, disable the good stuff till they log on. The only thing i can find is to disable the top level...

Thanks everyone for their replies .. I did manage to create an installer using the PDW however I'm sure it attempted to register something (third party?) that didn't need to be registered as it did show an error on installation. However, after ignoring this it installed fine and ran ok. I will...

Hi I've recently made my program into an exe ready for deployment, and was wondering the best way to actually do this. For example, what program do I need that will create the overall exe that will install my program in the right directory and register any "external" files that I have used? Are...

guys I currently use setParent to show an MDI Child in a "pop-up" form - however after I open it, I can't exit the program correctly or open other forms and it crashes (memory error). I was just wondering if I have to reverse the setParent command to release memory or something when I close...

Hi Sheco Basically, when the child is opened viathe MDI main form, open it as you would an MDI child; however, when opened via another form, open it modally. The reason for this is that all of my forms do not have borders, so they appear "part" of the mdi main form. Hope this helps V.

Guys I've got an MDI app which has several MDI children. Two of the children are interrelated (ie: can open each other via button) and transfer info from/to each other ... but I would like them to open like a popup. Is there someway to emulate this in any fashion? I guess what I could do is...

Thanks to jjames and BobRhodes .. that fixed the problem. The picture that was in the top right corner is in another picture box. My positioning code was in the forms resize event, not the controls resize event. I altered it so the container resize event called the forms resize event and all is...

Well, you can always call the resize event from your code." This is my issue. HOW do you call the resize event from your code. I've got no problems with the coding to move the picture in the resize event - my problem is when the user clicks on the maximise/minimise/restore buttons. When the...

if date2 holds 07/07/2005 05:37:59 p.m. Set RS = DB.OpenRecordset("Select * From venta Where date1 >= '"& date2 &"' ") ??? Worth a try I guess. V.