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 bkrike 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. Ptrif

    Text and number fields

    I have created a form that scores people on calls that they take. I have 9 fields that are scored 1,2,3 or N/A, and 2 of the fields are either Yes/No. Everything works fine if I have the fields in the table set to "Number", however I have to set them to text so that the simple script i wrote...
  11. Ptrif

    Sum in form

    I have a group of text boxes that you can choose either 1, 2, 3 or N/A. I would like to have a text box that would give the total average but not count any that have N/A chosen. Cant figure it out...any help is appreciated. Thanks Paul
  12. Ptrif

    Random Pick

    I was wondering if someone can tell me the possibility of this. I would like to create a form that would randomly pick a person from a table. So if i have a basic table with say 30 names in it, i want to be able to create a form where there is a field and a button, when the button is pressed i...
  13. Ptrif

    Printing only one page

    There is probably a very easy solution to this but i am just not able to find it. I have a basic report that prints out but about an 1/8th of the report prints out on page 2, is there a setting i can set so that it shrinks it or fits it all onto one page? Thanks for helping the blind Paul
  14. Ptrif

    Weighting values

    This is going to be a little difficult to explain but ill try my best. I have a database that I use to monitor phone agents on various things during one of their phone calls. There are 3 different groups on the form: Customer service, accuracy and Documentation(with many drill downs in each...
  15. Ptrif

    rtf files

    I am trying to import files from another database into access, however the other program only creates .rtf files. Is there anyway to import these directly into access without having to manually manipulate the .rtf file? any help is appreciated. Paul
  16. Ptrif

    Email Files

    I need to know in outlook where the email is actually located. Is there just one file that holds all the email data? Or is there a folder that it is all stored in. Please help if you can. Thanks Paul
  17. Ptrif

    Address question

    I'm not sure how stupid of a question this is but here goes....I'm new to html and have created a site, anytime someone hits my url the address in the browser always stays at the main URL, ex. www.mydomain.com, even if they click on a link and go to another page on my site it still shows...
  18. Ptrif

    Auto population

    I have a simple form that has a combo box and a text box, the combo box shows a list of products, when a product is selected i would like to have the text box automatically populate with the associated price. How can i accomplish this? any help is apprciated. Thanks Paul
  19. Ptrif

    Cannot Recieve mail from outside the network

    I am running Excange server 2000 sp3 on a windows 200 server system. The server is the only computer on the network. Nothing is being blocked by my ISP but i cannot figure out why i cannot recieve mail. I can send and recieve within the network and i can send email over the internet, just...
  20. Ptrif

    Time to number

    Is it possible to convert an entered time such as 10:30 <--that time meaning 10 hours and 30 mintutes, to 10.5?? any help is apprciated.

Part and Inventory Search

Back
Top