Recent content by lnoles

Where can I find a sample database that uses a zipcode table to autopopulate the City and State in another table after entering only the Zip? I am just now trying to learn about relationships and am so confused...

I have a Long report that I want to export to HTML. When I do this, It breaks the report up into several pages with links to the Next and Previous pages. I then have to merge all these pages and delete the links. How can I export directly to a single HTML page?

I have several long reports that I routinely export to HTML for use on my web site. When I export them, They automatically separate into several pages with links to the next page. I end up combining them manually. How do I eliminate this? I would prefer to have it be just one long page.

Just go to the Design View and insert a report footer. [This message has been edited by lnoles (edited 07-20-2000).]

The only 2 ways I got around this problem was to either use Adobe Acrobat or Micorsoft's Snapshot viewer. Both require the recipient to have a plugin on their machine. Snapshot is free from Microsoft and the viewer for pdf files is free. You have to buy the Adobe Acrobat Writer.

just a shot in the dark, but, make sure you have plenty of free disk space. If your disk is getting full, there is no room for Temporary files.

I would add another column in the query for the sub-report and concatenate the results of the other columns into that field. Then uncheck the other fields so that the new one is the only one that shows on the report.

In the Detail section of the design view of the report, Right-click and choose 'Sorting and Grouping'. Then, click in the 'Keep Together' field, and choose 'Whole Group' or 'With first detail'.

Adobe Acrobat is the solution I used. You could also export to a Snapshot file, but, you have to have the Snapshot viewer installed on the computer being used to view it. It is available free from microsoft.

Click on File in the menu, then click on Print. This should bring up the dialog box...

Try using Adobe Acrobat and save your report as a PDF file.

I have a report having to do with a span between cities. The problem I am having is getting the report to automatically show the span. line 1 will show City_A followed by other info. Line 2 will show City B , Line 2 City C , etc... I would like the Second line to show 'City A to City B'...

I want to send out a report, via email, without having to send the entire database. When I send or export the report to Word, Excel, HTML, etc... The data comes thru, but, I lose the formatting and lines, boxes, etc... I tried using the 'Publish it with Ms Word' with the same results... Any...

I tried this with my report, but, the formatting and lines and boxes did not carry accross. What I need is for the report to be in a format where I can email it to several people and they can see the report without having to have the entire database. I suppose I could use Mail Merge, but, I...

I have a report that includes info on spans between cities. I need a way to have the ending city from the 1st line, in the report, become the beginning city for the 2nd line and so on. I know I could add another field in the Table, but, I hope I can achieve this in the report instead.