Recent content by ECEK

  1. E

    Solved Carriage Return within unbound Rich Text field that will append to a long text table field

    Downstairs for dancing !!!! June7 thankyou so much. Brilliant. I had forgotten about that. (Just returning to Access after a few years off)
  2. E

    Solved Carriage Return within unbound Rich Text field that will append to a long text table field

    I would like my User to be able to use the Carriage Return as normal (ie without having to press [Ctrl]. at present, using the carriage return "tabs" to the next field. Once a User starts to type within the field (onGotFocus) they are effectively "trapped" within it and have to "Mouse" or "Tab"...
  3. E

    Solved DCount using a Dim reference

    Hi Minty (long time no see) And once again you are my Angel of Sweet Tray !! Mark as complete. I trust you are well, I was just revisiting our old posts (2016) Thanks for your solution.
  4. E

    Solved DCount using a Dim reference

    Hi Ranman I altered my code to this (as suggested) CountNumber = DCount("UniqCONCAT", "tblDataTable", "UniqCONCAT =" & KONKAT) However I get a SYNTAX error (missing operator) in query expression. Thank you for trying to help though. Am I going about this the right way? I just want to check if...
  5. E

    Solved DCount using a Dim reference

    I am looking to create a check to see if a concatenated field is already in a table. It works if my criteria is text but it doesn't work when I'm using a Dim concatenation. Here is my Code: Private Sub Command10_Click() Me.UniqCONCAT = (Me.CQRWeekNumber) & (Me.UserNametxt) & (Me.CQRSite) Dim...
  6. E

    Remove mouse-over text on an image

    Hi all I have an image attachment to my welcome form. The image is the users image. When I rest my mouse over the image I get the prompt: "Double-click to view or add attachments" I would like to remove this? I have tried to change the Data enabled/Locked for the image Restricted the data for...
    • ECEK
    • Thread
    • Replies: 1
    • Forum: Forms
  7. E

    adding my emoji

    Thanks Arne. I researched myself and found the answer to use the attachment approach. Works a treat. Thanks
  8. E

    adding my emoji

    Is it possible to have an image for each person in my database and for that to be shown on a form. ie. so when that person opens the database their image is shown. If you could point me in the right direction that would be great.
    • ECEK
    • Thread
    • Replies: 3
    • Forum: Tables
  9. E

    Get User Name Insert into

    Thank you for your solutions. I used CJ's solution.
  10. E

    Get User Name Insert into

    Im trying to insert a user name into a table on opening a Welcome Form. The error is within the DoCmd.runsql. and on opening the form it is asking for GUN? Could anybody please advise? Me.GetUserNametxt = Environ("username") Dim GUN As String GUN = Me.GetUserNametxt DoCmd.RunSQL "INSERT...
  11. E

    Extract the user into a table

    https://www.youtube.com/watch?v=pJL1CCfvf7s Dealt with !!
  12. E

    Extract the user into a table

    Hi Arnelgp I get #Name? when I use =environ("username") ?
  13. E

    Extract the user into a table

    I've got my name in the top right hand corner but if I use: = CurrentUser() It returns Admin I'm looking to get my name
  14. E

    Extract the user into a table

    I am working on a network where the user of Access is logged in. I want to extract this user into a table. I would then be able to relate this to a table of permissions in the database. How would I go about this? Thanks for your time in advance
  15. E

    Transform my Excel data

    I ended up creating a union query for each field then appending it to Table2 This involved unionising 1 to 40 fields, then 41 to 80, 81 to 120 and 121 to 160. Then Union these Union queries. 40 Unions seemed to be the Max amount. What a ball ache !!!
See more
Top Bottom