Best use of Tab Control on Form

[Raven]

Hi.
I am creating a reporting data dictionary in access and need to know what is
the best method to show query data in my dictionary. The customer wants to
see in this dictionary the record name, fields, criteria and sql of specific
queries based off another program. I have selected to show this data using
the tab control with a separate tab for each. I am using SnagIt to capture
the images, however, each image is a different width, height, etc. In
addition, there are over 50 queries for which I would need to store all of
this information, and from my understanding, storing a large number of
bitmaps in access is not recommended. Any suggestions on how I should show
this data is truly appreciated.

 

[Jeff Boyce]

Raven

If you are using a query to retrieve data, is there a reason you aren't
displaying the query results in a form, rather than as an image?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Raven]

Jeff, I am not providing the query results, I am providing detail information
based on specific queries, ie., Record Name, Fields and Criteria on the
query. I could run a query that would give me this information, but I found
that to be a bit daunting, especially since I cannot write the query using
SQL. So I capture an image of the info on the query display it on the tab
control in my form. Does that help?
--
Thanks.
Raven

Raven

If you are using a query to retrieve data, is there a reason you aren't
displaying the query results in a form, rather than as an image?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Bob Barnes]

I use ListBoxes to display the results of different Queries...on a Tab Control.
Works well.

HTh - Bob

Jeff, I am not providing the query results, I am providing detail information
based on specific queries, ie., Record Name, Fields and Criteria on the
query. I could run a query that would give me this information, but I found
that to be a bit daunting, especially since I cannot write the query using
SQL. So I capture an image of the info on the query display it on the tab
control in my form. Does that help?

 

[Raven]

Hmmm. Not sure how that would work with images. But once again, I am
displaying the detail information of a query, not query results.

 

[Jeff Boyce]

Raven

I don't follow... what specifically do you mean by "the detail information
of a query"? Is that the same as the SQL statement? Is that a screen-shot
of the query design view? How does that differ from the query results?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Raven]

Sorry Jeff, that I am not making myself clear. I have decided use the Meta
Data tables (PSQRYCRITERIA, PSDBFIELD, etc) to capture the query definitions
for my queries. Anyhow, my first approach was to capture an image of the
query's info from the Fields, Criteria and SQL tabs and then insert as image
on the tab control on my form. However, I am unable to resize the images
for an appropriate fit (to much work and the control just expands). So, now
I'll attempt to run an output of the query data using the meta tables and
create a command button on my form to display this info in word doc.
Hopefully, that will be simplistically, better. Don't go to far away,
though. I may need help with that.
Thanks.
Raven

 

[Jeff Boyce]

Feel free to post back to the 'groups ... that's what they're here for.

And feel free to post responses to other folks' questions when you have
ideas how they can resolve their issues. That's how we all got our start
here!

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Raven]

Thanks, Jeff.
Without a doubt! I have found this forum to be very helpful and I truly
appreciate the support. It was a rocky start for me when I initially signed
up...negative feedback amongst supporters of the site. Anyhow, I'm looking
forward to gaining the knowledge and to sharing it as well!!!