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.