Search results for query: *

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

Quite right, needed to ensure that the text was formatted as HMTL. That is brilliant, thanks

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

As always, Thank you

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

OK, will do. Thanks

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

I need to produce a simple 'table' - (query output) like the one below: Entries Prizes No. Entries | 1st | 2nd | 3rd | 4th | 5th 1 to 3 | $10 | $7.50 | $5.00 | $0 | $0 4 to 6 | $10 | $7.50 | $5.00 | $3.50 | $0 7 to 9 | $10 | $7.50 | $5.00 | $3.50 | $1...

Thank you

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

...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 * FROM tblTest WHERE tblTest.ActivationDate <#" & me.text9 & #" Debug.Print me.list0.Rowsource shows the date correctly in the sql as dd/mm/yyyy...