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

  1. toolman2

    Print document from access with file name same as value in field

    Thanks Spiralmind for your reply. I'll play around with it and see if I can get something to happen. Another question.....If I have in a field, a link to the file I want to output, how could I make that happen when I'm printing out my report? Thanks
  2. toolman2

    Print document from access with file name same as value in field

    Hi all, Ok....I've looked through all the postings til blue in the face and cannot figure out how to do what I want to do. I have a form to which I want to add a command button that will prompt the user for two dialog boxes asking for input that will result in: a) printing a (not necessarily...
  3. toolman2

    Picture in my report

    Bob, This is the thread I've been looking for, however, what should be the data type for field in the table that will contain the imagepath info? Mine is set to "OLE Object". Should it be set to "text"? Also, why does the code in the event procedure for a report need to be a...
  4. toolman2

    If Statement in Report Field

    Robert, I know this is old, but it helped me out tremendously. Been looking for such a solution and found it here. Thanks again Kevin
  5. toolman2

    Sort problem in report

    Randy, Thanks for your timely reply. Seems like the actual info in a reply from someone sometimes doesn't help, but it stirs up other ideas that do. That happened in this case. After further study, I realized that my sorting is working correctly after all. The value in the field can be 1 or 2...
  6. toolman2

    Sort problem in report

    I have created a report that has field ("pocket") by which the rows in the detail section are sorted. Based on the value in "Mach", "pocket" gets its value from one of two other fields. Here is the IIf statement. =IIf([Mach]="6480" Or...
  7. toolman2

    Prompt user for File name when creating a new Word Doc

    I know this is an old thread, but I'm trying to apply the same code to an Excel (Save) macro and not having any luck. What am I doing wrong?
  8. toolman2

    Don't want to display records basd on a value in another field.

    Thanks all for your help. I have been able to achieve what I wanted. Basically I created IF statements in each field to create blank text boxes when the statement was true, then selected the Can Grow feature to be yes for each text box. I then reduced each text box to a line. When the condition...
  9. toolman2

    Don't want to display records basd on a value in another field.

    Thanks for your reply pdldavis. I can get the field that carries the "TP" info to display a blank field when that criteria is satisfied however, what I would really like to do is basically not display that whole row or record on my report. The info that "TP" is linked to is...
  10. toolman2

    Don't want to display records basd on a value in another field.

    Thanks for your reply pdldavis. I can get the field that carries the "TP" info to display a blank field when that criteria is satisfied however, what I would really like to do is basically not display that whole row or record on my report. I guess I am willing to try code, but I'll...
  11. toolman2

    Don't want to display records basd on a value in another field.

    I'm struggling with this for some reason. I've looked for a similar problem but no luck. I want to NOT display a record in the detail section of my report when the value of a certain field is "TP". I've tried the IIF statement for individual fields but I want the whole row to not...
  12. toolman2

    Appending Text to a Memo Field

    I'm doing the same thing that Magnusfox is doing except I'm prompting for a number whose data will be appended to a field that may or may not have data already in it. How do I get it to add to the existing data based on what's returned from the prompt? Thanks ahead of time for your help.

Part and Inventory Search

Back
Top