Recent content by ZollerWagner

Hi, I have saved a new template to the right folder: C:\Documents and Settings\USERNAME\Application Data\Microsoft\Templates Then when I try to open a new document using that template, the new doc is empty. (It doesn't show the content of the template). I've uploaded this template to other...

It may be the answer to this question is here: http://www.tek-tips.com/viewthread.cfm?qid=899790 This solution looks a bit like yours, but uses functions to make it more powerful and flexible.

With the help of another person, I've finally found the answer. You have to create a function that tests the data for IsNull, sets up the text for the text box, and adds any needed spaces. Here's an example: Function AddressBlock$ (AName, Addr1, Addr2, City, State, Zip) Dim A1$, A2$, A3$...

After more experimentation, it seems to me that part of the problem could be that the setting for the TOP property is set so that a subreport begins at a specific spot on the form. Maybe I should have them all placed at the same spot on the main report? In other words, should I set the TOP...

Matethreat, how do you set your properties (can grow, can shrink, auto resize, etc.) so this works? I'm getting very inconsistent results. It's not clear to me where to set these properties (on the subreport, on the detail of the subreport, on the field in the detail of the subreport, etc.)

Wow, sorry about that. I'm still having trouble with this too. It seems as though the "can shrink" and "can grow" properties have some effect on the amount of space taken up, but the results have been very inconsistent for me. Sometimes I can get the space to collapse and sometimes I can't...

In my experience if there's no data, there's no space used by the subreport. Give a try and let us know how it goes. I understand your skeptism because I didn't think it would work either.

Or, here's a simpler solution: http://www.tek-tips.com/viewthread.cfm?qid=900053

That's exactly what I needed to hear. I don't see any reason to have additional tables given the data. The services each organization offers are comments transcribed from a survey. They are specific to each organization. If the subreports don't require separate tables, I'm axing them. Thanks...

What if you create a text box in your report and use code to write yes or no depending on the value in the checkbox's table entry? To do that, add code to the main report's Detail area's Event On Format property. I'd think it'd be something like: Private Sub Detail_Format(Cancel As Integer...

I'm not the one to describe how to do this because I'm struggling with it myself.... But if you show the fields that might not have data in their own SubReports, then you can place code to cause a SubReport to not be shown if there is no data. You have to place the code in the main report's...

Thanks, Duane. That really works! The structure is, in fact, causing me problems. I thought that to use SubReports, I'd have to use separate tables to get the data to the SubReports. Is that not so? The information on each organization's services tends to be different, so it's a 1-to-1...

Hi, I'm creating an Access 2000 report that lists organizations, their contact info, and the services they provide. There are separate fields for each of the different categories of services. Most of the organizations don't have services in every category, so I want to be able to print out a...

After a lot of misery, I've decided that the problem is with using history in the input element. Am I correct in assuming that php isn't able to transparently add the session info to the history ref in the following? <input type=&quot;button&quot; value=&quot;Edit&quot...

I'm developing a site that has several PHP features. One of them allows a sender to mail an e-card to a friend. I do a lot of input testing to be sure the user inputs are clean and safe. At each step, I give the user the opportunity to go back and revise their inputs, or to start over. On the...