Recent content by Playfulmutt

This is an odd twist of events. The person who asked the question found the answer, but I wouldn't have gotten around to it if JHB didn't chime in about the # character. It wasn't my first choice, so I opted not to change it. After I did, however, everything fell into place. Let this be a lesson...

I'm really close. I can almost taste it. I took your advice, JHB (thanks for the second opinion on that) and used the Letter Type field (which I changed to Last Correspondence because the VBA doesn't like the word "type."). This is what I have now. Private Sub Compose_Click()...

I don't doubt that using special characters is a bad idea in programming, but unfortunately I have to work with what I have. The original form that this button is on is actually several forms--each end user has their own data entry form whose control source is a query for their own caseload...

Hello! I'm having some trouble opening a group of forms using a combobox. I think I'm really close, but I'm having some errors that prevent me from doing so. I have a Combobox called "Letter Type" that contains the names of all of the other forms that exist. I want to be able to select a form...

Now you're stepping out of my realm of knowledge. :) I don't suppose you know of any resources for creating such a document? I can google on my own, but if you know of any resources that apply directly to my current situation I'd like to give them a look. Thanks for providing a resource that...

I see what you're saying now. However that is "pulling resources out" of the database. Bosslady really wants to keep everything that these workers do inside of the database. Also pulling those Access fields and linking them to Word fields undermines programming that I have done to...

What I tried to do is use the Listbox to shift the MS Access memo field in one table into an unbound text box on the correspondence form. Because memo fields can't show up on the Listbox columns it won't work. I can change the memo field to a text field, but then it will be limited to 255...

Access is a dynamic database. There's more to it than records. I have never used Dlookup before. My two concerns with that are: 1. Can I use it in tandem with a Listbox/ComboBox to allow the workers to select the letter type that they want? 2. Can I use it to populate the unbound field without...

Hi, all. I'm new here, and actually registered for this problem alone. I'm very new to SQL but I have had my boots on the ground with Access for a while now. I am programming a database for a reorganized group in my office. The boss wants everything highly standardized, which is where I come...