Search results

  1. O

    find and replacing in a table, change characters to colour

    I was using your code: oTable.Cell(PositionA, 3)=replace(replace(oTable.Cell(PositionA, 3),"-","<font color=red>-</font>"),"+","<font color=green>+</font>")
  2. O

    find and replacing in a table, change characters to colour

    I managed to do this in a different way. in code I select the entire table, then do a find/replace on that. There shouldn't be any of these characters in the table, but there may be elsewhere in the document The second selection of the table is probably not needed, but thought I would put it...
  3. O

    find and replacing in a table, change characters to colour

    Sorry, Access and Word 2016. Access doesn't like the second instance of "Replace" in the statement, it gives an error of "Type mismatch" when compiling. (I have the Word 16 object library in references)
  4. O

    find and replacing in a table, change characters to colour

    This may be possible, could it be done within a set part of the document only ( IE, on page 3 or within a table only)?
  5. O

    find and replacing in a table, change characters to colour

    It may be elsewhere in the document, so I can't search for that.
  6. O

    find and replacing in a table, change characters to colour

    Through an Access database I am exporting data to a word document. In this particular section, it is a table being filled with data. There is one column that needs to be coloured, that has the set values + - +/- the plus need to be green, and the minus red. I can colour the single ones, the...
  7. O

    Import xlsx into New Access table, without strings being truncated

    I have been seen this mentioned a few times now, this does appear to work. it is a pain to have to put an extra row in the excel file though. I have discovered the issue isn't when importing, but the query I am outputting. Basically, if you group fields in a query, memo fields are truncated...
  8. O

    Import xlsx into New Access table, without strings being truncated

    The Microsoft one was actually more useful and explained the following (Posting so this information is on here in case Microsoft remove the article) I am not setting a field type, only creating the table. How do I set the fields to be the memo type (or to accept a longer string) when...
  9. O

    Import xlsx into New Access table, without strings being truncated

    I am importing xlsx files via fileopendialog. The Excel file chosen may be different each time in structure. The code I am using to import is: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _ Replace(strTable, ".xlsx", ""), strPathFile The issue is when the cell in...
  10. O

    Summarise query into word document

    I can see why your post count is so high, you just post anything without explanation. For anyone else who finds this post and is wanting to do similar, the below is a step in the right direction. It will go through a query, and put the "theme" value first with the first sub text. For the next...
  11. O

    Summarise query into word document

    I have come up with a solution that should work, but I am having trouble putting the query values into an array
  12. O

    Emails from a form to a list

    You could use multiple inputboxes (one for each sentence) and combine them afterwards into one long string, though this would be time consuming. If you built a form, you could possibly put an "onTimer" event (as the user would be typing in the box at the time, the value hasn't yet changed, so...
  13. O

    Summarise query into word document

    1) I am already doing this, I am asking about how to output in the following format: [FieldCategory] category1 "text" "text2" "text3" category2 "text0" "text05" category3 "text stuff" Your method would display as the following: [FieldCategory] category1 "text" category1 "text2" category1...
  14. O

    Summarise query into word document

    Hello I am exporting dynamic queries from Access to a word document, by means of replacing the bookmark text .Bookmarks("FieldCategory" & i).Range.Text .Bookmarks("memo" & i).Range.Text = VerbatimQryTable The query I want to export would display in the following format when opened normally...
  15. O

    E-mail One Form Only!

    Your form is maybe linked to all your records. Have you got a filter to just display the current record on the form source? If not, a query or filter may help.
  16. O

    Access SQL doesn't like table fieldnames

    I did, it wasn't putting them in. That's how I checked it.
  17. O

    Access SQL doesn't like table fieldnames

    You have missed off the end part in the code above. The like statement is Like " & Chr(34) & cleanedqField & Chr(34) & " " & Chr(38) & " " & Chr(34) & "*" & Chr(34) & "));" I have put Chr(34) instead of ", as it is much easier than having to put multiple "". I have solved this by renaming the...
  18. O

    Access SQL doesn't like table fieldnames

    Thanks for this, that is a useful link. Access is strange that it allows for the table field names to have those characters, and you can even build queries with them with the query builder, but as soon as you try to build SQL with those names, it doesn't like it. I have found an alternative...
  19. O

    Access SQL doesn't like table fieldnames

    I am building a reporting engine that builds queries dynamically, based on imported xlsx files. The fieldnames can be different each time. One issue I am having, is if the field names have the following: "23# txt | fld" It throws a 3075 error - syntax error. As these characters are in the...
  20. O

    Extract string from dynamic query fieldname

    That has helped, thank you
Top Bottom