Search results

Hi I have been using the CDO method to send emails to people using text templates and placeholders, which work really well. What I'd like to do is determine at the time of sending the emails, which template to use. Currently the text template is written within the module itself. Const...

I have code which work when the attachment is sets C:\AccessFiles\some.pdf However. I want to send a file that has been referenced in a text field within the table. The code gives a runtime error 438 but hovering over the line it stops at, shows the location and the file that I want to send out...

Hi all. I have CDO working well to send a test message to the recipients of a table (This will change later to an on demand query) What I'd like to do is use a textfile template for the message which will be populated from the recordset. What do I need to do with the code to make this work...

Hi all, hope all is well during this Pandemic! I'm having an issue with an Unbound Form whereby there are two text fields. StartDate and EndDate which are manually filled in by the user before pressing a command button which runs a query, both fields set to short date, all standard stuff...

I am trying to send an email to participants who have Confirmed Booking. A Confirmed Booking is a Booking whereby the Participant has PAID and sent in the PL Documents. The email should only go to those people who have not been emailed already. strSQL = "SELECT tblParticipants.PName...

Have used this string successfully now to send emails out to participants who haven't paid. Basically, the table hold Event Bookings for each participant. In order to class a Booking Confirmed, the Participant needs to have paid AND sent in their Public Liability Insurance Certificate. What i...

Hi all I have been working on a Stock / Inventory Database which is fairly simple for my requirements. I have an unbound form with a Combo Box populated via a query. The form displays the stock levels taken from the query / combo box. Also on the form are four fields that allow me to enter...

Hi All I have created a database that allows for the emailing of a standard message to multiple email address via a module and VBA code. This creates a recordsource from a query. All work well, however, if I add parameters to the underlying query, I get a RunTime 3061 error too few paramaters...

Hi all, not been here for a while....a few years anyway! Created an un-bound form that does what I want except for one thing. I have a cbo box that needs to be set to either yes or no. The I have a button which processes various things, but crucially dependant upon what the cbo box says, it...

I have some code that outputs to a text email currently whereby it sets the Venue address in the correct format, for example if there is only one address line, it concatenates the string to exclude the missing line and formats the address correctly This is part of the code that does that I...

Hi I have some code that takes from a query, an email address and sends out an email. Due the security warning that happens for each individual email, i want to create ONE email for all email address in the query and populate them to the BCC section of the sendobject. Here is the code that I...

Hi all I have a form which has a button to email the data out in a standard email message. Here is the code: This works well enough, however, FIELDS 11 through to 16 contain the venue address. This is all we ll and good if every field of the venue address is populated. here are times when...

Hi all I am using Access to open a csv file and then populate a table with the data. This works fine with no problems. However, in order to do this efficiently I have had to modify the csv file to remove the last 5 lines that the crm package has added to the file. I have a excel macro that...

Hi all I am creating a access db for use with a training company. All is working great. What I want to do is create certificates within Access and then print by the Course load. Easy enough and I can do this. The courses usually last two or three days, so i want to create a field which has...

I am building a database for the company I work for. We offer software training on a specific software. We have 12 laptops and currently two trainers. Courses are generally 2 days in length but due to having two trainers, both trainers can be out either at the same time or overlapping each...

Hi all i have an unbound form with the following code which works as it should Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("tbl_Courses", dbOpenDynaset) With rst .AddNew rst!DateCreated = DateCreated rst!Originator = Originator rst!CourseTitle =...

Hi all Long time since i asked a question here, been busy with other stuff, however, here I am back with Access. Im currently working for a client who offers training on their software. The have a stock of laptops (12 in total say) Three Course Trainers Courses which last between 1 and 2 days...

Hi all I have an unbound form containing textfields that are populated on the afterupdate event of the combo box. The combobox is driven by a query which among other things contains a currency value. When I run the query, the format of the field is correct (£23.00) however, when I use the...

Hi all Been taking a break from Access recently ,but been dragged back into it. My application is a bespoke quotation/invoicing/customer address type affair. The main structure is up and running. I want to be able to create one report only for both Invoices and Quotations. This is all driven...

I have form which is based on table (I know I know!!!) However, I have created several buttons to do the work manually. I have a save button of which this code is part of If Me.Dirty = True Then If IsNull(ContactName) Or ContactName = "" And IsNull(CompanyName) Or CompanyName = "" Then...