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

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

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

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

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 is embarrassing, I am having brain freeze... I have collected a string of values in a sub. Private Sub CollectString() 'Collect those selected in the list Dim strSQL As String Dim strwhere As String Dim ctl As Control Dim varItem As Variant 'make sure a...

I have a query that renumbers a field for all records in a temporary table ALTER TABLE tblRanking ALTER COLUMN Rank COUNTER This works perfectly. What I would like to do is dictate what the starting number should be. I understand that you can add additional information for the COUNTER (x,y)...

I have two userforms. The first (frmRecords) shows each row as a record with navigation buttons (First, Next, Previous, Last). It also has a text box giving the number of the record (i.e. 1) and label that gives the total number of records (i.e. of 7). This works correctly and allows the user...

I have a user form with a textbox that the user enters a date into. When the record is 'saved' - copied to the next empty row in the worksheet, the date changes from dd/mm/yyyy to mm/dd/yyyy even though the settings are for English (UK) date settings both in Excel and locally on the machine...

I have a form with a command button on it. Then onClick event pushes a value to an unbound text box on a separate form. ' 1.Open second form DoCmd.OpenForm "frmB" ' 2. Set the default value of the text box on the form Forms.frmB.Text45 = Me.PLID When frmB opens, a...

I have two multiselect listboxes. I want the user to be able to make multiple selections in ListA (ListPerson) and multiple selections in ListB (Choice) then have these selections written to a table. For example: ListPerson John Jane Bill ListChoice Choice 1 Choice...

I have a listbox where selected items that include 3 fields ( ClassRank, ClassNumber, ClassDescription) are added in order for me to re-order them: Dim varItem As Variant Dim strAdd As String Dim columnCount As Integer Dim i As Integer columnCount = List12.columnCount For Each...

I have a dataset with a field that contains a text description which includes year(s). I need to increase the value of each year found in each text string by 1 year. I have been looking at Replace() however, while it will find a year, there may be several years in the same field. If the...