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!

Register Log in
  • Congratulations Chriss Miller 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. TheFitz

    Can't Create Trigger using values from other tables

    ...profile record so I believe I understand the insert process correctly. I think my issue is return data into the MYNAME variable? but I could be wrong. . . Thanks for your help, Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who...
  2. TheFitz

    Can't Create Trigger using values from other tables

    OK, will do. Thanks Vacunita Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!
  3. TheFitz

    Can't Create Trigger using values from other tables

    ...MYNAME, '2017-01-01', NOW(), 1); END I'm sure this will be easily fixed, but Google doesn't seem to be my friend today. Thanks for any help you can give Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!
  4. TheFitz

    Can't Create Trigger using values from other tables

    ...MYNAME, '2017-01-01', NOW(), 1); END I'm sure this will be easily fixed, but Google doesn't seem to be my friend today. Thanks for any help you can give TheFitz Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who...
    • TheFitz
    • Thread
    • Replies: 2
    • Forum: PHP
  5. TheFitz

    Using iif for nulls is not working

    How sure are you that it's returning NULL values and not empty strings? Try: a) IIf(Len([workrvu])<0,0,([workrvu])) - or - b) IIf([workrvu]="",0,([workrvu])) F. Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!
  6. TheFitz

    Using iif for nulls is not working

    ...check the value. I think a) wil work as I'm sure I've come across something very similar, yet I can't remember over what. Give it a try and let me know if it works, Thanks F. Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who...
  7. TheFitz

    Excel VBA - Value from closed workbook - Error 2015

    ...of all. It's definately due to the merged cell. I don't have the ability to change it from a merged cell but that's what's causing the issuue. Thanks for your thoughts tho. F. Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who...
  8. TheFitz

    Excel VBA - Value from closed workbook - Error 2015

    ...1, xlA1) ' Execute an XLM macro GetValue = ExecuteExcel4Macro(arg) End Function Any ideas would be apprecaited. Thanks Fitz Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!
  9. TheFitz

    Runtime Error 438 - Works on one form and not another

    ...this solution in as the final fix, however, it's not a case of trying to work out exactly WHY it's not working. . . . . hmmmmmm . . . . Thanks for your efforts thus far, F. Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!
  10. TheFitz

    Runtime Error 438 - Works on one form and not another

    ...the frmBookInOut, so the more I look at it, the more it suggests a problem with frmMainMenu (the calling form). Hair-loss is increasing!!! :-S Thanks for the suggestions, F. Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!
  11. TheFitz

    Runtime Error 438 - Works on one form and not another

    ...on this button???? Very confused!!! :-S Thanks for the suggestions, keep them coming . . . . Thanks F. (PS- I'll post here if I work it out, even if it's my own stupidity!!!) Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who...
  12. TheFitz

    Runtime Error 438 - Works on one form and not another

    Hi Andy, Good call, however, it's not that. I've checked another copy of the same system and it's working fine. . . . . References are exactly the same. F. Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!
  13. TheFitz

    Runtime Error 438 - Works on one form and not another

    ...the Error 438 - Obj Not Supported error whereas from the date selectio it works happily. Anyone got any ideas and I am COMPLETELY lost. . . . . thanks for any pointers, Fitz Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!
  14. TheFitz

    VBA query SQL Server FILEPROPERTY Not Returning

    ...NULL for any Database that is isn't connected to. ie I needed to specify the connection directly to that DB and then all works ok!!! Thanks for your help skip, Regards, Fitz Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!
  15. TheFitz

    VBA query SQL Server FILEPROPERTY Not Returning

    Hi Skip, I'll give it a shot, but the problem isn't with the name or filename fields, it's with the "FILEPROPERTY" part. :-S [bigears] Fitz Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!
  16. TheFitz

    VBA query SQL Server FILEPROPERTY Not Returning

    ...fileproperty(a.name,''SpaceUsed'') as SpaceUsedMB from myDB.dbo.sysfiles a Anyone got any ideas why this would be the case and how I can get it to work?? Thanks all Fitz Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!
  17. TheFitz

    Try to add colunm of data type Yes/NO

    ...do you know your value is null? I've just tried it and the default value is set to 0, which is correct I believe? Let me knwo and I'll try and help . . . . Regards, TheFitz Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!
  18. TheFitz

    Formatting Controls on Continious Form

    ...Where they should be: record 1, text 1 = Red record 2, text 1 = Yellow. Can anyone help me - It's driving me bonkers!!!!! Thanks for any help you can give, Regards, TheFitz Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who...
  19. TheFitz

    Passing a SQL String from Access to MySQL and Returning a Recordset

    ...As String) As ADODB.Recordset Const DB_CONNECT As String = "Driver={MySQL ODBC 5.1 Driver};Server=127.0.0.1;Port=3306;Database=EBGSDT;User=****; Password=****;Option=3;" Dim cn As ADODB.Connection Dim cmd As ADODB.Command Dim rst As ADODB.Recordset Dim starttime As Date Dim endtime As Date...
  20. TheFitz

    macro to get name and address from word document and paste to excel

    ...and address or is it just free text. If it's just free text, you have no way of defining the actual name or address length. Can you expand what you need a little pls. Thanks Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!

Part and Inventory Search

Back
Top