Search results

I'm using MS Access 2010 and I have a bunch of Send Object emails that reference tables and queries and sometimes the attachments contain no data. If "no data" record count=0, I would like to send the email attachment, but in the subject line indicate some additional text indicating "no...

After removing the ellipsis it still stops the macro after the condition of DCount("*","EPICtraining_Transfer_List")>0 then Send Object action Thinking the receipient of the report can learn to deal with a blank report. Not sure how critical this is.

Thanks Paul, I removed the ellipsis.

Thanks Paul, I did remove the ellipsis.

Thank you for your assistance, I have Access 2000 and it does not appear that I have the OnError action within my macro action drop down list, need to upgrade, lol Any other suggestions i might try? Thanks again!!

Thank you for your quick reply! After the DCount condition>0 then send object my next condition is Condition Action ... Open Query I tried the ellipsis (...) in the condition line below the Dcount but it's not allowing me to continue with my macro.

The DCount in my Macro conditions works great in that the SendObject works if the count of the query or table >0, if the query or table =0 however I want the macro to continue to the next macro action, it seems to be stopping macro if dcount=0. How do I get it to continue... My conditon...

Paul, makes sense now, sorry to be so dense! It works perfectly now, if query count is null then it does not send email which is exactly what I was hoping for. Thanks again

Thanks, I included the conditional format within my macro, but I'm not sure of the syntax, here is what I have - If DCount("*","qry_audit_emp_demo")>0 Then "DoCmd.SendObject", End If) Thank you for your help!

Thank you for your assistance! I performed a DCount off my query, although I'm not sure I did it right or understand reason why. Here's what my DCount expression looks like: Count: DCount("EMPLOYEE","qry_audit_emp_demo") The query is called: qry_audit_emp_demo and I chose to count the...

I have MS Access macros that emails information from tables and queries as attachments. Sometimes the data is blank, do you know of any options in which I can prevent the send object from sending the email attachments if the data is null? Thank you!

Worked great, thank you so much for your help!!!

I have a field called "F1", below is an example of what one of the rows looks like. In MS Access query I want to parse out field "F1" into 2 different columns in my MS Access query. Column 1 the email name, the field is divided by the left and right arrows. Column 2 everything before the left...

Is it possible to perform a make table query that includes the date in the table name without having to type in the date? For example if the current make table name makes tbl EMPLOYEES, can I have it include the date like: "EMPLOYEES 2012-04-20" Each time I run the make table I want the...

It works!! Thanks so much!! You da' man.

Thanks once again! I copied the expression exactly as you have it, and retrieved 7:37 with the colon included. The query pulls 7:37 for all records, how do I get it to reflect the actual start time? Here's what I have in the query expression so far: start_time2: CDate(Mid("0737",1,2) & ":"...

Paul, sorry to be dense, still learning Access, but it sounds like you want me to try the ?cdate("16:30") 4:30:00 PM Can you help me with the expression for my field "start_time", I'm not sure how I should enter it. Thanks again!

I'll send you just rain.... in exchange for some sun, sounds like a fair exchange :)

Paul, thank you for your reply. The field "start_time" is a text field in the table - here's an example of what it looks like: "0737 " I noticed that the field has some blank spaces after 0737 that I might need to trim? Just trying to convert this to a time format like 07:37. Your...

Paul, I would be more than happy to send all this rain and wind to you, I'm more than tired of it already :)