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: *

  • Users: SamDemon
  • Order by date
  1. SamDemon

    Open Form Based On Combo Box (VBA)

    PHV - I have SORTED this now! But thank YOU for ALL your help #sarcasm It's just common sense, shame sense isn't common!
  2. SamDemon

    Open Form Based On Combo Box (VBA)

    Good afternoon, Does anyone know what the best way is to code a combo box (AfterUpdate) on a form to open a new form on a specific record. I have created a query with the following fields. tblBooking.BK_ID tblBookingPP.PP_ID tblBookingPP.PNR The form that I will be using is frmFindPNR and...
  3. SamDemon

    Current Year vs Pevious Year - Fixed months

    Should have been - Between DateSerial(IIf(Month(Date())>10,Year(Date()),Year(Date())-1),10,1) And DateSerial(IIf(Month(Date())>10,Year(Date())+1,Year(Date())),9,30) It's just common sense, shame sense isn't common!
  4. SamDemon

    Current Year vs Pevious Year - Fixed months

    Between DateSerial(IIf(Month(Date())>10, Year(Date()), Year(Date())-1), 9, 1) And DateSerial(IIf(Month(Date())>10, Year(Date())+1, Year(Date())), 9, 30) It's just common sense, shame sense isn't common!
  5. SamDemon

    Current Year vs Pevious Year - Fixed months

    I have created a company incident database which records staff holidays, sickness (against rolling 12 month Bradford score) and lateness. The problem I have is that I have been asked to display staff sickness based on our financial year of October to September. What is the best method in order...
  6. SamDemon

    Command to open a closed line through 5312 handset

    FOUND IT!!! ##5(Path number) to take ACD path out of DND **5(Path number) to place path back in DND It's just common sense, shame sense isn't common!
  7. SamDemon

    Command to open a closed line through 5312 handset

    Does anyone know the command ** to open an ACD path that is currenlty in Night RAD through a 5312 handset? I've done it before just cant remember how to do it. It's just common sense, shame sense isn't common!
  8. SamDemon

    Auto Archiving of Public Folders

    Has anyone got, used or tried an automated archiving program for Exchange 2003 public folders? I found a link with several different options, but thought I would throw the question out there for recommendations before purchasing anything. http://www.slipstick.com/exs/archive.asp Thanks Sam...
  9. SamDemon

    Adding Embedded Music to an ACD path before calling ACD skill group

    How would I go about having about adding an embedded media source to a RAD port? Where can you view RAD ports? It's just common sense, shame sense isn't common!
  10. SamDemon

    Adding Embedded Music to an ACD path before calling ACD skill group

    The embedded music file is a recorded message "thank you for calling... you will be connected to our next available operator", I need this to play first before the the ACD agent groups are called. Make more sense now? The file has been uploaded onto the switch already as embedded media source...
  11. SamDemon

    Adding Embedded Music to an ACD path before calling ACD skill group

    Can someone point me in the right direction of how to add an embedded music file (recorded message) to an an ACD path prior to the ACD agent skill group calling? We are running a Mitel 3300, 4.1 SP1. It's just common sense, shame sense isn't common!
  12. SamDemon

    Updating table from excel

    I have an excel spreadsheet with the following column headers: OperatorID, RegName, Australia, Canada, Caribbean, Central Africa, East Africa, Eastern Europe, Far East, Indian Ocean, Middle East, North Africa, South Africa, South America, South Asia, UK, US, West Africa and West Europe. Each...
  13. SamDemon

    Hidden Program wont Maximise on Screen

    Cleared out the XML files, and it worked straight away - no re-install needed. Thanks It's just common sense, shame sense isn't common!
  14. SamDemon

    Hidden Program wont Maximise on Screen

    Running a chat software program (in this case Sightmax 6.0) which launches as normal with a log-in screen, but then doesnt expand out on screen to use once the user has submitted passwords and clicked log-in. Icon in program tray shows (bottom right), and also across the taskbar at the bottom...
  15. SamDemon

    Public Folder Client Permission

    thanks Alfa, I did end up using the Alfa tool about 10 min after posting this... how daft is that you cant use the exchange consule to do it though? Isnt that a backward step by microsoft? It's just common sense, shame sense isn't common!
  16. SamDemon

    Public Folder Client Permission

    Does anyone know how to set client permissions on a folder other then running a script? Thanks Sam It's just common sense, shame sense isn't common!
  17. SamDemon

    Updating A Form Text Box

    I am trying to update a text box based on the value of combo box. I am trying to achieve the following:- What I am trying to achieve is the following:- If TradingStatus = A then ChargeID = 1 Else If TradingStatus = NA then ChargeID = 2 Now I have put the code on the ChargeID text box on the...
  18. SamDemon

    Hide several fields as a group within a report?

    How would you set up a report group. When I have tried to group fields with report I can not assign the group a name and therefore have been unable to call it in my code If you could let me know how you can create the groups it would be very much appreciated. Kind Regards Sam It's just...
  19. SamDemon

    Hide several fields as a group within a report?

    Is it possible to hide several report fields as a group depending on a status rather than doing it with each one indiviually. i.e. Private Sub Detail_Format (Cancel as Integer, FormatCount As Integer) If me.Status = "First Status" then me.infantno.visible = False me.infantname.visible = False...
  20. SamDemon

    Make a field visible depending on a status within the report

    Its always something simple... Cheers!! Remou It's just common sense, shame sense isn't common!

Part and Inventory Search

Back
Top