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 strongm 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: *

  • Users: pattyjean
  • Content: Threads
  • Order by date
  1. pattyjean

    Access Export with Formatting PDF Report using a list box

    Access 2010 I am using a list box to export with formatting report to PDF but I would like to include the selected item from the list box into the final report path name. Is this possible? Thank you for your review.
  2. pattyjean

    Access Report ExportWithFormatting Output PDF File name to include field from List Box

    Access 2010 I am using a list box to export with formatting report to PDF but I would like to include the selected item from the list box into the final report path name. Is this possible? Thank you for your review.
  3. pattyjean

    Adobe PDF and Hyperlinks OPEN in New Window

    We have approximately 3000 attachments that we have to hyperlink into different word documents with the final product in pdf (maintaining the hyperlinks). The final documentation will be on flash drives to 7 different reviewers. We can save the word to pdf and maintain the links in pdf, but...
  4. pattyjean

    Extract all hyperlinks from a Word 2010 Document

    I would like to Extract all hyperlinks from a word Document to list them all in one document.
  5. pattyjean

    Links in Adobe

    We have over 1400 links in a pdf document that points to other documents in a folder. Every time we use different computers the links follow that path. Any ideas of how to make this process work?
  6. pattyjean

    Checkmark in Access Report

    Access 2007 I have data in a table that has values of M and S and I need to change them in a report to show as a Checkmark. Any Ideas?
  7. pattyjean

    Access Reports and Macros or Filters

    I have developed 5 separate reports from 5 different queries and I made 1 macro to output the reports into pdf format on my local drive. I was going to add prompts to the queries to let others pull the years they need but then they would have to run the macro and enter the Year into the prompt...
  8. pattyjean

    Insert Graphic or data table into a Memo Field

    I am trying to figure out if I can insert a graphic or a data table into a text/memo field in an access database form. I didn't create this so I can not do any back end programming. Any ideas?
  9. pattyjean

    Access Report Print to PDF opening SAS

    I have a database in Access 2007 and everytime that I try to print a report to PDF it triggers SAS to run. Any idea of how to fix this?
  10. pattyjean

    Word to PDF with hyperlinks on a CD

    I have a word document WITH hyperlinks pointing at a folder with lots of pdf files. I can convert the word to pdf and keep the hyperlinks but on some machines it doesn't work but some machines it does work. Can anyone tell me if I can set up the links to point to any drive on a cd when I burn it?
  11. pattyjean

    Macro Output to Pdf to Folder

    I have a few reports in access that I created a macro to run the reports and save them to a folder on my computer. The problem is that I am now going to share the output macro with others that might have a different directory then me but access to the same folder. Example MY DIRECTORY...
  12. pattyjean

    UNION query truncating MEMO field

    I am trying to produce a report based on 3 queries and combined into one Union query for the report but my text cuts off at 255 after I add the second query. Here is the SQL statement - any ideas? SELECT comment1, sortmemo, selection, QNAME,Emplid,GROUP FROM [qryBest-COMMENTS] UNION ALL...
  13. pattyjean

    Lookup Table into Report

    I have 150 fields on a table organized by Course. Section. ICS. 1.1.a ,1.1.b., 1.1.c, 1.1.d, 2.1.a ,2.1.b etc. I need to label each of the 1.1.a with text example: 1.1.a. Are you teaching math 1.1.b. Are you learning math 1.1.c. Are you enrolled in this course In the fields it would by Y/N...
  14. pattyjean

    Macro to copy New Data into cell Excel

    I have a spreadsheet that needs to get updated daily. I enter the new data into a row and then copy and paste the same data into the top of the sheet so we can look at it at a glance and the details under it. The data is organized like this Day - HeadcountTtl - HeadcountCampus1-HeadcountCampus2...
  15. pattyjean

    Duplicate Values Comparison table / report

    I have built multiple queries and crosstabs and then merged them back into a make table query The data looks like this: Learning courses......................Equilvant course Make Table Course Section Location Ttl Pass Fail Course ttl PASS FAIL ABC123 1234 Campus1 100 80 20 ABC123...
  16. pattyjean

    Access Report Extra Page or Blank Page

    Should be a simple fix but my 1st GroupHeader is showing with a blank page except for the Header at the beginning of the report. I tried changing the properties force new page before, after,or before and after and it stills shows up. There are no blanks rows to make it show an extra page.
  17. pattyjean

    Access and Groupwise Create E-mail form

    I would like to collect data to several different employees and I noticed in access 2007 external data there is now a tab to collect data but when i click on create e-mail it only wants to use Outlook for this function. We currently use Groupwise. Is there a way to use groupwise and bypass...
  18. pattyjean

    Adobe 8.0 pdf adding Tab dividers on right side

    Someone told me that I can produce a pdf file with tab dividers off to the right side of the document. I am thinking they meant the visual tabs like the one on the left (pages,bookmarks,etc.) Does anyone know how or if this exists? Thank you in advance.
  19. pattyjean

    Excel 2007 ALT Enter Special Character

    Sample Cell data ALL IN ONE CELL WITH Word wrap: SUE THOMAS 234 EXCEL ST WINTER SPRINGS, FL 32789 I need to separate it into Name(Column) Street(Column) City (Column) STATE AND ZIP any ideas - i can't find the symbol for alt enter to do a delimited file
  20. pattyjean

    Difference Value Fields in a Query

    I have a query that has a preferred email address field and a Home email address field. I want to query and find only those that have different values in both fields. Hope this makes sense.

Part and Inventory Search

Back
Top