Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. O

    Extract string from dynamic query fieldname

    I am building an access database that will create queries based on imported xlsx spreadsheets, so the names of the queries will change. The system will generate one of the fields names as such (SQL code with VB) Example: "IssueType - Environmental" - Mentions: Q11 Theme I need to extract the...
  6. O

    Greetings

    Hello all I am new to this forum, though I previously frequented VBAExpress for vba help. After a quick search, this forum happened to come up and seems quite busy, so will make a good alternative. I hope to share any useful information along with asking for help :D 10 years ago I was an...
Top Bottom