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

    Excel: display a symbol based on formula result

    Thanks, I didn't think to check the special font, it is Wingdings2!
  2. klmack

    Excel: display a symbol based on formula result

    Hi, there's a Logo Mascot quiz making the email rounds that was slickly designed in Excel, and our boss challeged us to figure out how the author did it. The spreadsheet matches a typed entry to 5 columns of answers (five to cover all the possible spelling variations), if it is right it puts a...
  3. klmack

    Open report from ListBox on form

    Hi, Looked at the doCmd.OpenReport in the one database, but up front they called a control for lstReport (the report box) and named a string CONACTION. I tried editing my button with the doCmd.Open Report arguments and it didn't recognize the keywords. I think I am missing a control on the...
  4. klmack

    Open report from ListBox on form

    Hi, this is a real beginner question...I know some SQL but not Visual Basic. Have a form frmReport with listbox lstReport, tried adding command button with wizard to open report, how do I tell the command button to "open report selected in lstReport"? The other databases I'm trying to learn...
  5. klmack

    2 easy beginner questions - reports

    Hi, I tried searching for answers and these questions are probably way too basic: 1) Does it matter where on a report you put summary calculations, can the summary math be in the report header, or does it have to run "chronologically" after the data? 2) I have to edit someone else's...
  6. klmack

    Simple Calc in Report produces wrong decimal places

    Thanks Remou! you were right, the ones that were off were 3 decimal places in the original data and got rounded up by the time they made it to the report calc..such a basic thing to overlook (too many trees blocking my view of the forest!!). Kerry
  7. klmack

    Simple Calc in Report produces wrong decimal places

    Hi, I inherited some customized access reports and one of the sub-sub reports is not doing the math right, I am stumped. The calculation is =[QuantityActual]*[Cost] and the formats for all 3 fields is Fixed, 2 decimal places. It came up with the following: qty cost Calculation .13...
  8. klmack

    Limiting Find Unmatched to Same Record in 2 Tables

    Thanks PHV it worked perfectly! Much better than the "Is Null" thing...Now I can stop banging my head against the wall and see some results! Kerry
  9. klmack

    Limiting Find Unmatched to Same Record in 2 Tables

    Hi, very new at trying to use Access SQL, need to compare 2 tables of employees, say "Fac" and "Hr", where the Badge Number is the primary key, and look for mismatched pay rates, but only for the same 2 rows/records that are linked by key. This query showed the two tables linked at Badge Number...
  10. klmack

    Printout of all installed programs?

    Is there a way to print the list of installed programs you get from Add/Remove Programs (besides screen print to Paint), maybe get the same list via the Command Prompt? We're trying to do an inventory of what's on our 150 computers...Thanks!
  11. klmack

    Windows Server 2003 Screensaver

    Hi, hope I understand your question correctly, if UserA remote desktops into a win2003 server, they can use Start Menu-Control Panel-Mouse-Pointer and pull down the themes to find an extra large etc. cursor. Change screensaver timeout by Control Panel-Display-Screen Saver. I tried this on my...
  12. klmack

    How many roles can go on a single server?

    Hi, I'm setting up a home network for training, installed one single server (80 GB HD 3 GB processor 512 MB RAM) and put win2003 standard edition on it. Right now it's networked with 4 computers together with a router to a broadband connection, with IP addresses assigned automatically. So far...
  13. klmack

    Switching Primary Operators on Consoles

    Hi, We were thinking of adding another 4412LD+ console upstairs (at x130) then switching the Operator position between x100 and x130, depending on where I was working each day. Saw that the "CAS" operator is factory set to 768. How do I get in and change the "Dial 0...
  14. klmack

    Recording Greeting through Phone

    Hi, I've been recording our greetings for the Auto Attendant through a computer microphone as a wave file then uploading them in Messenging. The audio sounds good thru the computer speakers but when it is played thru the Merlin there's noise and distortion. The factory recorded Merlin...
  15. klmack

    Immediate Call Handling - Lines Not In Calling Group

    Thanks all, I followed Franke's detailed instructions and it works like a champ now, for both the day and night services. I'm almost looking forward to Monday now - we'll see how many customers have the patience to use the directory and transfer to extensions, and how many will just punch 0 for...
  16. klmack

    Immediate Call Handling - Lines Not In Calling Group

    It's set up hybrid/PBX. Calling Groups from Print: 770 Queue Type: Integrated VMI Hunt Type: Circular First-Second-Third Alarm Thresholds: 1 External Alert: 0 Msg Waiting Receiver: 0 Queue Priority: 16 Queue Control: 99 Queue Support: 0 Overflow Coverage Call Group: 0 Overflow Threshold: 1...
  17. klmack

    Immediate Call Handling - Lines Not In Calling Group

    Hi, we've got release 2.5 of the Merlin Messenging system. There are calling groups 770 and 771 (Night) set up already and an Attendant 1 (day and night). The phone rings 6-7 times before the Attendant picks up. The procedure says in order to change to Immediate Call Handling - assign the...

Part and Inventory Search

Back
Top