Solved

report problem

Posted on 2002-07-09
11
130 Views
Last Modified: 2010-05-02
i am having 5 forms with many textboxes

i can enter the data in the textbox or i won't enter the textbox.

i need the report of what i have typed in the textbox with its label.

note: I will enter only 2 datas in the in the 1st form
   i Will enter 3 datas in the second form.

i have to get the printout of the 5 textboxes with its label.


thank u
please reply me very soon
0
Comment
Question by:vjey
  • 4
  • 4
  • 2
  • +1
11 Comments
 
LVL 43

Accepted Solution

by:
TimCottee earned 100 total points
Comment Utility
Try this:

Dim frmToScan As Form
Dim ctrlToCheck As Control
For Each frmToScan In Forms
  For Each txtToCheck In frmToScan.Controls
    If TypeOf ctrlToCheck Is TextBox Then
      If ctrlToCheck.Text <> "" Then
         Debug.Print ctrlToCheck.Name & " Has a value of " & ctrlToCheck.Text
      End If
    End If
  Next
Next

This will scan all forms for all textboxes and print the name and value, you can then store this information wherever you like.
0
 
LVL 45

Expert Comment

by:aikimark
Comment Utility
TimCottee,

You have a typo:
For Each txtToCheck In frmToScan.Controls

should be
For Each ctrlToCheck In frmToScan.Controls
0
 
LVL 43

Expert Comment

by:TimCottee
Comment Utility
Thanks aikimark, always the same when you just type a response without testing it out.
0
 
LVL 45

Expert Comment

by:aikimark
Comment Utility
TimCottee,

Glad I could help.  You were up awfully early answering questions.  I guess the early bird really does get the (points) worm.  Glad I could help.  It's happened to me as well.

====================================================
vjey,

Points to TimCottee.
0
 
LVL 43

Expert Comment

by:TimCottee
Comment Utility
Not so early here in the UK
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 45

Expert Comment

by:aikimark
Comment Utility
Hey!  That's not fair.  You're cheating. :-)
(only kidding)
0
 
LVL 43

Expert Comment

by:TimCottee
Comment Utility
I know the feeling though, especially when I start off in the morning and all the juicy questions have already been pretty much answered by those on the other side of the world. I have to wait a little while usually until the east coast comes on-line as the bulk of questions still come from north america.
0
 
LVL 45

Expert Comment

by:aikimark
Comment Utility
We are a clueless lot, aren't we?

Your advantage is that you've had enough liquid caffeine that you are fully alert by the time the east coast starts asking questions.  Us east coast experts are working in a fog initially.
0
 
LVL 49

Expert Comment

by:DanRollins
Comment Utility
West Coast volunteers are in a continual fog....
0
 
LVL 49

Expert Comment

by:DanRollins
Comment Utility
Hi vjey,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept TimCottee's comment(s) as an answer.

vjey, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0
 
LVL 1

Expert Comment

by:Computer101
Comment Utility
Comment from expert accepted as answer

Computer101
E-E Admin
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

763 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now