Search results

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.

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

I've had other things pop up higher on the priority list, but will try that when I can. I'm not sure how to actually implement it, so that will take reading up on. I'm coming back to access after over 2 decades. There is no sync, this is why people have to enter it in manually. I won't go...

Apologies for the guesswork, I didn't want to write war and peace in the intro, but I see I was lacking in a lot of details. There are about 6-7 users. The quote quantity isn't huge, worst case 15 a day so the database won't be massive. Quotes are done on Sage, and the company insists on...

Yes, I'm very experienced with users thanks. This is precisely the reason I'm doing it. I'm going to display the last number they used, as I thought it was the easiest way. It's the current way they do it on the spreadsheet, simply by looking at the last one they used. My other thought was...

Thanks. I know it would be better otherwise (and it would make my life a lot easier), but that's already the format of the quote numbers (and many other things). So a lot of existing data will be added to the database with these formats already used. I've already thought of splitting the...

Thanks, that's a function I can use. But not sure about the criteria - I could be smart and tie it to the windows user logon, or simply create a drop down for the user to choose. I can probably work out how to do the drop down, but not sure how to reference it in the criteria. In case it's...