E-mail options

  • Thread starter Very Basic User
  • Start date
V

Very Basic User

I currently have a command button that from an Edit form, will open a report
after you answer the question [Enter Record Number] and then convert it to
PDF in a mail. The user currenty has to enter the record # to get the correct
report. In my query I have the command [Enter Record Number] is there a
command line that I could add to the query to open the current record that
I'm on in the form preventing the user from having to enter it manually?
 
S

Steve Schapel

John,

In the Criteria of the query, instead of the [Enter Record Number] parameter
prompt, put a reference to the field in the form, using syntax such as
this...
[Forms]![NameOfForm]![Record Number]

--
Steve Schapel, Microsoft Access MVP


Very Basic User said:
I currently have a command button that from an Edit form, will open a
report
after you answer the question [Enter Record Number] and then convert it to
PDF in a mail. The user currenty has to enter the record # to get the
correct
report. In my query I have the command [Enter Record Number] is there a
command line that I could add to the query to open the current record that
I'm on in the form preventing the user from having to enter it manually?
Click to expand...



__________ Information from ESET Smart Security, version of virus signature database 4120 (20090601) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
G

Guest

Very Basic User said:
I currently have a command button that from an Edit form, will open a
report
after you answer the question [Enter Record Number] and then convert it to
PDF in a mail. The user currenty has to enter the record # to get the
correct
report. In my query I have the command [Enter Record Number] is there a
command line that I could add to the query to open the current record that
I'm on in the form preventing the user from having to enter it manually?
Click to expand...
 
G

Guest

Very Basic User said:
I currently have a command button that from an Edit form, will open a
report
after you answer the question [Enter Record Number] and then convert it to
PDF in a mail. The user currenty has to enter the record # to get the
correct
report. In my query I have the command [Enter Record Number] is there a
command line that I could add to the query to open the current record that
I'm on in the form preventing the user from having to enter it manually?
Click to expand...
 
V

Very Basic User

Hello Steve,

Is there any way to look at multiple forms? For example, I have multiple
forms that basically do the same thing I.E. Long form, short form, edit form,
etc. Can I use a command in the query to look at whatevery form I have open
at that time?
Something like...
[Forms]![name of each form seperated by something?]![Idea Number]
--
Thank you for your time!
John


Steve Schapel said:
John,

In the Criteria of the query, instead of the [Enter Record Number] parameter
prompt, put a reference to the field in the form, using syntax such as
this...
[Forms]![NameOfForm]![Record Number]

--
Steve Schapel, Microsoft Access MVP


Very Basic User said:
I currently have a command button that from an Edit form, will open a
report
after you answer the question [Enter Record Number] and then convert it to
PDF in a mail. The user currenty has to enter the record # to get the
correct
report. In my query I have the command [Enter Record Number] is there a
command line that I could add to the query to open the current record that
I'm on in the form preventing the user from having to enter it manually?
Click to expand...



__________ Information from ESET Smart Security, version of virus signature database 4120 (20090601) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...
 
S

Steve Schapel

John,

No. Not directly the way you have stated it.

It is not clear how you are going about this. If you have a command button
on each of this conglomeration of forms, with a macro or VBA procedure
behind the command button to open the report, then you can use the Where
Condition argument of the OpenReport action/method instead. In that case,
you would not put anything in the criteria of the query that the report is
based on. In VBA, something like this...
DoCmd.OpenReport "NameOfYourReport", acViewPreview, , "[Idea Number] = "
& Me.Idea_Number
(assumes Idea Number is a number!)

--
Steve Schapel, Microsoft Access MVP


Very Basic User said:
Hello Steve,

Is there any way to look at multiple forms? For example, I have multiple
forms that basically do the same thing I.E. Long form, short form, edit
form,
etc. Can I use a command in the query to look at whatevery form I have
open
at that time?
Something like...
[Forms]![name of each form seperated by something?]![Idea Number]
Click to expand...



__________ Information from ESET Smart Security, version of virus signature database 4132 (20090604) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Top