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!

Register Log in
  • Congratulations Chriss Miller 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: Ptrif
  • Order by date
  1. Ptrif

    Running Form in a window independent of Microsoft Access

    Was wondering if anyone was experiencing the problem I am having when using this code. If i go to preview a report I cannot print it, cannot right click and get the shortcut menus to come up from anywhere.....has anyone else had this problem....any suggestions on how to fix it? I tried creating...
  2. Ptrif

    No Print Button

    Thanks Zameer, I am using XP. How do you go about creating a shortcut menu for a report? Thanks again for your help! Paul
  3. Ptrif

    No Print Button

    I use the following code to hide the access window, however when running a report the report runs just fine but there is absolutely no way to print it....is there a way to add the print menu bar to the report? any help or suggestions welcome!! Thanks Paul Option Compare Database Private...
  4. Ptrif

    Saving Issue

    Is that all i put in the code is form.undo? I tried that and i still get the same result
  5. Ptrif

    Saving Issue

    I have a form that is used to monitor or grade employee customer service phone calls. The problem i am running into is when someone chooses say someones name on the form but then doesnt finish the form and closes it out it still writes the data to the table, is there anyway to avoid it from...
  6. Ptrif

    Help Modifying Code

    I have the following code on a form that i use to monitor and grade phone agents phone calls. The below code averages the scores and if there is a N/A it doesnt count that into the overall average, i need to add something to the code so that each one of the "categories" is a certain percentage...
  7. Ptrif

    Help with changing code

    I'm not sure if this is the right forum for this but here goes. I use an access database to grade phone reps taking phone calls. The below code averages the scores and if there is a N/A it doesnt count that into the overall average, i need to add something to the code so that each one of the...
  8. Ptrif

    Changing a phone number to a "Y"

    I have a report that shows a name and a phone number. What i need to know is if there is a phone number I would like it to display a "Y" and if the field is blank and there is no phone number i would like it to display a "N". How would i go about doing this? Any help is appreciated. Thanks...
  9. Ptrif

    IF statement

    Thanks Bluedragon that worked great. I would like to try doing something on the same lines but a little different. Lets say i had 2 colums one with a name and one with a phonenumber, is there a way that i could run a macro or something to change all of the cells with a phone number to a Yes...
  10. Ptrif

    IF statement

    I have a spreadsheet that contains phone numbers, but not every entry has a phone number, i would like to have a column to automatically put a Y next to the ones with phone numbers....I have played around with some IF formulas but cant seem to get it right.....any help is appreciated! Thanks...
  11. Ptrif

    Copy and Paste

    Thanks Skip, however I need to keep the formulas, the 2 spreadsheets are identical. I have found a work around by doing a find and replace and just replacing the name of the other spreadsheet to a blank.....was now just wondering if there is another way to do it. Thanks! Paul
  12. Ptrif

    Copy and Paste

    I have 2 identical spreadsheets, I would like to copy one of the sheets from one to the other but when I do that all of the formulas reference the spreadsheet that it was copied from....is there a way to copy a complete tab over to another spreadsheet without the formulas referencing the...
  13. Ptrif

    Averages

    Dhookom, THANKS!!! that worked great! I thank you both for your help! Paul
  14. Ptrif

    Averages

    Cosmo, i did use it in an unbound text box, I will review it once again and give it another try.
  15. Ptrif

    Averages

    I still recieve the same error message.....? Anything else i can try?
  16. Ptrif

    Averages

    I have a report that where i average a group of totals using something similiar to this Avg([CSTOTAL]). This normally work fine for my purposes, however, some of the fields may contain a "N/A" instead of a 1, 2 or 3 value and so when trying to run the report I get an error about the expression...
  17. Ptrif

    Printing from a form

    Thanks Hymn, I believe that is EXACTLY what i was looking for!!!! thank you!! Paul
  18. Ptrif

    Printing from a form

    Thanks you both for helping. pdldavis, that would work for me however the form is much to large to print the way it was created, the report i created is a shrunk down version of the form if you will. It would be too much work to try and change the form to be print friendly. Lets see if i...
  19. Ptrif

    Printing from a form

    Yes I could do that, however what im trying to do is have a print button on the form that the user fills out, and when they are done with the form i would like them to have the ability to print out that exact form they just filled out from a button on the form, I just dont know how to create it...
  20. Ptrif

    Printing from a form

    I have a form that lists a series of scores. I have a report that mimicks the forms so when i print a report it looks exactly as the form did when entering it....what i would like to know is how i would go about having a print button on the form that would automatically populate the query with...

Part and Inventory Search

Back
Top