Recent content by bartmanekul

  1. B

    Get User

  2. B

    Get User

  3. B

    Get User

    It does, yes. It was the easiest way I can do it without knowing coding/expressions. I've desensitised the data (hopefully there's enough in there to show). The Query in question is 'Outstanding personal'. Many thanks for your time.
  4. B

    Get User

    Not sure how to code that - but interestingly, my results on the report are now showing other people's records, when they should just be mine. I don't think there's been any updates, and we are using office 365. When I was testing on my machine (under my logon), it only showed mine, even...
  5. B

    Get User

    This, I got it from the net, and it seemed to be working fine, until today (I cannot code for various reasons) Public Function GetUserName() As String ' GetUserName = Environ("USERNAME") ' Better method, see comment by HansUp GetUserName = CreateObject("WScript.Network").Username...
  6. B

    Get User

    Hi all, I've been using: GetUserName() in the criteria of a query, with a report based off of it. In the field it's a criteria for, it's only populated by system usernames, i.e. firstname.secondname It works fine on my computer, only showing the records which has my name in. But on other...
  7. B

    Display last Record based on person

    Thanks for all the replies, just wanted to give an update. I thought a lot about it and the data, and while I can't deviate from the reference numbers, I can change the names (as there's only a few users). So I've renamed the 'People' to match the windows logons, and display the last record...
  8. B

    Display last Record based on person

    Thanks. I've tried doing it, but I'm not up on the finer details (FWIW I've never learnt to code due to dyslexia). I assume this is what I need, I've tagged the fields which are required with 'Rqd'. But not sure how to substitute it into the code: Private Sub Form_BeforeUpdate(Cancel As...
  9. B

    Display last Record based on person

    Thanks, I will look at examples of that one and customise.
  10. B

    Display last Record based on person

    I've worked with databases before, so I'm reasonably familiar with how they should be set up etc, and linking tables and so forth. More so, the need for clean data and restricting the ways they can be entered. Access tends to be so unforgiving. I'm not having trouble adding records - as said...
  11. B

    Display last Record based on person

    No...the issue is awkward, with this one I don't need to link anything to sage/access. I'm trying to negate something else. The form is for adding a record - but knowing the users it HAS to only update on a confirmation (i.e. add new record), rather than just maybe putting one thing in and...
  12. B

    Display last Record based on person

    Very funny....I'm not comparing it to brain surgery or rocket science! I went from knowing a maximum of what dollar signs do to being able to pull data from sage and do all sorts in excel - but I don't get why Access is so horrible to work with. Perhaps it's because excel seems far more...
  13. B

    Display last Record based on person

    Thanks for the code, sadly it appears access is a horrific program compared to excel, and is well beyond me. I don't even know what to do with the code you posted. Thought I could learn but it's not proving very friendly. It's frustrating as I've been able to work out pulling data from sage and...
  14. B

    Display last Record based on person

    Realise I missed the questions, apologies: Only login is the Windows login. The sequential numbering is just to differentiate the numbers, for each individual. While it does indicate how many they have done, it's not used in that way as it can obviously be different over time. I.e. someone on...
Back
Top Bottom