Visual Basic, ???????? GURUS - Showing or Loading Forms by use of String variable containing Form Name

???????? GURUS - Showing or Loading Forms by use of String variable containing Form Name

Author	Message
mikeb.. #1 / 5	???????? GURUS - Showing or Loading Forms by use of String variable containing Form Name In Access you can open a Form by using a String variable that contains the Form Name. The basic syntax is as follows: DoCmd.OpenForm formname where formname is a String expression. Can string variables be used in a similar manner in VB5? TIA, Regards, Michael.
Mon, 31 Jan 2000 03:00:00 GMT

H Ho #2 / 5	???????? GURUS - Showing or Loading Forms by use of String variable containing Form Name You could possibly use VB's forms collection like this: Forms("frmNameHere").Visible=True I haven't tested it since this machine does not have VB installed. My guess is the form must already be loaded (so that it is already a member of the forms collection) and hidden. Try it out. Ho Quote: > In Access you can open a Form by using a String variable that contains > the Form Name. The basic syntax is as follows: > DoCmd.OpenForm formname > where formname is a String expression. > Can string variables be used in a similar manner in VB5? > TIA, Regards, Michael.
Mon, 31 Jan 2000 03:00:00 GMT

mikeb.. #3 / 5	???????? GURUS - Showing or Loading Forms by use of String variable containing Form Name Quote: >In Access you can open a Form by using a String variable that contains >the Form Name. The basic syntax is as follows: > DoCmd.OpenForm formname >where formname is a String expression. >Can string variables be used in a similar manner in VB5? P.S. I want to show unloaded forms!! Quote: >TIA, Regards, Michael.
Tue, 01 Feb 2000 03:00:00 GMT

Craig Johnso #4 / 5	???????? GURUS - Showing or Loading Forms by use of String variable containing Form Name I'd like to know the answer to this one also. Anybody out there know it?? This could save alot of resources for me if I could use the form strings when I need them. Thanks, Craig Johnson Quote: > In Access you can open a Form by using a String variable that contains > the Form Name. The basic syntax is as follows: > DoCmd.OpenForm formname > where formname is a String expression. > Can string variables be used in a similar manner in VB5? > TIA, Regards, Michael.
Fri, 04 Feb 2000 03:00:00 GMT

Mike Zarzyc #5 / 5	???????? GURUS - Showing or Loading Forms by use of String variable containing Form Name Quote: >I'd like to know the answer to this one also. Anybody out there know it?? >This could save alot of resources for me if I could use the form strings >when I need them. >Thanks, >Craig Johnson >> In Access you can open a Form by using a String variable that contains >> the Form Name. The basic syntax is as follows: >> DoCmd.OpenForm formname >> where formname is a String expression. >> Can string variables be used in a similar manner in VB5? >> TIA, Regards, Michael. This is a kluge, but if the form is loaded, you can loop through the forms collection, comparing the current Form.Name to the value in the variable, then showing it when true. This worked in a little test I ran. R, Mike
Fri, 04 Feb 2000 03:00:00 GMT

Page 1 of 1

[ 5 post ]