Add signature to report

[Guest]

I'm trying to add a signature to a report.

A form has a subform and a command button. The user picks from the subform
clicks this command button and the report is displayed. (This works fine)

stDocName = "rptThankYou"
stLinkCriteria = "[ICNNo]='" & Me![ICNNo] & _
"' AND [ProvNo] = '" & Me!f_ProvSub!ProvNo & "'"
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

I'm trying to add a value for a signature..
I have added a combo box (Signature) which has the row source liked to the
signature table.

My question is - How can I add the signature to the report?
The report is made from a query, the signature table is not, part of the
query!

THe code below shows my attempt - but the [Signature] does not exist - I
understand that but I'm trying to figure out a way to allow the user to pick
from the combo box for the signature..

stLinkCriteria = "[ICNNo]='" & Me![ICNNo] & _
"' AND [ProvNo] = '" & Me!f_ProvSub!ProvNo & "'" AND [Signature] = '" &
Me![Signature]& "'"

 

[Boyd Trimmell aka Hi Tech Coach via AccessMonster.]

I'm trying to add a value for a signature..

I have added a combo box (Signature) which has the row source liked to the
signature table.

Is the combo box bound to a field in the table? It it was, it would solve
your problem. Then you do not need it in the criteria, just use a join the
SQL.

If it is unbound, then I would not use it in your criteria. I would just use
a reference to the form form the report.

Hope this helps ...

I'm trying to add a signature to a report.

A form has a subform and a command button. The user picks from the subform
clicks this command button and the report is displayed. (This works fine)

stDocName = "rptThankYou"
stLinkCriteria = "[ICNNo]='" & Me![ICNNo] & _
"' AND [ProvNo] = '" & Me!f_ProvSub!ProvNo & "'"
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

I'm trying to add a value for a signature..
I have added a combo box (Signature) which has the row source liked to the
signature table.

My question is - How can I add the signature to the report?
The report is made from a query, the signature table is not, part of the
query!

THe code below shows my attempt - but the [Signature] does not exist - I
understand that but I'm trying to figure out a way to allow the user to pick
from the combo box for the signature..

stLinkCriteria = "[ICNNo]='" & Me![ICNNo] & _
"' AND [ProvNo] = '" & Me!f_ProvSub!ProvNo & "'" AND [Signature] = '" &
Me![Signature]& "'"

 

[Dan @BCBS]

The combo box is bound to a table but that table is not included in the query
that creates the report! that is the issue!!

1. I have a form (Report Menu)
2. The form has a submenu
3. The form has a command button
4. The form has combo box

Currently, this code from the command button allows the user to pick from
the list in the subform.

Now, it needs to allow the user to also pick from the combo box.
Note - my first comment - this table is not linked to the tables/query that
creates the report!

How can this signature become part of the report based on the choice the
user makes from the combo box?

stLinkCriteria = "[ICNNo]='" & Me![ICNNo] & _
"' AND [ProvNo] = '" & Me!f_ProvSub!ProvNo & "'"

DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

Exit_cmdPrint_Click:


The table that the combo box is created from does not have a field to link
it, it's just doctors signatures, the user can pick any doc from the combo
box and then it needs to be on the report.

That is why I'm trying to carry the users choice in the command button code.
Some how if the command button could capture the two choices the user can
make, then

I'm trying to add a value for a signature..
I have added a combo box (Signature) which has the row source liked to the
signature table.

Is the combo box bound to a field in the table? It it was, it would solve
your problem. Then you do not need it in the criteria, just use a join the
SQL.

If it is unbound, then I would not use it in your criteria. I would just use
a reference to the form form the report.

Hope this helps ...

I'm trying to add a signature to a report.

A form has a subform and a command button. The user picks from the subform
clicks this command button and the report is displayed. (This works fine)

stDocName = "rptThankYou"
stLinkCriteria = "[ICNNo]='" & Me![ICNNo] & _
"' AND [ProvNo] = '" & Me!f_ProvSub!ProvNo & "'"
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

I'm trying to add a value for a signature..
I have added a combo box (Signature) which has the row source liked to the
signature table.

My question is - How can I add the signature to the report?
The report is made from a query, the signature table is not, part of the
query!

THe code below shows my attempt - but the [Signature] does not exist - I
understand that but I'm trying to figure out a way to allow the user to pick
from the combo box for the signature..

stLinkCriteria = "[ICNNo]='" & Me![ICNNo] & _
"' AND [ProvNo] = '" & Me!f_ProvSub!ProvNo & "'" AND [Signature] = '" &
Me![Signature]& "'"

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

Sounds like you combo box is NOT bound ( this is not the same as the row
source from a table) to a field in the table so the data is not being stored
to pass the data to the report.

From my from my first post:
If it is unbound, then I would not use it in your criteria. I would just use
a reference to the form from the report. See:
http://www.mvps.org/access/forms/frm0031.htm


If I were doing this, I would create a child table that has fields to store
the data like user, signature, date printed, etc. This way there is a history
of what signatures have been used. It would also be very easy to make the
report work properly.

The combo box is bound to a table but that table is not included in the query
that creates the report! that is the issue!!

1. I have a form (Report Menu)
2. The form has a submenu
3. The form has a command button
4. The form has combo box

Currently, this code from the command button allows the user to pick from
the list in the subform.

Now, it needs to allow the user to also pick from the combo box.
Note - my first comment - this table is not linked to the tables/query that
creates the report!

How can this signature become part of the report based on the choice the
user makes from the combo box?

stLinkCriteria = "[ICNNo]='" & Me![ICNNo] & _
"' AND [ProvNo] = '" & Me!f_ProvSub!ProvNo & "'"

DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

Exit_cmdPrint_Click:

The table that the combo box is created from does not have a field to link
it, it's just doctors signatures, the user can pick any doc from the combo
box and then it needs to be on the report.

That is why I'm trying to carry the users choice in the command button code.
Some how if the command button could capture the two choices the user can
make, then

I'm trying to add a value for a signature..
I have added a combo box (Signature) which has the row source liked to the [quoted text clipped - 34 lines]
"' AND [ProvNo] = '" & Me!f_ProvSub!ProvNo & "'" AND [Signature] = '" &
Me![Signature]& "'"