Recent content by Shinken

That did the trick. You get a big gold star. After doing some research on converting from v1 (Access 97) to Access 2003, I was very surprised that I was able to just open/convert the DBMS file with only this single issue to correct...but then again, there may be more surprises after using it...

One of my clients is still using Access 97 to run a DBMS that was written in Access v1. They (finally - whew!) want to upgrade to Office 2003, or possibly 2010. I've had a surprising amount of luck just importing it into Access 2003 - the menus, reports, etc seem to run OK. I then saved the...

I recently installed Office 2003 Pro (incl the Office SP2 update) on a new computer and moved my data to this computer. Both the old and new computer are WinXP Pro + SP2. Other Office apps (Word, Excel, etc) seem to be running fine, but whenever I attempt to open one any of several .mdf files...

I recently installed Office 2003 Pro (incl the Office SP2 update) on a new computer and moved my data to this computer. Both the old and new computer ran WinXP Pro + SP2. Other Office apps (Word, Excel, etc) seem to be running fine, but whenever I attempt to open one of the .mdf files I've...

I need to insert the results of a somewhat complex query (6 UNIONs) into an Excel spreadsheet so that the spreadsheet can be refreshed. When I attempt to insert the data query into Excel, only basic queries are displayed, not queries with UNION statements (having the linked ring symbol). Is...

WHAT I HAVE: I have several year-to-date crosstab queries that look like: qryGrubType GRUBTYPE...Jan...Feb...Mar...Apr......etc Goobers.....1.....5.....9.....2... Snooters....2.....3.....2.....3... Gnots.......3.....8.....5.....9... qryFoobType FOOBTYPE...Jan...Feb...Mar...Apr......etc...

Eureka - I've struck gold. Thanks to everyone for the replies. The winner is RASKEW - thanks much! Your code produced exactly what I was looking for. Also, the Age() function was elegant, saving me from having to use #xx/xx/xx#. Shin

I have a table with several checkboxes, to denote tests passed. A checked box denotes a passed test, an unchecked box denotes a failed test. For example: [ ] part1 [ ] part2 [ ] part3 [ ] part4 [ ] part5 Another table lists the participant's characteristics, such as Date of Birth...

Giacomo, Thanks. "Publish as a Word Document" is just what I was looking for. Shin

Is there any way to bring data from queries into MS Word? I need to create lengthy, verbose reports, that include charts and selected data from an Access database. Microsoft Word is much better at this type of report, as they are essentially Word documents with graphs and selected data...

WHAT I HAVE: I have a crosstab query setting up a year-to-date grid. There are 6 rows (grouping table by 6 allowable string entries), and 14 columns. The columns in the query are Description, total of each description, and then Jan, Feb, Mar, etc. The result is a query I can put into a...

Correction to question OOPS, the formatting of my posting needs correction. Here's an amended posting. I need to make a crosstab query that displays rows from several fields(columns) in the table. Given a table with string-type columns(fields) for gender, type and location, each with entries...

I need to make a crosstab query that displays data groupings from more than one column(field) in the Given a table with string-type columns(fields) for gender, type and location, each with entries limited to those in a value-list, and also a date column(field). I need a query that will total...

I'm trying to set up a report that looks like this Jan Feb Mar Apr ..... Male 1 3 2 3 Female 8 0 4 1 TypeA 1 3 2 3 TypeB 9 1 0 11 TypeC 3 1 3 1...