Search results for query: *

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

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!!

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

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

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!!

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

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

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

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

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

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

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!!

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

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

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!!

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

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

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

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

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