Search results for query: *

Nested TOC I have adapted the procedure in MS Article 210269 (How to Create a Table of Contents or Index for a Report - See above) so that my report writes to four tables. The aim is to have a TOC with up to four nested levels. It seems to make sense to rename "Description" in the module to...

I had someone else design my database back-end and I have been adding to it since then (using baling twine and rubber bands). I am limited in my understanding of the design and even more limited in being able to explain it. Neverthless: I have a single table that my TOC (courtesy of MS Article...

Thank you 'AceMan1. I have followed your advice. However, I have now managed to get a TOC working. There were a number of errors I sorted out: correcting some spelling mistakes; making sure that field types matched; replacing a linked TOC table with one that is in the parent database; and...

TheAceMan1, The MS link you have provided states that it applies to MS Access 2000. It was reviewed in 2005. Is it safe to assume that it applies to Access 2003? I have followed the procedure accurately (and had someone else check as well) but, on print review, I receive an error message...

MajP, I am an absolute novice. Could you please tell me how I "write to the table"? Is the sub-form based on tblTOC? Many thanks RodH

I am attempting to use the same procedure as mmogul. As well as the on-print condition, the MS procedure requires =InitToc() as an on-open conditin. I already have InitVars() as an on-open condition. How do I have both? E.g Do I simply cut-and paste from InitToc() into InitVars()? RodH

That's the problem I also have. Have you found a solution yet? RodH

Thanks for your reply MajP. The 5 comment fields were provided so that some of the "Main" tables (of which there are approx 20) could share the same comments. E.g. some comments are unique to some tables, but various combinations of other comments are shared by various other tables. I must say...

I have a mainForm (for tblMain) and a subForm (for tblComments). A text field (control source "Comment") in the subForm populates tblComments with that text (comments). The keyed autonumbering extends from 1 to as many comments as there are in the database, of which tblMain is but one. A...

Thanks Duane. I've found an effective, although not a programmatically elegant, improvisation by inserting ALT 255 at the end of the text (an invisible ASCII character). Rod H.

I have several identical text fields in a table. I want the same text to appear in reports, but I have ascertained that I need to make them unique in the tables. One way would be to add a unique suffix to each field. Is there code I can insert in the table text field that would make the...

Problem now solved in either of two ways: 1. Non-programatically by saving reports to Snapshot files; 2. Programmatically by modifying the database design, motivated by Duane's comments, and eliminating one of my modules. Thanks Rod H.

I think my question comes down to this: Assuming that the use of a module is an appopriate way of achieving my footer total named [Group2Total2] with control source =GetGroup2Total2(), what code do I need to insert into the report's [EventProcedure] on Format so that the correct result shown...

Duane, I should have added, the reason for choosing the module method was that my "CountofAction" function is a result of another module that adds a quantity to the Count(*) function. In other words, "CountofAction" is not a simple aggregate function. Rod H.

Duane, Thanks for your reply. I have provided what I hope is sufficient info. below. My apologies if it is still inadequate. I only used the module because, of the three options suggested in http://support.microsoft.com/?kbid=208850taed , it was the only one that I could get to work. However, I...

I have totals calculated from a module function as per http://support.microsoft.com/?kbid=208850taed It works fine - except for one thing: the results when printed are different. Moreover, the results vary from that correctly displayed in the report depending upon whether I print from the open...

qscma1, I found my answer to this question at http://support.microsoft.com/?kbid=208850 I created a module that works fine.