Solved

Printing to a hidden form

Posted on 2001-06-21
16
198 Views
Last Modified: 2010-05-02
Hi, I currently have 3 forms. A login form, a main menu, and a form that links off from the main menu. When you login, the login form unloads and then displays the main menu. This is the same for the third form. In the third form, I have three text box's, and a submit button. When the submit button is hit, I would like it to print the three variables to some sort of text box, but to keep that text box hidded. I then want it to give the user the option (some sort os msgbox) of returning to the third form to append futher info to the hidden textbox. If the user chooses not to, i would then want the third form to hide all field and labels, and to display the hidden text box. Thanks.
0
Comment
Question by:choccarlm
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 7
16 Comments
 
LVL 22

Expert Comment

by:CJ_S
ID: 6213626
how far are you yourself with this?

for each c in controls
   c.visible = false
next
hiddentextboxname.visible = true
0
 

Author Comment

by:choccarlm
ID: 6213641
Thanks, that hides and displays what I want perfectly. But I still need it to pass on information onto the hidded textbox from the three fields. How do I do That?

0
 

Author Comment

by:choccarlm
ID: 6213646
I will need it to write to the hidden box first. Then propmt them if they would like to append to this. If yes, then the textbox will remain hidden, until they no longer wish to append to it.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 22

Expert Comment

by:CJ_S
ID: 6213653
writing to the box is done through

hiddentextboxname.text = "newtext"

What kind of fields are the 3 fields? Plain textfields?

hiddentextboxname.text = text1.text & text2.text & text3.text




0
 

Author Comment

by:choccarlm
ID: 6213656
all 3 field will be on seperate lines. They are all plain text, and will all have set text before them.
0
 

Author Comment

by:choccarlm
ID: 6213685
all 3 field will be on seperate lines. They are all plain text, and will all have set text before them.
0
 
LVL 22

Expert Comment

by:CJ_S
ID: 6213715
hiddentextboxname.text = text1.text & vbcrlf & text2.text & vbcrlf & text3.text

??

can you be more clear in what you want?
0
 

Author Comment

by:choccarlm
ID: 6213753
I want it to append data to a hidden textbox, until the user wishes to stop appending. In this instance, it will display all data that has been entered into the hidden file. Once the "submit" button has been hit, it will first append to the hidden form. It will then ask the user (msgbox,..,vbYesNo,) if they would like to enter any more data (Using the 3 fields). If the answer is yes, it will display the form, and append to the first set of data. It will then prompt the user again and again, until they choose "no". Once they choose no, it will unhide the text box, and display all text within it.

Hope this makes sense. I'm knew to VB and as you can see, im having trouble.
0
 
LVL 22

Expert Comment

by:CJ_S
ID: 6213788
hiddentextboxname.text = hiddentextboxname.text & vbCrLf & text1.text & vbcrlf & text2.text & vbcrlf & text3.text

that will append it
0
 

Author Comment

by:choccarlm
ID: 6213872
I know how to get it to propmt if they wish to append, but how do I know if they hit "yes" or "no" in the msgbox?
0
 

Author Comment

by:choccarlm
ID: 6213998
I have used (msgbox "....", vbYesNo, "......", ). This displays the message box, with the question and 2 buttons (Yes / No), but im not sure how to read the users answers.
Any ideas?

I will award the points on this one.
0
 
LVL 22

Expert Comment

by:CJ_S
ID: 6214081
If (MsgBox("Check", vbYesNo) = vbOK) Then
   
Else
   
end if

Regards,
CJ
0
 
LVL 22

Accepted Solution

by:
CJ_S earned 100 total points
ID: 6214083
Can I post it as my answer? :-/
0
 

Author Comment

by:choccarlm
ID: 6214095
Thanks a lot. That was really helpful. One more small question. How do you select all text within a textbox, and copy it to the clipboard?

Thanks
0
 
LVL 22

Expert Comment

by:CJ_S
ID: 6214130
I'm sorry, but that hasn't been mentioned in the question you wrote above. If you would';ve given me an A I probably would';ve given you the code...but not for a B. I'm sorry...
0
 

Author Comment

by:choccarlm
ID: 6214148
No Probs.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
String manipulation in Visual Basic 7 82
MsgBox 2 61
Help with retrieving partial value from a column using VB.NET 4 53
Assign a value in Excel V-Basic 3 28
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question