E-mail options

  • Thread starter Thread starter Very Basic User
  • Start date 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?
 
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
 
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...
 
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...
 
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...
 
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
 
Back
Top