Recent content by CantDo

Gerry, Thank you once again! Works like a charm! I tried giving you another star, but I don't think the system lets me do that more than once per user for each thread. Sorry. You deserve two.

fumei: Thank you very much and Happy New Year! This approach works fine and accomplishes what I need. However, it has led to another problem (why is that always the case with programming?) ;) In order to use the code you suggested, I needed to first unprotect and then protect the document...

I have a Word 2003 SP2 template document that has boilerplate language. I have coded popup Message Boxes to gather information from the user and, dependent on that information, I need to choose from alternate clauses to insert into the template. I have set bookmarked fields to act as...

Thanks, Remou. I had seen that FAQ before, but it doesn't seem to help me. I think this is because it requires a tag for each list, etc. In my case, the lists are unbound and obtained through a form query selecting several fields across several tables that have relationships to one another...

Your code above appears to be able to work for one list, but in my situation, I have multiple lists (and a date control). So far, I have created the following code which works fine, albeit inelegantly. If anyone knows of a more elegant solution, I'm all ears / eyes. :) Private Sub...

I have a form for filtering data on a report. The form has several list boxes with multiselect set to extended. I want to pass any or all criteria selected on the form to a report so as to filter results based on the user's desires. If it were only one criteria, the solution would be simple...

Thank you PHV! Your solution is simple and works perfectly -- I can't believe I missed it! Thanks again.

I have a database where multiple entries are made on a daily basis. On my main form, I have a calendar control (unbound) to allow the user to choose a date - defaulted to current date. There is also an option group (4 options) allowing the user to choose the day, week, month or year related to...

Sorry its taken me so long to follow up on this thread; I've been away. But the problem remains! htmlman: jumper settings and drivers are fine. The computer sees the drives -- it just won't read any media until a reboot (with the media inserted). This happened with an old CD writer/ DVD...

I'm working on a computer running Windows XP Pro SP2. The system has a Pentium 4 1.5GHz processor, 512MB 133Mhz SD RAM. I've installed a USB 2.0 PCI card, a Sony CD/RW-DVD-Rom Drive and a Samsung DVD +/- R/RW drive. The computer sees all of these devices OK (in harward profiles). The...

I'm not sure if this is possible, but here goes. I have an Access database with several tables. In basic terms, the database contains names of individuals, their contact information and information concerning Group Memberships they belong to. My users want an ability to generate form letters...

AceMan, something you said above -- "be aware: subforms open first!" -- just solved another problem I was having! I gave you another star for another hidden gem in all the help you've given me so far. Thanks again!

BTNewman: I don't understand. What problem are you having? I basically followed the advice set out above and, the last step from dhookom did the trick. Of course, I first had to make sure my tables, relationships and forms were designed correctly (as described above). If I can help further...

Ignore this post. I got it to work now. Thanks.

I've read a lot about others having this problem, but none of what I've read is helping me with my problem. I have a main menu form which opens at startup. On that form is a button which is supposed to open another form for a new record. The code behind the Click event for this button is as...