Relative Content

Tag Archive for excelvbams-access

Invalid expression in MS Access

I am using the below query to calculate sum of 4 variables in another field called Total. But I am getting the below syntax error. I am unable to understand the problem. Can any one take a look. Thank you in advance

error 70 while copying a file with fso.copyfile

I have this little bit of code I would like to use to copy a text file in the same directory as the workbook. the file fullname I want to copy is stored in the cell B14 Cells(14, 2).Valueand I get the local folder’s path with Application.ThisWorkBook.path

Excel vba Nested Forms Listbox missing data

I’m using multiple forms in excel vba and each form for itself works nicely.
I’ve created frmMainMenu to call these forms and whenever I call some of them, listboxes in them are not filled with data.

Edit Excel file from MS Access using vba

I have a MS Access database that exports a queries as sheets to an excel file. Then (this is the part where I’m getting stuck) it is supposed to open the newly created excel file, apply conditional formatting, close and save the excel file. And finally, create a folder (using today’s date) and moving the excel file to the newly created folder.
Here is the code that I am using. I get a run-time error ’75’ (path/file access). But sometimes the code gets stuck in the middle of formatting the excel file. Any help will be appreciated. Note: the code for conditional formatting is from ‘recording a macro’.

cURL to Vba for ms access

import requests url = “{{apiBaseUrl}}/{{vendorUid}}/contact/send-message” payload = “{n “phone_number”: “{{phoneNumber}}”,n “message_body”: “your message body”,n}” headers = {} response = requests.request(“POST”, url, headers=headers, data=payload) print(response.text) We need AUTHORIZATION https://documenter.getpostman.com/view/17404097/2sA35D4hpx please help me curl convert vba ms access please help me curl convert vba ms access excel vba ms-access New contributor jasskurd is a new contributor to […]