Search results

Thank you for replying. i think i have fixed it. i had a go at running the macro in sections to find out when access starts to crash and i found out it was after it ran the code "Application.Echo False" which is in the section. i am unsure of why that line of code caused the issue but once i...

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...

Thankfully no, yay much happier now.. Thank you so much for your help it is greatly appricated

I believ Outlook is currently using the new SMTP. SO is it that access uses what ever SMTP outlook is using?

Thank you for replying. So i would need to recode the VBA so it uses the corrcet SMTP location?

[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...

Thank you for your reply and help. The link you sent was very helpful, however i found the link "https://codingislove.com/http-requests-excel-vba/". Using this i have managed to get my XML module working. However I ma still usnure of what Base64 does so if anyone could provide me with some...

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...

I managed to solve my issue by switching to Office 2013 32bit, sorry if i forgot to mention this orginally

Found reason why its stopped working, it was because I was using 64 bit office 2016 instead of 32 bit. Problem is now solved. But thanks for replying

[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...

Thank you for all your help. I believe to have found a solution. The issue was being opened in Excel before being imported so the columns were being converted to different data types by excel. We have stopped opening it in Excel first and it appears to have solved the issue. But thank you for...

I have checked the files before they are split up and they i can never see anything wrong with the data that would cause errors going into the table. I never see a table called Import errors, if it did it would be wonderful as I could get a better idea of whats causing the problem. However no...

[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...

I have found a fix for the issue I was having. I found an article online saying to put [] round the field name. So I changed the rst!7A to rst![7A] and this seems to have solved the error.

Hi, Thank you for replying. I have added that in but the rst!7A = 1 is still highlighted red and I am still getting that error.

[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...