Search results for query: *

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

Hi All, I'm having the same problem with truncation when I use a UNION query on a memo field. Here's a simplified version of the query: SELECT program, desc as X FROM programs UNION SELECT oldProgram, desc as X FROM oldPrograms; program and oldProgram are text, desc is memo, and gets cut...

Thanks. I've been struggling with using INDIRECT to get to the right named range of the right named worksheet of the right workbook, and embed that into a fairly complex INDEX / MATCH() / MATCH statement. Which I've done. Phew!!! vjh

Here's a 'cheating' answer... but it works - assuming that E1 is your cell reference with the value you're looking for. =COUNTIF(B1:B21,CONCATENATE(">=",E1)) ... vjh

Hi all, I have a workbook that collects information on a monthly basis - a separate one for each month, based on a template I've developed. For some biweekly reports, I need to extract data from the previous month's worksheet if the date falls outside the current month. How do I tell it...

Thanks Jeff, It worked the first try. (Or at least once I got all the typos out of my code.) v