Search results

I have this below in which I'm missing the right syntax. I get 'external name not defined' error where I have tried to define Email_Date on the 2nd line. Thanks Sub EmailSent() If [Tables!Table_Date.Table.Email_Date] <> Date Then [Tables!Table_Date.Table.Email_Date] = Date Result = SendEMail()...

Hi, I have a button that when clicked sends emails to people who have had records added to the database that day for their attention. I don't want people to click it twice so I need some alert that tells people that the button has been click ie it turns red for the remainder of the day? Thanks

Hi, I have a module that uses a query to get a list of email addresses from a table. Just running the query returns the email address - great. However the module uses the record ID of email address when placing it in the 'to' field in Outlook - so I just get a number there when i need an email...

Hi, I have this code DoCmd.SendObject _ , _ , _ , _ emailaddress@domain.org, _ , _ , _ "This is the subject", _ "This is the message to you", _ This is triggered on a button press on a form. The email needs to go to a person on the particular record...

Hi, I have a form which will list all records relevant to the user selected from a list. Multiple records are displayed at one time in a list view. I have an after update expression on one field whereby if it is not null then two subsequent fields are disabled to prevent them from being...

Hi, apologies for over using this great forum the last few days.... I want to disable or lock fields on a form should a checkbox be true. I am just trying this out on the next field after the checkbox so far and have - If Not IsNull (Me.Check136) Then Me.Passed_to.Enabled = False Else...

Hi, I have a checkbox and a date field. I want an expression (after update on the checkbox I guess) where if the checkbox is true then the date field should be set to null. Something like If [checkbox] = true then [response_date] = null I'm still trying to learn the syntax. Any help much...

Hi, I guess there is something simple I'm missing here but can't find how to prevent the count on a report from repeating after ever record in the report. I have a text box below the feilds. In properties>data>control source I have =Count(*) The count is good but it repeats after every record...

Hi, I have a form and I need to be able to filter it from the selection of a drop down list on the form. I don't what it to filter automatically once a selection is made from the list but I need it to filter on button press using the selection from the list and to only show records that include...

Hi, I'm trying to use an expression in conditional formatting on a date field. I want the date to turn red if it is more than 18 workdays older than today's date (now). I'm using DateDiff("d",[Date_Received],[Now()]) > 18 Not working though Thanks

Hi, I'm trying to build a query to generate a report based on the difference between two dates being greater than 5 days. On the query setting the criteria for the "date_acknowedged" field I'm trying to write a statement that says if it is 5 days greater than the "date_received" field. Something...

Hi have been trying all day to do this simple task. I want to filter a form to show records that have a certain date field blank. I'm using a query (as a macro does not seem to like Is Null or Null or any other syntax of Null in relation to a date). I have linked the query to a button, but on...