Recent content by Tay

That's not something I'd considered - I'll give it a go. Thank you.

I can't easily post a copy of the db, but I've attached the relevant portion of vba in the attached rtf. The form itself has a fair few other similar listboxes (and heaps more vba), but the one I'm interested in updating with cboDataSource is called RecentUploads. I thought I'd try and get one...

The option buttons weren't set up as an option group. They each have on click events. The form's Load event also refers to these two option buttons. Does it make a difference that they're not in an option group? I can't think that I've ever put an option group (or option buttons) on a form...

I've been asked to improve functionality on a form that someone else has designed. Currently, there is a multi-column listbox that can be filtered by two option buttons. Checking one button will display all records, checking the other will display the top 100 records for the user who has logged...

Thanks. I'll have a look at that when I'm back in the office on Tuesday. p.s. did you used to have a Marvin the Martian avatar?

Apologies if this has been covered before; I have searched, but not found quite what I need. My report is based on a crosstab query. I have a couple of calculated controls which calculate percentage accuracy rates (based on the number of checks a person does against the number of errors they...

It's clearly been a while since I've been on here with any regularity... where did the Watercooler go? Or am I opening a can of worms by asking that?

Gosh, 10 years already, and still using Access! I bet there are other AWForumites who've been members here for considerably longer than I have. Thanks for all the good advice!:)

Not my thread, but I'd just like to say thanks for this code. It's helped me out with the db I'm currently working on and I need it in another too. Cheers!

Wonderful - thank you all for your replies. user_name = Environ("username") did the trick nicely. I always split my dbs, but others here don't - hence the problems experienced by users.

I've done a quick search, but as I'm not really sure how to succinctly explain what I need to, I'm not able to find what I need. Here goes... I have a regular group of users who need to access a db to log enquiries. Chances are, there will be three concurrent users all day, every day...

Back at work today. Ran the query on my machine = crashed it. Ran it on another with less memory than mine, ran in about 2 minutes. And ran it on another machine with the same spec as mine and it ran in around a minute and a half. Tried it a few times on the other machines and logged a call...

Right. Tried it on a couple of machines at home. On the oldest (with just 128 meg of RAM) it ran in 12 seconds, and on a newer, more capable pc, it ran in 9 seconds. So, I shall try it on a pc other than mine tomorrow to see if there is any improvement. I will keep my fingers crossed that...

I've got the day off work today, so will try it on another machine tomorrow (and will see how it runs at home). I believe that my db is properly normalised (or as near to it as can be), and is nothing like the original spreadsheet. Hopefully, that's not the issue. It's just odd as the...

Famous last words! Running the same final query today, my machine crashes every time.:rolleyes: Thanks, Galaxiom. SQL isn't my forte, but I think that this isn't the cause of my problem? I've pasted the relevant bit below from my initial query. WHERE (((tbl_Main.Date) Between [Type the...