Create your own procedure with parmameters to hold the form and textbox you need to update.
IE:
Private Sub (TargetForm as Form, TargetText as TextBox)
Then instead of hardcoding the names you can use TargetForm or TargetText to set the values.
I'm not sure this is what you're looking for, but to set the icon for the exe you can go to the Project-Properties menu and on the Make tab set the Icon property there. You can then create a shortcut to the program which will have the same icon.
If I'm reading this right you should only be able to open one of the subforms (vbModal) at a time from the main form.
The problem then is that you are referencing the other subform when it should not exist and therefore are creating a new instance of it.
Only unload the forms that would...
You would start by creating excel.application, excel.workbook and excel.worksheet objects. Then open or create a new .xls file.
If you want to get the active cell...
row = objWorkSheet.Cells.Row
col = objWorkSheet.Cells.Column
objWorkSheet.Cells(row, col) = "Hello New Value"
or you...
'set project references to PowerPoint and Excel
'create an excel.application object
'create an excel.workbook object
'create an excel.worksheet object
'create an excel.chartobject object
Dim objExcel As Excel.Application
Dim objWork As Excel.Workbook
Dim objSheet As Excel.Worksheet
Dim objGraph...
http://support.microsoft.com/?kbid=302460
This might help you, I've noticed that the paramaters you pass are different from the ones shown in the documentation.
Hello -
I've been able to change the picture file location for an ole object in a crystal report (.rpt) at runtime by changing it in the section format event (using the loadpicture() in visual basic). I'm using VB6 with the CR8.5 crystal reports viewer.
Does anyone know how to achieve the...
Look into the sendmessage api. I believe you can send info to another running application without activating the window. You should be able to find tutorials if you search it on any search engine.
k2w
I have already tried deleting the vbw and obj's with no luck. The project loads fine, it's just when I click on one particular form to get the object view that it gives me the error. The form does not have any different controls than the others but it is the only one that gives the out of...
Hi,
I noticed this problem when I was trying to make an exe. It compiled fine but when it was writing the exe it came up with an out of memory error. When I try to view one form object in the development area by either double clicking it or selecting the view object button in the project...
Hi,
I've got a strange problem. I am trying to set focus to a pdf that my program has started. To set focus I am using showwindow, setforegroundwindow and setactivewindow. Now it does what I ask it to, but it opens the articles window in acrobat (which interferes because I'm then trying to...
Thanks DrJavaJoe,
I had actually read the thread where you discussed this before and was constantly getting errors -- the problem being the form was being shown from a MDIChild (it finally clicked that "Me" should be the parent form). So thanks for your help in both places! A star...
Hi!
I'm trying to select a control on a form while keeping another form on top, but I can't get it to work, the other form gains focus and the other is only displayed in the task bar. Is there anyway to do this?
Thanks for your help.
k2w
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.