ClaraBarton's latest activity

  • C
    ClaraBarton replied to the thread OutputTo Excel error.
    upon further research I discovered a function at BTAB Development called Send2Excel. I changed Send2Excel(frm As Form, Optional...
  • C
    ClaraBarton reacted to The_Doc_Man's post in the thread OutputTo Excel error with Like Like.
    My wife feels that way sometimes and calls me in to help her. All I have to do is walk into the room - not even touch anything - and...
  • C
    ClaraBarton replied to the thread OutputTo Excel error.
    Well, to be perfectly honest, most things I don't understand. I just go with the flow. Sometimes I get the feeling that the code gets...
  • C
    ClaraBarton replied to the thread OutputTo Excel error.
    Well, yeah. but I wanted to give it no name so I wouldn't have to delete it every time. How would that work?
  • C
    ClaraBarton replied to the thread OutputTo Excel error.
    Figured it out! Give the Querydef a name as follows: strSql = Me.lstUsage.RowSource Set qdfTemp =...
  • C
    I want to export the data from a listbox to Excel. I pretty much followed the Microsoft Help to come up with the following: strSql =...
  • C
    You know. As a prime Developer, You write most the logic in codetime and let the "interested" beginners do the Debug session in their...
  • C
    ClaraBarton replied to the thread Field has no value.
    Oh Rats! You guys! now it works!:sneaky: :rolleyes: I'm going shopping.
  • C
    ClaraBarton replied to the thread Field has no value.
    click on an item. (brown). it immediately goes to If IsNull(subFrmItem.ItemID) Then and stops. It is not null. It just stops. It cannot...
  • C
    ClaraBarton replied to the thread Field has no value.
    I'm sorry. I thought I did! :rolleyes:
  • C
    ClaraBarton replied to the thread Field has no value.
    Well that works.... but it stalls on the first line and I have to push it on. Would you like to look at it? Click Detail and then select...
  • C
    ClaraBarton replied to the thread Field has no value.
    I thought I could have the flow go both ways. The Location subform has all the locations as a recordset and the Detail subform has a...
    • 1763333658173.png
    • 1763333936969.png
  • C
    ClaraBarton replied to the thread Field has no value.
    I put both do Events and Set Focus and it seems to be working. If I put only set focus it says you can't go to the specified record...
  • C
    ClaraBarton reacted to MajP's post in the thread Field has no value with Like Like.
    So that does sound like a timing issue, and do events would be my first guess to. Often the fixes for timing issues are unexplainable...
  • C
    ClaraBarton replied to the thread Field has no value.
    AAARRRGGGHHHH! I Knew That! But wait... I screamed too soon On open of the main form I have: Set subFrmItem = Me!ItemDetail.Form Most...
Back
Top Bottom