Search results for query: *

Thanks for your replies. I haven't had a chance to try them out yet, but I'll let you know how I go. Thanks again, Rob

Hi I would be grateful for a little guidance or a nudge in the right direction on this. I haven't got a lot of experience using SQL but I'm keen to learn.. I've built a database that collects some questionnaire results. Each question has a field in a table (eg, Q1, Q2) and there are 6...

Woohoo! I just wasn't thinking about the subreports OnOpen event being called more than once, so the instructions on MS website to not attempt to change the recordsource after the first time, worked perfectly for me. Thanks! This has been taking over my job for a few days, and given me a...

I have a report containing 'Actions' linked via an 'ActionID' field to a subreport containing 'Progress'. By default, the subreport repProgress lists all the Progress records for each Action. However, on a form, I want to give users the option to see the same report, but with the latest...

Did anyone have ny joy with this? I've got a similiar query today..I want to change the recordsource of a subreport, based on the value of a checkbox. Any help much appreciated!

Thanks for that! I'm pretty new to Outlook and have found myself with 100 people at work to help out (and 100 digital certificates to apply for, install and backup..joy..), so I'm having to learn quickly!

In Lotus Notes, I was able to email links to files on the network without displaying the whole path - you could 'hide' the path behind some more sensible text, eg 'Click Here'. We've now switched to Outlook 2000, and I've found out how to send links to files, '<file:\\etc...>', but it can look...

BeforeUpdate allows the data entry to take place..but runs the code before the actual record in the table is updated, giving you the chance to check it and cancel the update. Anyway..lift is waiting..I'll try something tomorrow if you've had no luck.

Just a quick thought before I leave for home..would it be better to run the code with the event BeforeUpdate, rather than AfterUpdate?

My Thanks to both of you! It worked with the original code, but I'll be changing the strip routine soon as suggested. I know this was a relatively straightforward bit of code, but thank you very much for helping, because going through it has helped me to understand a few more things now. Cheers :)

Firstly, apologies because I am very new to VBA! I have various tables, eg tblOrders, tblDeliveries which contain the field PartNumber. As they come from different sources, sometimes the PartNumber field will have been populated in a different manner, eg with spaces, dashes etc, and without...

Thank you for your reply. Unfortunately, I forgot to say that here at work, we're still stuck with Access97, and I think I need to work here for another 5 years before I get the chance to apply your solution! For now I think I'll just have to have a slightly busy form footer with all available...

I currently have a continuous form, with combo boxes on the footer allowing users to select records by setting criteria for particular fields, which are used as criteria in the select query (which the report is also based on). However, as there are a lot of fields that they would like to search...