Search results

Due to the amount of data I'm opening on a single form, I must close forms before opening up the next form. The below code appears to require the form to be open, just not visible. Does someone have a solution that captures the previous form, stores it in memory and makes it available from...

Any thoughts on putting a find as you type on the left list box to help locate a record in a long list?

https://www.techpowerup.com/forums/threads/how-do-you-change-the-text-to-speech-voice-in-a-windows-vbscript.242749/

Visually, it's intuitive. Record 1 and 2 are not duplicates. So what did I do wrong in the code? Or should I place the code on a different triggering event? Private Sub Form_BeforeUpdate(Cancel As Integer) Dim ClickResult As VbMsgBoxResultEx 'Make sure there is some value in the...

After the user followed the below path, changed the Owner value to their name and rebooted, I now can see their full name in Access on the Startup form. I think this one is good now.

Thanks for the push to adjust the code. I now have the email body string (.HTMLbody = strBody) wrapping to the next line <p>, included a hyperlink to the dynamic SharePoint folder based on the specific event <a href > </a> and the meeting highlights which were stored in another table...

Modified the code with the select statement and removed the warnings setting. Something new.

What would cause my code to trigger the Form_AfterDelConfirm when I select NO on the popup confirming if I want to delete these records. Visual of the subform and button (red circle) being pushed. Here's the a snipit showing where the code goes to immediately after the NO selection. I am...

In my case a user went to Best Buy, got a new hard drive for their laptop and configured it, obviously not to the same standard that the IT would have done. And because of these kinds of situations, I have to acknowledge there are likely to be other occurrences. They still have the ability to...

By the way, thanks for showing how to generate a hyperlink. That's going to be useful.

@Micron I must not understand what vbNewLine does. It apparently doesn't create a new line in the HTML string. The following code (yours and mine) generated everything on one row (until it got to the signature and it put it in the right spot. .HTMLBody = "Test HL: <a href='C:\Users\" &...

@sonic8 See below. The Full Name populates with the user's actual name (blue text). Where is that value stored and how might it be pulled from the computer? @HiTechCoach I am able to pull the Computer name out so if push comes to shove, I am tracking your technique. This user got a new...

What does your code look like? I tried the below and that errored as well at the same point. .HTMLBody = "Team, See the attachment reference <b>" & Me.Event & "</b>. If you have any questions please let me know." & PlainText(Me.Key_Items_Discussed) & Signature

Yes, that is the error. Anyone have a way to insert that data field within an email body?

It highlights me.Event with a Compile error. Which is weird since the same me.event is on the subject line (which fired just prior to the HTML line) and it works fine. Also what you see below in the screen capture includes the commented out line, which works but I just wanted to improve it with...

My code to generate an email from meeting notes is getting close. I want to add are the Rich Text formatted notes from the field Me. Key_Items_Discussed. At this point, adding in Me. Key_Items_Discussed to the HTMLbody string causes the code to error (won't compile). Pull that field out and...

It's working. Thanks. If DCount("*", "[t_Systems]", "[System_Acronym]= '" & Me![System_Acronym] & "' And [System_Name] = '" & Me![System_Name] & "'") > 0 Then

Stuck downstairs. Puppy sitting.

Thank you.

Closer, I hope - Error Type 13 mismatch. Code compiles. Both fields are Short Text format. If DCount("*", "[t_Systems]", "[System_Acronym]= '" & Me![System_Acronym] & "'" And "[System_Name] = '" & Me![System_Name] & "'") > 0 Then