Search results for query: *

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...

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

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...

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

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...

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...

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...

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...

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...

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...

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

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...

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

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

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

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...

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

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...

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...

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...