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

    DOOR INTERCOM ICM PLAYING MUSIC ON HOLD

    Hi Does anyone know how to disable the music on hold coming out of our door intercom icm unit ? thank you
  2. EmanuelSpence

    IP LDK-20 NETWORK ERROR

    Thank you we have done that still not showing though Do we need to reset the system afterwards ? do you know what system reset by software is on the same screen ? it's just that it is not showing up on our dhcp lists
  3. EmanuelSpence

    IP LDK-20 NETWORK ERROR

    When we connect our IP LDK-20 to the network to program it is not recognised and seems to upset the rest of the network when we look up in the dhcp list it is not present cables ok and blink when connected
  4. EmanuelSpence

    System Date and time missing from reports

    I have used the system Date and Time function in my reports and all seemed fine. Now when I run the report it comes up with a paramter box to enter the date and time. Does anyone know why the reports are no longer picking up the system date and time ?
  5. EmanuelSpence

    Can you suggest a VB script to run an access add-in accda file ?

    Does anyone know if it is possible to run an access add-in file like accda files from a command button within a form ? If so what code could i use I wish to disable access to all file menus etc when in mde mode Thank you
  6. EmanuelSpence

    VB script to run access accda file

    Can you suggest a VB script to run an access add-in accda file ?
  7. EmanuelSpence

    Command Button or Macro to launch Access Add-in

    Hello I have an Add-in i wish to run in Access, but in MDE mode the menu bar will not be available How could I run a macro or command button to launch the Add-in ?
  8. EmanuelSpence

    VBA Recordset update problem help required please

    Thank you for your help all sorted for us
  9. EmanuelSpence

    VBA Recordset update problem help required please

    I am in a current form The Table is called 'Short Time Working' The current record is 'ShortTimeID' and I want to update the value of field 'Week Number' to 67 when i press the command button What am i doing wrong ? Dim Tn As DAO.Recordset Set Tn = CurrentDb.OpenRecordset("SELECT *...
  10. EmanuelSpence

    Table record update from form text box problem

    I have a table called "Short Time Working"and the text box called "TaxNum" , how do I add the value of "TaxNum" to the table field "Week Number" in the table "Short Time Working" for the particular record ShortTimeID I am working on I wish it to update the "Week Number" record every time...
  11. EmanuelSpence

    How to convert this excel formula to vba ?

    Thank you skip that works fine now My next problem is that I have a table called "Short Time Working" and the text box called "TaxNum" , how do I add the value of "TaxNum" to the table field "Week Number" in the table "Short Time Working" for teh particular record ShortTimeID I am working on...
  12. EmanuelSpence

    How to convert this excel formula to vba ?

    Sorry Skipval your formula does not work In Excel the formula for 2/2/2011 returns 44 Your formula returns - 3296 ?
  13. EmanuelSpence

    How to convert this excel formula to vba ?

    Thank you - nearly there Can i put this in a text box expression so when a date is put in field (or box ) DayVal, the value of YourVal (set up as a text box ) returns the value of the expression ? Or in simple terms a person puts a date in box 1 and box 2 returns the number of the expression
  14. EmanuelSpence

    How to convert this excel formula to vba ?

    Hello I have a payroll week number formula =INT((A1-DATE(YEAR(A1)-(A1<DATE(YEAR(A1),4,6)),3,30))/7) Where A1 is the day you wish to find the week number for How do i convert this formula to Access vba ? Any help appreciated
  15. EmanuelSpence

    Conditional formatting based on another table value

    Hello Does anyone know the syntax for a conditional formatting expression such that the value changes if the value in another table is exceeded for example: in Table [Expiry Dates] and Field [Tax Expiry] How could I make another form Text Box change colour depending on the value in the...
  16. EmanuelSpence

    LG LDK20 LCR help for Premicell instalation

    Hello I am a newbie to LDK 20 programming and I found handset programming confusing and hard. Do a google search and obtain LDK PCADmin software and use either a serial rs232 to usb cable or fit a LANU port to your LDK system Then you can program everything on screen - really easy Then the...
  17. EmanuelSpence

    ICM Intercom on flex button ring tone

    Hello we have an ICM Door intercom on a dkt port and it works fine, assigned to a flex key However when someone presses the call button the flex key lights but does not ring How do we get the ICM to ring when the flex button lights ?
  18. EmanuelSpence

    LG NORTEL TCP INSTALL PROBLEMS

    1ST PARTY and demo licence is installed correctly and showing as 55 days left
  19. EmanuelSpence

    LG NORTEL TCP INSTALL PROBLEMS

    Good Morning We are using ipldk 20 and version 31En EnableLangDlg=Y AppName=LG-Nortel TSP ProductGUID=E1900F68-7532-46D1-B8C1-023F8E1D376C CompanyName=LG-Nortel Co. Ltd. ErrorReportURL=http://www.installshield.com/isetup/ProErrorCentral.asp?ErrorCode=%d : 0x%x&ErrorInfo=%s MediaFormat=0...
  20. EmanuelSpence

    LG NORTEL TCP INSTALL PROBLEMS

    Hello No the one for EZ Phone all the XP machines we have loaded it on have lost the internet connection sharing and work groups functionality and we get win sock errors John

Part and Inventory Search

Back
Top