By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,203 Members | 1,392 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,203 IT Pros & Developers. It's quick & easy.

Query forms

P: n/a
Dear colleagues:

I read somewhere that you could obtain the results of a query as a form.

I have design a database for my books and waht I would like is to obtain the
results of my queries (which use parameters for language, author, genre,
etc) in the form of a bunch of the original forms I used for creating the
book entries.

I don't know if I explained the problem correctly. As a result of a query I
would obtain a selecction of the forms that comply with the query criteria.

My queries work beautifully but I am not happy with getting a table with the
results.

If this cannot be done in Access but needs Visual Basic or Visual Basic.NET
it will be okay, since I have both programs and I have a little knowledge of
them. However, at this stage, I would prefer a pure Access (with SQL)
approach.

Thanks in advance.
Luísa Lopes
no******@mail.telepac.pt
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a

I'll explain a little better what I want. I have this database for books.
The information about each book is entered in a form with two other
subforms - I include a lot of stuff.
If I want to know which books have references to, for instance, African
explorations, I would like the query to "choose" the complete forms
containing the books in question and present this subset to me.
If the database was an old index card file, this would be the equivalent of
picking out the relevant cards.
The way things work now I get the results in a table, with only the fields I
picked for the query, and if I want to do anything more, like adding to the
notes section of the form I have to make a note of its ID number and go to
the forms section of the mdb.
I have a feeling that waht I want is not possible. I have tried in several
ways, read a lot on the subject of databases, and found nothing similar.
Maybe something could be attempted in VB or VB.NET but I am trying in Access
(2000) at the moment because I already have most of the work done and little
time in the next months to concentrate on VB.
It is not very important, but it would be very convenient, since I am always
addind and removing stuff form the Notes and Commentaries sections of the
forms.

Thanks for your help. I'll try it, but I don't think it does what I want.

Luísa Lopes

"Chuck Grimsby" <c.*******@worldnet.att.net.invalid> wrote in message
news:ab********************************@4ax.com...

I'm not exactly sure what you are looking for here... If you are just
looking for a list of forms that have a specific name, you can do:

SELECT [Name]
FROM MSysObjects
WHERE Type=-32768 AND
[Name] Like '<whatever>'
ORDER BY [Name];

To get a list of the form names.

Do you need something more complex then that, or ??? Please explain
further.
On Tue, 28 Dec 2004 15:17:01 -0000, "Luisa Lopes"
<no******@mail.telepac.pt> wrote:
I read somewhere that you could obtain the results of a query as a form.
I have design a database for my books and waht I would like is to obtain theresults of my queries (which use parameters for language, author, genre,
etc) in the form of a bunch of the original forms I used for creating the
book entries.
I don't know if I explained the problem correctly. As a result of a query Iwould obtain a selecction of the forms that comply with the query criteria.My queries work beautifully but I am not happy with getting a table with theresults.
If this cannot be done in Access but needs Visual Basic or Visual Basic.NETit will be okay, since I have both programs and I have a little knowledge ofthem. However, at this stage, I would prefer a pure Access (with SQL)
approach.

--
A Dirty Book Is Rarely Dusty.

Nov 13 '05 #2

P: n/a
Luisa Lopes wrote:
I'll explain a little better what I want. I have this database for
books. The information about each book is entered in a form with two
other subforms - I include a lot of stuff.
If I want to know which books have references to, for instance,
African explorations, I would like the query to "choose" the complete
forms containing the books in question and present this subset to me.
If the database was an old index card file, this would be the
equivalent of picking out the relevant cards.
The way things work now I get the results in a table, with only the
fields I picked for the query, and if I want to do anything more,
like adding to the notes section of the form I have to make a note of
its ID number and go to the forms section of the mdb.
I have a feeling that waht I want is not possible. I have tried in
several ways, read a lot on the subject of databases, and found
nothing similar. Maybe something could be attempted in VB or VB.NET
but I am trying in Access (2000) at the moment because I already have
most of the work done and little time in the next months to
concentrate on VB.
It is not very important, but it would be very convenient, since I am
always addind and removing stuff form the Notes and Commentaries
sections of the forms.

Thanks for your help. I'll try it, but I don't think it does what I
want.

Luísa Lopes


Have you looked at the "Filter-By-Form" feature? For searching only, a form
could be based on a query combining all tables and then FBF could be used to
search against it.

It is very possible to do exactly what you're describing, but it is a fairly
advanced task to be able to show a form with subforms and have searches in the
main form be based on criteria in the subforms. While a form based on all three
tables combined would be less elegant it would allow you to to use the built in
FBF feature and would give you a partial solution with no coding at all.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #3

P: n/a

Thank you.

I'll try that. Fortunately I had already planned to rebuild the whole thing.
The problem is that I always want a DB to do a lot of things at the same
time. I am never happy just classifying data under one category, I always
have subcategories and sub-sub-categories. Since I add to these according to
needs, things end up being difficult.

Luísa Lopes

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:33*************@individual.net...

Have you looked at the "Filter-By-Form" feature? For searching only, a form could be based on a query combining all tables and then FBF could be used to search against it.

It is very possible to do exactly what you're describing, but it is a fairly advanced task to be able to show a form with subforms and have searches in the main form be based on criteria in the subforms. While a form based on all three tables combined would be less elegant it would allow you to to use the built in FBF feature and would give you a partial solution with no coding at all.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #4

P: n/a

Thank you.

I have never used Filter by Form, so I'll have to study a little. I have
concentrated my efforts on queries, with no results. Now I'll change tracks
and dedicate my efforts to the forms and this Filter.

Luísa Lopes

"Chuck Grimsby" <c.*******@worldnet.att.net.invalid> wrote in message
news:12********************************@4ax.com...

VB or VB.Net isn't required for this. What I posted won't help
either. When you say "Form" what you seem to be meaning is "Record In
A Form View." And if that's the case, Rick's post is dead on target
for what you want.

Create a form based on the form or query that has all the results that
you want, without doing whatever selections you need. Then use the
"Filter By Form" function within Access to get the specific results
you need. See Access Help on "Filter By Form" for more information.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.