Hi everyone,
I am looking to get a memo field sent via email using a trigger. I have a table, and when a new line is added, a trigger is setup to send an email alerting a few people. There is a memo field in the table that I would like to include in the email, but when I tried to do that, it would not let me.
I did a little bit of research, and it seems that I can't use an Insert trigger for the memo field, but an Instead...
Rmoeller
Last Activity: Feb 19 '17, 05:54 PM
Joined: Jul 18 '15
Location:
-
How do you get a memo field into an email sent by a trigger?
-
I am not sure how to to remove a question once it is answered, but I found another topic on this site that seems to have answered my question with the code I couldn't get to work. So thank you all, its working now!
https://bytes.com/topic/access/answe...l-open-objects... -
Closing all open objects
Hi everyone,
I am using Access 2010. I have a button on my main form that runs data checks for the user after they import their data. It opens up a mixture of queries, forms and reports.
I need a way to close everything that is open, except the main form. I found code on this site that I tried but I couldn't get to work. I found code on another site that works partially. The code successfully closes all of the open... -
Thank you zmbd,
I tried setting the reference control name directly on its own, but that didn't seem to work. I read through the links, but nothing was clicking on that old light bulb....So I stepped away from this for about a week to think about it, and I came up with a work around. I changed the combo box that I wanted populated based on the selection from another combo box to a text box. I then adjusted the query that was the basis...Leave a comment:
-
Appending the value of a listbox
This seems like it should be easy, but I am stuck! I have a listbox in a form that has a single value. This value is based on the results from a combobox in the same form. I want to than take that listbox value and append it to a table, but I keep getting a null error. Looking this up, I need to access the selected property, but that's where I get confused.
The listbox is called txtScientificNa me and is found in a Navigation... -
Hi again Jim,
Thank you so much! Doing those above steps helped me pinpoint the issue with the code. When I hovered over the '& rsLoop!Paramete r &' with the mouse in the above code I posted, I thought it was odd that I couldn't see the first Parameter in the loop. Turns out, the Parameter wasn't being read in the strSQL. Once I saw that in the ACCESS SQL query, I was able to play around with the quotes until I found the right...Leave a comment:
-
Hi again Jim,
I fixed the quotes, a few spacing issues, and added an "insert into" command above the select statement. Now when I call the function, the database looks like its doing something for about 30 seconds, but when it is finished, I check the table, and there is nothing there. I must be missing something....
...Code:Public Function TestLoop() On Error GoTo TestLoop_Err Dim rsLoop As DAO.Recordset
Leave a comment:
-
Hi Jim,
Thank you again for looking at the code. [Replicate Number] is actually a string. [Method] is also a string. I am looking to pull all variations of a method 8270, as the data I am looking to pull can have EPA 8270C, EPA 8270D, EPA 8270D-NCI, EPA8270 (no spaces) etc. Thank you for catching the missing single quotes, I'll add those in.
I have my current database set up using about 40 or so Union queries to select...Leave a comment:
-
Thank You Jim,
Both fields in the join statement are numbers (one is an automumber). Please let me know if autonumber vs. number is a problem.
RhondaLeave a comment:
-
Type Mismatch Error in Loop
Hi everyone and thanks in advance for any help on this. I have some VBA code that I would like to use to loop through different criteria in a SQL statement. I actually pulled the SQL statement seen in the VBA from a query that I know is functioning properly.
I have three tables: tblSampleLogin, tblDataEntrySto rage and AR_tblActivePar ameters. I want to loop through the Parameter column (Short Text)in AR_tblActivePar ameters to pull...
No activity results to display
Leave a comment: