Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Patrick1

    Printing contents of tab control

    I have this same issue, have you come up with any methods to get all of the tabs to print, then go on to the next record and so-on? Thanks, Patrick phmurphy@aol.com
  2. Patrick1

    Why is page limited to 22" when using page breaks?

    Greetings, I am pasting multiple pages (5) from a form onto a report with a page break between each page. I am limited to 22" on the report, so only 2.5 pages will fit. I am just a beginner without much training. How do I get all 5 pages to output in a report? Thanks, Pat Thanks...
  3. Patrick1

    How to get multiple different report pages to print?

    HI again, I think I am figuring this out with your leads, but I have another obstacle. As I paste in the controls from the form I have run into a 22inch limit on the total page length and I cant seem to change it. Any ideas? Thaks, Pat Thanks, Patrick phmurphy@aol.com
  4. Patrick1

    How to get multiple different report pages to print?

    Thanks for the lead, but I can't find a "new page control". There is a page break control, but I can't seem to get it to do anything. Any suggestions? Pat Thanks, Patrick phmurphy@aol.com
  5. Patrick1

    How to get multiple different report pages to print?

    Greetings, I had a Form that had multiple tab pages. I copied the tabs to a report, but only the first page(i.e.,tab) of the report will print. How do I get all of the tabs to print? Thanks Pat Thanks, Patrick phmurphy@aol.com
  6. Patrick1

    String edit/replace one record at a time.

    Greetings, Is there a way to do an string Edit>replace All but have it only work in a single record. I find that the replace all goes to all records and I can't seem to limit it to the current record. There are multiple occurences of the replacement in the current record so I know I can use...
  7. Patrick1

    Messy screens

    Greetings, When I am viewing a form and page down the screen is often messy since the previous screen does not fully clear. Any suggestions. I can clean it up my scrolling up and down, but that doesn't seem right. Thanks, Patrick phmurphy@aol.com
  8. Patrick1

    Export my Access97 report as an email and keep the formatting in place

    Greetings, I forgot to respond to MackC regarding the jumbled output in .rtf. I had some problems like this until I realized that each control field must be formatted with respect to justification. I found that once I correctly justified the field (i.e., left-justify or right-justify)...
  9. Patrick1

    Access Report Export to Snapshot Disappears

    Greetings, I have been using .jpg's that are about 300K each. Each report has 2 of these .jpg's. I just converted them to .bmp's that are about 4.5M each and tried to run things again. The exact same issues resulted, with another problem as well. The .bmps look weird in ACCESS for the...
  10. Patrick1

    Export my Access97 report as an email and keep the formatting in place

    Greetings, I have tried the snapshot approach, but with two photos I get zero output. It is a little strange that the program seems to churn, but no file ever is produced. The same thing happens in ACCESS. It seems to process the graphics, but where do they go. I have done searches on .snp...
  11. Patrick1

    Access Report Export to Snapshot Disappears

    My problem is that the output files will never be that small. It seems that this needs to be a priority for Microsoft if interoperability of data is really their claim to fame. Thanks, Patrick phmurphy@aol.com
  12. Patrick1

    Access Report Export to Snapshot Disappears

    Greetings, I keep trying to export a report that includes linked photos to a snapshot file (.snp) but the file never appears. Access acts like it is doing the export but the output file is nowhere to be found. I have even done a search for any .snp files. Any ideas? Thanks, Patrick...
  13. Patrick1

    Export my Access97 report as an email and keep the formatting in place

    Greetings, I am having this same problem, but I am trying to get linked photographs to print to a Word97 document. All I get is the text in the .rtf format. I have Adobe Acrobat (the software, not the free reader) and have created the .pdf file, but I want to incorporate each page separately in...
  14. Patrick1

    Linking different images with each record in a report.

    The FAq was How to Load a picture in Access form faq181-279 Thanks, Patrick phmurphy@aol.com
  15. Patrick1

    Linking different images with each record in a report.

    Ah Ha - I figured it out. There HAS TO BE A TEXT BOX ON THE REPORT! You can't just reference the field that holds the file name in the table, you have to have a text box ON THE REPORT that has the field assigned to it. Whew. Thanks, Patrick phmurphy@aol.com
  16. Patrick1

    Linking different images with each record in a report.

    P.S. The actual error I keep getting is "can't find the field...". I am using the following line of code that I got from the FAQ's on this topic. Me!Photo1Frame.Picture = "G:\Ecotone\Clients\Colorado DNR\AAA Projects2001\MuellerVEG\ProcessedData&Tables\" &...
  17. Patrick1

    Linking different images with each record in a report.

    Greetings, This must be ultra basic, but I can't figure it out. I need to link different images with each record on a report. I think I can probably use a field to hold the file name, but I can't get the image to appear in the report. Any guidance? Thanks mucho. Thanks, Patrick phmurphy@aol.com
  18. Patrick1

    Linked Images in a Report

    I forgot to mention that my last error was Microsoft Access can't find the field 'Vegetation_Plots.Photo1' referred to in your expression. Perhaps I have referenced this wrong, Is it supposed to be Table.Field? The table and field both exist but somehow are not seen. Any ideas? Thanks...
  19. Patrick1

    Linked Images in a Report

    Greetings, I used faq181-399 to try to figure out how to insert images into a report, but I am not haveing any success. I want a .jpg image that is stored in a field called Photo1 for each record, to be shown for each page of the report. In the above referenced faq it states to: In the...

Part and Inventory Search

Back
Top