Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MrMode

    vba xmlhttprequest API oauth configuration

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

    include signature with Outlook email through Access VBA

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

    include signature with Outlook email through Access VBA

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

    include signature with Outlook email through Access VBA

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

    Expose filter criteria in subform for use in VBA of main form

    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?
  6. MrMode

    First tentative steps with Visio - finding a shape's data based on the value of another shape

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

    Format text box in a report so that all the text stays aligned 3cm to the right

    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?!!
  8. MrMode

    Format text box in a report so that all the text stays aligned 3cm to the right

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

    Table locked after inserting a record with autonumber field value

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

    Merging to MS Word Directory confusion

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

    add sequential number into a field for each group of records

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

    add sequential number into a field for each group of records

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

    Bettter design for collecting information to turn into a result

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

    Bettter design for collecting information to turn into a result

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

    Updating a listbox then moving to that row in the list via VBA

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

    Text spliing across document when exporting to Word

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

    Argh - Dates keep flipping to US format

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

Part and Inventory Search

Back
Top