Solved Email .HTMLBody to include totals from other Modules or Queries?

theDBguy said:
Okay, I just read through the posts. Are those two separate procedures populating an open form? If so, you should be able to refer to their values from your code by using a form reference. For example:
Code: 
& "Total QTY of Edges: <U>" & Forms!FormName.WSToEd.Value & "</U><br>" _
Hope that helps...
Click to expand...
Great, I will try later tonight as soon I can and report back. TY soo much
 
theDBguy said:
Okay, I just read through the posts. Are those two separate procedures populating an open form? If so, you should be able to refer to their values from your code by using a form reference. For example:
Code: 
& "Total QTY of Edges: <U>" & Forms!FormName.WSToEd.Value & "</U><br>" _
Hope that helps...
Click to expand...
I tried it but didnt worked. Do you think I may need to add a DIM as RecordSet?
It gave me an Error to debug

Ohhh also, these values are coming from a Closed form.
Maybe using the VBA posted at the beginning of the thread as reference will be a better approached? Since the VBA is getting values from a query. IDK :(
 
Last edited:
theDBguy said:
What was the error message?
Click to expand...
Edit: This error happened because I had that form opened in Design View.
Discard this post, Next post is correct

1640795225679.png


1640795310618.png
 
Last edited:
TecknoFreak said:
OMG God guys!!
That's it, thats the problem..

So I created the email report with the Forms Opened and @theDBguy code works perfect but Only works with Open Form not Closed

View attachment 97212
Click to expand...
Unfortunately, you cannot pull any data from a closed form. So, yeah, if you want to pull the information from a form, it has to be open. Otherwise, you can try to pull it from the source table instead. Cheers!
 
theDBguy said:
Unfortunately, you cannot pull any data from a closed form. So, yeah, if you want to pull the information from a form, it has to be open. Otherwise, you can try to pull it from the source table instead. Cheers!
Click to expand...
Ok, thanks sooo much mate... I will dig into that to see what I come up to.
Should I post here if I make it work that way even though is not related to the thread title? @theDBguy
 
TecknoFreak said:
Ok, thanks sooo much mate... I will dig into that to see what I come up to.
Should I post here if I make it work that way even though is not related to the thread title? @theDBguy
Click to expand...
If only to tell us you got it to work another way, it's okay to post here. However, if it was to ask a question about another approach, maybe it's better to start a new thread. Good luck!
 
I was thinking,
Is it possible to have those 2 Forms open in the background (Hidden) once you open the database front end?
 
TecknoFreak said:
as a new tab but never actually open it because I run the report from a Dashboard button that populate the Report and a Form with a Click.
Click to expand...
Not sure what you mean by "a new tab," but if you're using a Click to open the report that needs the form as well, then you should be able to add code to open the form as hidden first, before opening the report.
 
theDBguy said:
Not sure what you mean by "a new tab,"
Click to expand...
By that, I mean, I was hoping you would tell me you double-click on the form's name on the Navigation Pane, or you click on a button from your menu form, etc.
 
You must log in or register to reply here.

Similar threads

T
Hiding HTMLBody table rows if values are 0
Replies
3
Views
1,125
plog
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom