Search results

I have the following code which checks the combobox to ensure it matches a certain value, and if it does the code then goes onto do a date validation check for me. If the date validation check fails I want a YesNo message box to appear to prompt the user to go back and enter/update the date...

Hi, Trying to get this to work but once I have entered info into all textboxes combo box still remains disabled. Where am I going wrong? Private Sub Client_FN_AfterUpdate() Call EnableClientStatusCombo End Sub Private Sub Phone_Call__1_AfterUpdate() Call EnableClientStatusCombo End Sub...

Hello, So far with the very kind help of people of this forum website, I have pieced together the below code and it is working 😊 I am new to VBA and although dabbled in the past never got this involved. Essentially the code below takes information for a specific lead/customer from three...

Hello, Hopefully a simple one! How do I make this work please?: If Me.ClientStatus.Value = "NPW - No Contact" Or "NPW - Gone Elsewhere" Then

Hi, I have an outlook template (attached screenshot) and some code that looks through two tables to grab required info for email template. I have to be honest I have borrowed this code from somewhere else and amended it. I am however getting syntax error: Syntax error (missing operator) in...

Hello once again, I had previously posted with a very similar question but in that example I was using a list box. Having a re-think I was potentially adding an unnecessary step to my DB because I already have a list of the documents that are required to be attached in my 'ExisitngLeadF, as a...

This works in windows command line as I have tried it: ForFiles /p "C:\Users\David\Desktop\New Leads\ContactProofs" /s /d -30 /c "cmd /c del @file" I thought I might be able to run it as a shell command within VBA but with CurrentProject.Path like this: Shell ForFiles /p &...

Hello, I am sure this has been discussed somewhere on this forum already, however, I cant find it! Been experimenting with some code. So far the code picks up the attachments from the list box but puts each one into a separate email. I want all attachments in listbox to be attached to the...

Hi again! Really not sure why I'm getting this message. I have various pieces of VBA code all pointing to this same document in my DB with no problems. Now I want to try and attach this file to an email I'm getting this error message. The file exists, the path hasn't changed! This is the...

Hello, I have attached a screenshot of a query that I have put together. It wont be obvious from looking at it (because I've had to cover confidential information) however the two rows that are underlined are the same client record. I have a note system that stores notes for each client in a...

Helloooooooooo, The title pretty much says all! I have an Excel Spreadsheet (SS) that the directors have put together in a format they are happy with (please see attached). Lets say I have a table with all the information needed for the SS plus a few little extras that I have added PLUS a...

Hello fellow Access peep's, I have a list box on my main menu which has a query behind it showing me all leads that require a follow-up. The list box contains First name, surname, lead date & status. All but the status column are displaying correctly. The value however in the status column...

Hi fellow Forum'ers, I have a tabbed control containing a subform. On the 'Contact Proof' list I have a list of all the proofs attached to the record, this is a continuous subform. I have it working almost the way I want it, however, you will note from the screenshot attached that I also have...

Hello fellow Forum'ers I have been trying for hours now pulling my hair out trying to understand why my code will not put a line break in my email. In basic terms I have a table which contains a field with the body for an email which can be amended by the end user through a form. It enables...