Search results for query: *

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

Thanks! There was no need for another field -- your code worked perfectly! That's two I owe you.

Hi. I have a report based on grouped records. By way of illustration, let's say the records conceptually look like the following: Record 1 belongs to Group 1 with Option = False Record 2 belongs to Group 1 with Option = False Record 3 belongs to Group 1 with Option = True Record 4 belongs to...

Does your form have navigation buttons? Does it acurately show the past records as currently designed? In what mode (eg acFormEdit) was it opened? If the answers to these are what I expect, you might try this code on the button's click event: DoCmd.RunCommand acCmdRecordsGoToNew Hope this...

OK, I'm not sure how that last step helped, Duane, but IT NOW WORKS PERFECTLY! YIPPEE!! Thanks, Duane. I think I will get the book; it seems OK and I *am* trying to learn this stuff, after all. Thanks again!

I'll look into your suggestion; but until then, I'd like to get somewhere with what I'm doing. The reason I added a list box (or combo box) to my form is to allow me to choose a group to view/edit/add to. That was what I've been trying to accomplish all along. I hate using Access' built in...