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 Mike Lewis 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. hdat44

    Print multiple excel worksheets on one page

    Hi, i have found a solution, i just pasted easch page into one using past as a picture, fit to one page and perfect... thanks for all who helped
  2. hdat44

    Print multiple excel worksheets on one page

    So i guess you mean the cells need to be the same size etc, a lot of the pages are different charts / graphs etc... does this mean that its not going to work??
  3. hdat44

    Print multiple excel worksheets on one page

    hi, i have tried this and they all print out on seperate pages for example i have 11 worksheets, so under layout i selected the option for 16 pages per sheet, and it printed the 11 pages out seperatly
  4. hdat44

    Print multiple excel worksheets on one page

    Hi, is it possible to print multiple worksheets on one page?? i've tried printing entire workbook and then selecting multiple pages in the layout tab but they still print out on seperate pages?? is this doable??
  5. hdat44

    Automated Conference Calls

    Hi, is there anyway that i can set up a call so that when the handset is lifted three numbers are automatically dialled??
  6. hdat44

    IVR Disconnection signal

    I have set the CLS to LDTA but now the IVR doesnt release the call at all, It's no longer in lockout just constantly busy until i short the cable??
  7. hdat44

    IVR Disconnection signal

    Many thanks for this, i have changed the CLS to LDTA and the line doesnt go into lockout but it still keeps the line busy until all of the message has beem played, is there any way that the call can be released as soon as the line is disconnected??
  8. hdat44

    IVR Disconnection signal

    Hi i have two analogue extensions that go to an IVR message, if you listen to the whole message to the end the extension clears Ok but if you hang up mid call the extension will go into lockout, you can clear this by either taking the wiring off the frame or by doing LD 20 Chg, can anyone advise...
  9. hdat44

    Set date to false after 3 months

    Yes, Brilliant it worked thank you very much for your help!!
  10. hdat44

    Set date to false after 3 months

    Hi i have a date field in my form and i want the date to be false after a 3 month period has expired i have tried the code below but the incorrect date just populates the field If Date ,DateAdd("m",-3,Now()) Then Date.Value=False End If Any help please??
  11. hdat44

    Date Expired cancel check box??

    How can i get a date field if it is older that 12 months to have the corresponding check box value change to unchecked?? i have tried the following code to no avail, any help welcome please Private Sub Form_Current() If Date1 Is LessThan.DateAdd("m", 12, Now()) Then ChkBox1.Value = False End If...
  12. hdat44

    Check Box Total

    Hi This has worked but the totals do not transfer back to the totals field in the table. aslo could i put a message box on this when the total has reached 12??
  13. hdat44

    Conditional Format

    That worked!!! many thanks
  14. hdat44

    Conditional Format

    Field Value is less than Now ()+91 days
  15. hdat44

    Check Box Total

    where would i put that code??
  16. hdat44

    Conditional Format

    How do i set a conditional format to show dates that are due to expire within the next 3 months. i can set it for 91 days but not sure how to do 3 months??
  17. hdat44

    Check Box Total

    Hi, i would like to have four check boxes on a form and a total box at the end so that as each box was ticked the total box would advance in increments of 3. can this be done??
  18. hdat44

    Calling Line ID on analogue phones

    Hi, i hvae a meridian option 11 switch and would like to have caller line id on analogue phones that have displays, does anyone know if this is possible please?
  19. hdat44

    Speed Dial

    *56 (is the divert) 2512 (the ext number to be diverted) 2512 (the password - SCPW)9 (access code) following digits are the number for calls to be diverted to # (ends)

Part and Inventory Search

Back
Top