Recent content by MiscAlma

How do I Set up the Auto Email to Send email Only once per day everyday for the whole Company and it does not matter who many people have MS access open.

I meant that The email it sent only once per day. And what I meant I know how to set up everything. I was refering to the EmailDatabase Object what is generated by Access

I Apologize I want it sent once per day thank you for your response

I know how to set up the Auto report and everything but here is my problem Since over 40 people use Access how Can I Limit the Entire System to only Send email a day and not 1 Per Open MS Access?

How can i accomplish such a Task?

I am wondering if i can set the control source for a sub-form to be dependent on a field within a Table So example Part 1 has Field City is City Z so the Sub-form Control Source is Is form.CityZ part 2 has Field City is City X so the Sub-form Control Source is form.CityX and the subform that...

Thank you very much I found out about the email macro but I wanted the three reports to be send together!

I want a button to be able to able to run 3 different queries (Already Done) After that copy the tables and put the tables in a ms outlook email Ready to be send is all this possible from 1 button?

I decided to take your advice and i Just jumped into the code and kept experimenting with it until i got it to work. Its displaying information from another query But Ill manage to get it to work. I appreciate your professional Advice

Private Sub Command90_Click() Date1 = "#" & Now - 200 & "#" Date2 = "#" & Now & "#" StartDate = "#" & Text0.Value & "#" If StartDate = "##" Then GoTo ErrorMsg If Text2.Value = Null Then GoTo ErrorMsg EndDate = "#" & Text2.Value & "#" If EndDate = "##" Then GoTo...

I need help trying to get a certain query to run only after I put a start and End Date and only if i press the complete KPI button and the query is the one at the bottom and I was wondering how to do I manage it? SELECT Sum(qrySLBU12Hours.APPLIED_RESOURCE_UNITS) AS...