Search results

Hello mate, One more question Based on that amazing code you created for me I was able to stylish the email body just a bit and looks amazing. "Total QTY of RF Edges: <U><font color=""green"">" & Forms!F_IAAIMSWeeklyReport.WSToEd.Value & "</font></U><br>" _ I was wondering if in VBA there is a...

No thank you. You saved me from 2 problems I had. Amazing community. Will do the best to also be part of it and help as I can same way you guys came to help me.

Wow thank you @theDBguy , @Gasman for all the ideas. I finely found a very easy solution and that was making a Macro as below. (Thanks to theDBGuy for the code) Now the email populates perfectly. Cant believe I could go this route. in Access.

Was wondering if there is a way to DoCmd.OpenForm and DoCmd.Close acForm after getting values for the email body show previous post

@theDBguy With your working code you provided me earlier as & "Total QTY of Edges: <U>" & Forms!F_IAAIMSWeeklyReport.WSToEd.Value & "</U><br>" _ Is there a way to do this? DoCmd.OpenForm "F_IAAIMSWeeklyReport", acNormal, , , acHidden ????????????? DoCmd.Close acForm "F_IAAIMSWeeklyReport"...

Im sooo sorry. Im so new to this that I dont even know how to explain my problem correctly :cry:

I created a form based on a report as I rather show the form and not the report to the rest of the db users. But all is populated based on a Report that is populated as Closed using a query for each of the 2 Reports. The Report just Open as hidden to populate the Report data and then Closed once...

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.

I was thinking, Is it possible to have those 2 Forms open in the background (Hidden) once you open the database front end?

Also, thanks sooo much for your time @Gasman

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

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

Ohh wait, I had that form opened in Design View here is the error I get

Edit: This error happened because I had that form opened in Design View. Discard this post, Next post is correct

The one you gave me

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...

Great, I will try later tonight as soon I can and report back. TY soo much

@theDBguy You think you can help me with this petition please?

Thank you soooooo much!!

OMG OMG!!!!!!!!!!! It worked, IT WORKED!!!!!!!!!!!!!!!! :eek::love::love::love::love::love::love: