Search results

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

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

Thanks Mark. I'm sorry to come back to this thread so late; I was off work and only returned today. I checked the relevant fields and indeed you were right, I'd failed to index them. The initial query now runs in a couple of seconds, with the final query taking just over a minute. At least...

I wasn't sure of the best section for this, so opted for 'General'. I have a db which records the results of accuracy checks across different workstreams carried out in our organisation. Aside from the accuracy side of things, it also logs date information. For three workstreams, I need to...

Sorry for the late reply; I've not had a chance to work on the db recently. I had tried this originally, but had (now obviously) grouped on the wrong field. Doh. After seeing your reply, I tried again - this time grouping on Check_ID... then I realised my mistake. Thank you for helping me.:)

I've created a database to record the outcome of quality checks that are routinely carried out on several workstreams. This db replaces an 'Excel database' (several linked workbooks) and while the structure and data entry side of this seems sorted, the reports I need to replicate are not. The...

Thanks for replying, and sorry to have wasted your time. Although indirectly, you did help me as your reply prompted me to paste the code... I opened the wrong module and found inspiration there! I was missing something really basic - I'd not enclosed the required email address in quotes...

I apologise in advance if this is a stupid question. In one db, I have a form where users can choose an email address from a combo, then press a button to send an email to that person. This works perfectly. In another db, I want to do something similar. The difference here is that the email...

Thanks for replying. What you have suggested is what I'd been asking (badly) to see if this was a possibility. We do have our own 'drive' on the network in which we are allowed to save documents. Presumably, this is what you mean? The_Doc_Man also felt this would be an improvement on what I...