Search results

I want to check the AppStart table for a match on ApplicationId and one of the fields = 'Complete' This is what I have If (DLookup("ApplicationId", "AppStart", "[ApplicationId] = " & _ Me.ApplicationIdFld & " AND [StartStatus] = '" & "Complete" & "'") = True) _ Then...

I Have a query that deletes multiple records from a table. The record entries to be deleted is a variable. I want to be able to report to the user the number of records deleted Can I get access to the total deleted, total searched etc Appreciate any help

I have successfully created automated access - word merges for One to many documents with many bookmarks. I now want to format the contents of a number of bookmarks. at the bookmark in the document

I have created a document library that is populated with all entries related to a matter. When a user looks at a matter I want them be able to create folders within folders in the library. For every entry within that matter. I keep the parent folders name and the current folders name in each...

I have a need to determine if a field is odd or even Me.Filter = "(UserId = " & Me.UserIdFld & " OR ActionDueDate <= (Date() - 21)) & " AND ((Me.MatterShortNo) MOD 2 = 1)" ' and Matter number is Odd Obviously my syntax is wrong but I can't see it Any help would be appreciated

Thanks for your help guys The variable from the other form MatterIdFld should have been MatterId It now works well Thanks again

tried that and went through to say that 0 records will be updated , where in actual fact I have 14 records that should be updated

will do - thanks - I should have thought to try that

I have a table of ActionTask records and I want to select all those that have matterId = to the MatterId on a form and the Status = 'Active' and the completed field is false The code I have written select the right records but doesn't update the required fields UPDATE ActionTasks SET...

When the user types in the area "Your Text Here" it double spaces the lines. The font is fine and the font size is right but not the line spacing

I'm trying to use the HTMLBody. I set the font and the font size but I can't seem to set the line spacing. Me.strBody = "Your Text Here" .HTMLBody = "<p style='font-family:calibri;font-size:14.5; line-height: 1'>" & Me.strBody & "</p>"

Thank you Cronk I think you have solved my problem. I can add the attachment address and filename as I deal with each file instead of concatenating them into one field Thank you

I have created a filed called AttachmentsFld and it contains the full address and file name or each attachment separated by a ; Each of the documents have been converted to .pdf's I can run this for 1 attachment or multiple attachments. If it's multiple I set Me.MultiAttachFlag = -1 I get an...

Thanks Paul That really helped. Atrium

I'm having trouble including a integer variable into an SQL statement. If I substitute the variable for the numeric 1, it works as expected. The code is:- Dim intClientId As Integer Dim strSQL As String Dim rs As DAO.Recordset Dim strWhereStatement As String Dim strQryFile...

Thanks Mark, it was a stupid over sight. Cheers atrium

I'm sure this is a very simple one. I'm checking an ABN number field. The user can put in 11 digits or N/A here is the code If Len(Me.AbnFld) = 11 Then Me.AbnFld.InputMask = "00\ 000\ 000\ 000;;_" Else If Me.AbnFld = "N/A" Or "n/a" Then Exit Sub Else...

Missinglinq The last bit of code to highlight the text worked wonders. Thank you Atrium

I want Access to use SendObject to create an email with edit set to TRUE to allow the user to add or edit the body of the email. Once it is sent I want access to be able to store the body of the sent email in a table. When the user updates the body content is the .body field updated? Any Help...

Sorry anyone who spent time on this. I have worked out that I was using the wrong fields. Regards