Recent content by Franki

Nope -- won't work. The "client name" isn't generally a formal name -- the 3 part names are in the address listing. If we are representing an individual, the client is identified by his or her last name, with a first name included for further clarification; if we are representing a company, it...

OK, I need to curb the tendency of an overenthusiastic and somewhat dense attorney to madly add new client identifiers to my database. For example, although "Smith, John" had already been entered as a valid client name, and a client number assigned, this attorney (working with a combo box...

The code link Chris sent me is... dense. But I think something like that will allow me to trick the other users into thinking they have never left Word at all -- start and end in Word, using VBA in Word to shut down Access after all is done. I am going to need more help, though. I've learned...

Ritchie -- there are several reasons for not just doing it all in Access. One major, major reason is that my solution needs to be user-friendly for both secretaries and lawyers alike; the easier I make it on the lawyers, the more of their own routine word-processing they will do. 2nd, we are...

Chris -- I can't find your link, but did a search and found the Smart Access newsletter; good stuff, it may give me some more hints.

Thank you, Trevor. This gets me one step along the way -- at least I can get Access to open from Word (instructions from other places got me no where). One small step... one small success... gives me hope, at least!

Thanks to the help of the many Access gurus online, I have built a custom rolodex which is a almost litigation secretary's dream. It's been a steep learning curve the last few months, but I've done it. Now, I need to make the final hook-up. Specifically, I need to be able to import from...

I am setting up a docketing form for our law office. When we have a multi-day event, such as a trial, I would like to use tags on the controls to carry forward the values for that event, adding one day to the start date, until the start date equals the end date. There are four controls on the...

Thanks Jack -- works perfectly. The Goddess is now happy (at least about that one) -- and I at least kind-of understand how it works. Also loved the download of the Shakespearean Insulter from the same site -- I've done theater BC (before children), and work with a load of theater people.

I don't think I can use autonumber for strClientID because the numbers are inherited from 25+ years of my boss's law practice; most clients are around briefly, but we have a few that we've represented for years; thus, I have one active client with an ID number of 014, but the new client account...

The next problem: I've done enough digging to know I need to use DMax to accomplish my next task; but I'll be damned if I can figure out how to put all the parts of DMax together. tblClients includes 4 fields: strClientName, strXeroxAccount, strClientID (the primary field), and strActive (a...

Please be patient. The more I dig into Access, the more confused I get. I did fine on the table design part -- but trying to translate help files and manuals (are they written in Sanskrit?) into practical solutions is proving beyond me in the form design. I will limit myself to one problem...