Search results

Good Morning, i was wondering if someone could help me with an issue i am having with Access. Currently i have a system which is a Access which is running two macros. the first one creates a new record in two different tables. The second exports a query, then opens a word mail merge document...

[Solved] Opening a new Email from Access Hi, i have a VBA module which creates a new email from access and populates it with a send to address, subject and message body. However i have been told to amend any code within this access system so that it points SMTP taffic towards a new SMTP...

Hi, does anyone know why i would get a Write Conflict error message when closing a form in access? The set up i have is an access frontend with an SQL backend, and the error occurs when a form (which is open in edit mode and uses a query) closes without saving the record. So no changes are...

Hi, I am trying to create a module in access VBA which sends XML to a web address. The module I have created seems to be contecting to web address however I keep getting an error saying I am not authorised even through i am sending the username and password. I have been told I need the XML...

[Solved] Office 2016 Access VBA sending XML Hi, I am upgarding to Microsoft Office and a piece of VBA which sends XML to a web address has stopped working. It uses Microsoft Soap Type Library v3.0 and produces an error saying "Active X component can't create object" when it tries to set a...

[Solved] - Access VBA error 3349 Hi, I am getting this error when running a macro I have which imports a CSV into a Table and the majority of the time it works however sometimes I get the VBA error 3349 "you cannot record changes because a value you entered violates the settings defined for...

Hi, I am trying to upgrade my Access database system to 2016 and so far it is OK however the code below is no longer working and keeps producing the error "Private Enum and user defined types cannot be used as parameters or return types for public procedures, public data members, or fields of...

[Solved] VBA printing a mail merge letter from Access I was wondering if anyone could help. I have a program which opens a Word mail merge then prints each record into its own PDF file however I have an issue where half way through instead of closing the temp file it closes the main mail merge...

[solved] - VBA - Adding a new record to a table Morning, I am trying to add a new record to a table using VBA, I ahve pasted the code I am using below. In the table I have columns called 7A, 7B, 7C etc. However I keep getting the error "Compule error: Expected: end of statement" on the "RST!7A...

[SOLVED] dlookup data type mismatch error HI, I am trying to get my VBA module to find the ID of a Member Number from a table using a dlookup but I keep getting a data type mismatch error, Dim Answer As String Dim varX As Variant Dim rst As Recordset Dim strSQL As Integer Dim stWhereStr As...

Calculate exact age - solved Hi, I am trying to find a way of calculating the exact of someone from their Date of Birth. On my access form I have a text box with the date of birth and what I want to be able to do is have another box flag up whether from the dob the person is under 18 but as...

Hi, I have a VBA module in an access database which sends XML to an outside location. The code is below, however when I run the script I keep getting the error "Run-time error '-2147024809 (80070057)': WSDLReader: XML Parser failed at linenumber 61, lineposition 19, reason is The name in the...

Good Morning, Hi, I have an access database which in one form opens a word mail merge file which is linked to the database tables. In 2007 and 2010 Access it was fine no problems however since we moved over to 2013 access I have a got the error message "The OpenDataSource method or property is...

HI I have a database in Access 2010 which has 3 tables (OEM, Products & Support) and a form (SupportForm). I now want to create a report which has two drop down boxes (linked to 2 columns in the Support Table, Field2 and Field3) on it, which when choices are selected from them they will run...

Hi Hi I know this is not a question but i really need some help with my dissertation on comparing different database software including Microsoft Access 2007. I am looking for anyone who has used Microsoft Access 2007 before. If you have could you please please please fill out this...