I am able to connect to an api and collect data if it does not require authentication via xmlhttprequest within VBA module of an MS Access Database
sub ReadDataViaAPI()
Dim reader As New XMLHTTP60
reader.Open "GET", "https://api.github.com/orgs/dotnet/repos"...
Thanks for the suggestions, I have nearly got it working, but it is dropping the MsgBody text and only displaying the signature!
'Collect the message Subject line
Dim MsgSubject As Variant
Dim MsgBody As Variant
MsgSubject = Me.Text9
MsgBody = Me.Text3
'Create the...
I have a form that allows the user to 'create' and add multiple attachments to an email that is then sent through outlook.
It all works with one exception, the signature is dropped from the email, can anyone tell me what to add and where in order to use the users default email signature in...
I have a main form and a subform.
I can 'filter' the data in the subform by using the arrow next to the column heading and selecting the filters I want to apply.
Is it possible to identify what 'filters' have been selected against the column so that it can be used elsewhere in vba code?
I have connected an Access database to a Visio drawing.
I have never used or looked at Visio before, but as it is a Microsoft product, I imagine I can use VBA just like I do with MS Access and other Office applications.
I want to have 2 'shapes'.
I want Shape 2 data to be determined by the...
Thanks
I have tried those and the text still 'spills' over back to the report edge rather than every line being 3cm from the left hand edge of the report.
Irritatingly, this issue does not occur in Word 2003, it is just versions after that where it decides to do its own thing?!!
I have a text box that is 3cm from the left hand side of the report.
I set it to can grow because the data that will populate it will be multiple lines long.
I need the text to stay 3cm from the left hand side of the report.
When I merge it to Word 2007 the first line stays 3cm from the left...
I have inserted a record into a table. The record included a value in the autonumber key field that was less than the next value.
This has locked the table. Even after closing the machine that did the transaction, which allegedly has locked the table, I cannot unlock the table. I cannot...
I have tried to follow the various tutorials on merging to a Directory and I am not even close to getting it to work.
I am using Word 2003.
I am trying to make the example work so that I properly understand what is going on, therefore, I have copied the MS excel data file in the "How to Set...
I have a very ugly solution using the ItemsSelected value to enter the sequential number.
I have 3 lists on my form
lstRawData is the raw data with the strings
lstExtractedData is where the extracted strings are displayed
lstWorkAround is used by the vba to grab the lstExtractedData...
I have a string that I am able to split into separate records.
ID --- string of values
1 ---- 1, 0, 0
2 ---- 0, 1,0 etc
Each string has the same number of values (43 records).
ID ---- value ---- Position
1 ----- 1
1 ----- 0
1 ----- 0 etc
I need to append a sequential number to the Position...
Ah!
Thanks Andrzejek :)
Never used them before. Thanks for pointing it out, I was wondering how to make it look reasonable
I need to produce a simple 'table' - (query output) like the one below:
Entries vertical the right hand column, Prizes horizontal in each row.
No. Entries | 1st [tab]|...
My list is sorted in ascending value. It is populated via sqlstr in vba that pulls down each row in a table, then sorts them in ascending value order. The list can be 'added to' with values collected from several text boxes that are then inserted into a table and the list requeried.
I want to...
I have a report with multiple records (1500ish).
I have built a report that pushes data into the report then exports it to Word as an rtf.
Everything looks correct in the report when I preview it on screen
What I need is for the fields to be aligned correctly
Prefix Number Title
Detail
I...
i am populating and filtering a list via vba OnLoad of a form
I was using Access 2013 but had to move to a machine running Access 2007. The database is now running in Access 2007 and has 'suddenly' started flipping dates around and I do not understand how to stop that from happening.
SELECT *...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.