Re: Query Only Creent Record?

From: Hulk (green_hulk_at_adelphia.net)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 08:38:20 -0500

Jeff,
    Tried that in the criteria field but it comes up asking for the ID
number to send to E-Mail.
     I may be making more of this then needed, I have five forms: Memos Add,
Memos Active, Orders Active, Memos Completed and Orders Completed. These
are all controlled from a main switchboard, the forms are all the same
except some fields are locked on each and some are not so that data entry by
the user is limited.
     On each form there is a commandd button to exit back to the main
switchboard or to print the current viewed form to a printer. This command
button sends the report called Memos to a printer with just the current
record showing. These buttons work great. The problem is that when I try
to put a button on any form to E-Mail just the current form using a Macro
called Send E-Mail, it sends all the records in the table, ie 26 pages of
reports, to e-mail. I only want to sent the current record that was either
just added or that are currently still open and not completed.
    I tried to build a form called Current Form and a report called Current
Mermo with a query that only calls up the current record that is showing and
then have the command button on the Current Form to E-mail just that form
with the Send E-mail Macro, but it doesn't update until the Memo Add form is
closed and so it sends a blank report. I really don't need all the extra
forms, reports and macros but I can't get the Send E-mail to send only the
current form.
     I tried using the formula you gave me, but it asks for a ID to send and
even then it won't send the current form if you haven't closed the Memos Add
form.

Hope this explains the problem some, any help or questions??

Thank
Bill
"Jeff Boyce" <JeffBoyce_IF@msn.com-DISCARD_HYPHEN_TO_END> wrote in message
news:u$Y4nau$EHA.1188@tk2msftngp13.phx.gbl...
> Bill
>
> I'm a bit unclear still...
>
> Your description said, roughly, "it didn't work". That isn't much to go
> on
> in helping you troubleshoot.
>
> You have a table that has multiple rows. You want a way to send what you
> are calling the "current record", apparently based on what is being
> displayed in a form.
>
> I would approach this by building a query that refers to that form's
> record
> ID and returns the field(s) I wanted. Then I'd build a command button
> that
> attached the output of that query to the outgoing email.
>
> For the query, I'd open up the form and select a record, then use the
> database window to create a new query. I'd select the RecordID field and
> ?some other field. Under the RecordID field, in the criterion, I'd add
> something like:
> Forms!YourFormName!YourRecordIDField
> (your syntax may vary). Then I'd run it, to see if the query works.
>
> For the command button, it sounds like you've already set up one that
> works,
> just takes the whole table. What happens if you build the query above and
> then send the query?
>
> You don't mention where the command button is located, but your earlier
> post
> mentioned two forms. I hope the command button is on the form from which
> you wish to send the record.
>
> --
> Good luck
>
> Jeff Boyce
> <Access MVP>
>
> "Hulk" <green_hulk@adelphia.net> wrote in message
> news:Z6mdnY2L7MxRcHPcRVn-rA@adelphia.com...
>> Jeff,
>> I have a table called Memos that the user enters information into
>> only
>> on an add form, when they have added the information I want a query
> command
>> button so that they can e-mail only the information in the current form,
> no
>> others. I build a command button for e-mailing with sendobject but it
> send
>> the whole tabel in forms. I only want to sent the current record.
>> They suggested way to build a command button but it had many lines
>> of
>> code and it didn't work. I have tried and tried but building a query to
>> show only the current record which had just been added seems like a way
>> around the problem. It hasn't happen. The table has an autonumber which
> it
>> uses as the ID, the query uses the information from the main table of
>> "memos" and with the ID as a reference I want to show that information in
> a
>> form called "current form" which will have a command button on it to
> e-mail
>> just the current form. I can't make it to simple, and code just doesn't
>> seem to work, I'm just a novice.
>>
>> Thanks
>> Bill
>> "Jeff Boyce" <JeffBoyce_IF@msn.com-DISCARD_HYPHEN_TO_END> wrote in
>> message
>> news:uy86u2K$EHA.2608@TK2MSFTNGP10.phx.gbl...
>> > Bill
>> >
>> > Why?
>> >
>> > You've described "how". Perhaps the 'group readers can offer you an
>> > alternate approach if you explain what problem you are trying to solve
> by
>> > passing information to a second form...
>> >
>> > --
>> > Good luck
>> >
>> > Jeff Boyce
>> > <Access MVP>
>> >
>> > "Hulk" <green_hulk@adelphia.net> wrote in message
>> > news:Huudndz0SqbFSnbcRVn-hQ@adelphia.com...
>> >> Is there a way to put build a query to accept only the current record
>> >> from
>> >> another form? I want to use the autonumber to show only the record
>> > showing
>> >> on the screen and need to build a query to pass that information into
>> >> another form.
>> >>
>> >> Thanks
>> >> Bill
>> >>
>> >>
>> >
>>
>>
>