Recent content by completelybobbins

  1. C

    Update/Append corrupting Memo field after 512 characters

    Huge thanks Bob - wouldn't have even thought of trying that.
  2. C

    Update/Append corrupting Memo field after 512 characters

    Update/Append corrupting Memo field after 512 characters (Resolved) Hi Folks Can't find anything on searching about this, but apologies if I've just missed something... Example db attached (open form 'frmTest') If I load the contents of a memo field into a form's textbox, add any...
  3. C

    DoCmd.TransferSpreadsheet 3270 error if spreadsheet closed

    Bit more info: when I make a local copy of the table approvalProgress (copy/paste job) both cases work fine, so it's something to do with the spreadsheet being closed and access using a linked table.
  4. C

    DoCmd.TransferSpreadsheet 3270 error if spreadsheet closed

    Hi All Thoughts on the following welcome, as I've got no clue! I have code that imports two named ranges from the same spreadsheet to two different tables, snippet as below. For i = 1 To foundFiles fileName = .foundFiles(i) DoCmd.SetWarnings False 'Import the summary...
  5. C

    automatically scrolling down a subform

    Hi folks Any thoughts on the following would be useful. I've got a form with two subforms, say subSummary and subQuestion. Each subQuestion page has information about a particular exam question, with mark scheme etc. The user enters a mark, clicks next, and the subform goes to the next...
  6. C

    Tooltip based on combobox selection

    Hi all Any help with the following would be immensely useful. In a mix of VB/English, I'm trying to acheive: Private Sub ifTest() If combobox = "set value" Then tooltip.caption = "Some Text" Else If combobox = "some other value" Then tooltip.caption = "" End If End Sub I can get...
See more
Back
Top Bottom