Greetings,
I have seen different ideas on how to terminate active processes (i.e., MS Access, Excel, etc) from VB6 - what is the most effecient method of finding and terminating active processes?
Thanks for the help..
mark
markryan57
Last Activity: Oct 16 '07, 05:44 PM
Joined: Feb 8 '07
Location: North Carolina
-
Displaying and Terminating Active Processes
-
Yes agreed,
I am looking into flexgrid now, what I have thus far will work temporarily, I just need to find a flexgrid solution before too long...
thanks so much for your time
Mark -
The labels for each run are laid out in a grid format
Client Date Step1 Step2 Step3 Step4 .......
XXX xx/xx/xx * * * *
this is the basic layout of the data once the code has run. the headers across are constant, the amount of clients going down is not unlimited however it could range from just 5 or 6 to 30 - 40, but never more than that.
...Leave a comment:
-
Sorry I was trying to not clog up the screen with the code, here it is the entire routine. Yes the number of labels will or could change each time based on how many cllients are put in by each analyst.
The method below is where I actually went into the status form and created labels (in a control array) for each one (a pain). The parts that are commented out are the new method of dynamically creating the labels.
sorry...Leave a comment:
-
Thanks for the prompt response, yes I let off several steps below just for brevity sake. What I am trying to do is place labels on a form, poplate their caption with a database recordset, then open the form to display the status results.
Sorry - looking at it, I did not make that terribly clear eh?
thanks
MarkLeave a comment:
-
Dynamic Labels in a new form
Greetings,
I searched for this, but cannot find exaclty what I am looking for. I am trying to dynamically create labels on a form just before it opens. I am reading from a database, building the labels then opening the form.
Currently I have put the labels (in a control array) on the form I want to receive the variables. Then I create a loop to read in the db and build the labels, then open the form.
I have... -
I agree, I am not happy, but content for the moment - one extra step for the user is not too bad of a trade-off based on what they were doing.
Thanks for your support Neo.
mark...Leave a comment:
-
Okay folks i found a way around the problem, just for information purposes. I put a msgbox in and checked the return code for a 1 then did the objAccess.Quit if they select OK.
...Code:Dim objAccess As Object Set objAccess = CreateObject("Access.Application") objAccess.OpenCurrentDatabase "pathtodatabase", True objAccess.Visible = True lblMessageArea.ForeColorLeave a comment:
-
My bad, Yes I have tried (in desperation) both ways, i.e., with objAccess in front and without. I see the reasoning behind, just can't get over that hump - thanks Mary, sorry ADezii - a blonde moment...Leave a comment:
-
Adezil,
if you mean did I close the Access application once done, yes I do. Do I close the Access App from VB, no. If I put in the objAccess.quit in the Access app it really never opens, as VB has control all the time.
What I am trying to learn through research is how can I open an instance of Access (and work within it) and release VB's control over Access.
Thanks Adezil,
Kindest Regards,...Leave a comment:
-
Hey Neo, Yes I did see that. The program would not run at all unless that was in the project references. Thanks friend
you da man!...Leave a comment:
-
Thank you Mary for your help on this. It will remain an open issue I think until I am able to look into how access and vb work together using opencurrentdata base.
I will let everyone know if and when a solution is found..
kindest regards,
markLeave a comment:
-
cpestrella
What I do with those is:
Destfields = FieldName1 & "," & "," & Fieldname2 & "," & Fieldname3
If each Fieldname is a variable don't put in quotes. if not a variable then do put in quotes.Leave a comment:
-
Mary,
I plugged in the code changes you sent also (sorry didn't mention that earlier), I get the error message "Active X component can't create object". I opened the project references to see it I had the MS ActiveX Data Objects Recordset Lib and I do.
Sorry - I don't want you folks to spend much more time on this, you have been so helpful up till now.
thank you for your help thus far.
...Leave a comment:
-
Thank you Neo for the CODE tag explanation. I will do that from this point forward.
Mary,
Um (scratching head) - I did plug in the objAccess.Quit code you sent, it does what I suspected it would. It closes the application before it opens. I am going to assume that VB stays in control of Access no matter what Access does.
I will look further into the opencurrentdata base object - I think I need to find out...Leave a comment:
-
Mary,
Thank you so much for the response. I think I may have tried that approach also, but it closed the access db connection before I was able to use it. I will try it tomorrow morning when I get to the office.
If it works I will owe you one.
thank you once again,
Kindest Regards,
markLeave a comment:
-
Yes Neo, thank you for your reply also. I use foldername twice because the folder names are L:\?????\????\m ark\mark'sfolde r\???? I use foldername twice to get to the exact folder name. If you notice the second foldername variable has an 's next to it.
Neo you also asked me to use code tags when I post. I am not sure what that means.. (sorry) new to this. Can you explain further?
Thank you so much for your help....Leave a comment:
-
Mary, et. el.,
Here is the code I use for the first instance.
=============== =============== ============
...Code:Private Sub cmdStep1_Click() If cboSelectName.Text <> "" Then FolderName = cboSelectName.Text Dim objAccess As Object Set objAccess = CreateObject("Access.Application") OpenCurrentDatabase "L:\GROUPS\PROJECTS\PODSLeave a comment:
-
One more thing Killer I am using Opencurrentdata base to open the Access DB. I am also trying to not use access but do the many queries they have from within the VB app....Leave a comment:
-
Sorry it is VB6 - and the second instance does not open when launched from the VB6 application. When I look at currently running apps (doing Ctrl - Alt - Del) I see the first instance open. (this is while the VB app is still running).
Thank you for any help you might offer....Leave a comment:
No activity results to display
Leave a comment: