Search results

Wow, that works great, but I'm trying to understand it... 🙏 By the way, I'm a bit new to all this.

Hello, Maybe this might help: Each section (tblSection) can have many documents (tblWI). Each section also has one unique doc owner (fldDocOwner) and one unique approving authority (fldAppAuth). As an extension, each document (tblWI) also has the same doc owner and approving authority as the...

I'm thinking that it's because of many-to-many relationship in my tables, but I just cannot figure out how to solve the problem. Here's the problem: Here are relationship tables: Form SQL

Hey thanks for your help. I get the following message: Error 3022 Edit: I cannot find any duplicate data anywhere in any table. Not sure where it's pointing to. Sorry, It's probably obvious that I'm really new to VBA and Access

Hello all, I am trying to add a user from a sub-form which pulls details from Outlook. Once I press a button, it should save the record and add it to my table. For some reason it does not do that. Here is the code in question: ' Add the entry CurrentDb.Execute "INSERT INTO...

Only this part is getting highlighted Here's the rest: Private Sub btnSend_Click() ' Get the COC Dim strEmail As String Dim strCCEmail As String Dim strSubject As String Dim strBody As String ' Make sure there is an email If IsNull(Me.parent.fldMemberID) Or...

Hello I'm having issues with following code: strBody = "An AMMIS Correction is required for Form Serial Number " & Me.parent.fldAmmisd349 & " due to the following reason(s): " & vbNewLine & vbNewLine & _ "- " & Me.parent.fldObservation & vbNewLine & vbNewLine &...

Hello, Thanks for replies. Would deleting this line work? I'm trying to wrap my head around doing what you have suggested, but i don't think I have the knowledge yet to do that. I can search around and try. I assume this isn't a quick fix?

Good day all, First post here. Like the title says, I'm trying to fix an error I keep getting after clicking on "Send" button to send email to subject users, but it keeps coming up with error 2295. Here's the code: Option Compare Database Public Sub SetEnabled(bool As Boolean) Dim c As...