Recent content by vjh

Gerry has gone above and beyond on this one! And I concur, the document is a nightmare. It's been giving me headaches for days. ... vj

Sorry for being so confusing, a reflection of my state of mind on this. In answer to fumei's comments: Please quit using "header" when you are talking about tables. Header is a very specific thing in Word, and it has nothing to do with tables. I have actually been using "header" in the...

Uh-huh. They set this up when they printed this a few years ago, and this is how they want to see it. It's a small non-profit that I'm volunteering for, and have inherited a number of quirky things from. Including this! vjh

Yup!

Thanks for trying to help with this, Skip. The HEADERs are different levels of categories, as specified by the clients database, and the Organizations are grouped into the various categories. When the category changes, and new sub-sub-section name and possible sub-section name is generated. I...

I should have explained better what my table looks like... because repeating the heading rows won't work The table isn't a spreadsheet-like table, and the section titles aren't column titles. Mostly the 'table' has only a single (spanned) column, with two columns for the address and contact...

Hello all, I have a document (in Word 2000) downloaded into a table from a client's mysql database. My client wants to reformat the entire thing (~600 pages) with three levels of headings which must appear on every page. Here's what I need to appear on each page (and each of these has its...

Not perfect, but simple and I can easily work with the results! ... Valerie

Hello all, I have a web page (generated dynamically from a mySQL database) formatted using an external style sheet. My non-profit client would like to be able to download this into a word document preserving the formatting as it appears on the web. I have tried copying the HTML into word...

Hi all, I'm looking for something to automate the tedious process of creating and then processing a form with every field from a query and individually specify how to show each field. Any suggestions?

Hi All, I'm trying to create a function where I generate checkboxes by querying my database, putting the data into a string variable that is the proper format for the argument for creating the array I want. But it doesn't work! If I do this: $ckbx=array('1'=>'Book or Booklet','2'=>'Extension...

Hey guys, Thanks for your help on this... I'm almost there, but can't quite get the join query to work in Microsoft Query. I've never used it before, so bear with me! Individually the queries return the desired result, but they won't join. I get an "error in the Join Clause" error. Here's...

Hi All, I'm trying to automate a process I've been doing manually. Essentially, I have two source workbooks, I copy over two lists, merge them together, sorting and deleting duplicates. A simplified view Wbk1 ColA ColB ColC Fred 35 Jack 40 Jane 45 Wbk2 ColA ColB ColC...

Can you be more specific??? vj

Your solution also worked for me. My query was relatively simple, but the UNION truncated my memo field. Seems a bit of a roundabout way of going at it, but since it worked, I'm happy! Thanks for posting your solution. vj