Recent content by Raffles666

This one has me stumped. I have an Access database that contains a table (so far, so good). I want to copy that table to a second table - but only the structure. Is there a way using NOTHING but VB6 code to do this? Connection methods are not a problem - as this is a fresh 'program'. Thanks...

Exactly :). I corrected all my statements to use either CBool(0) or CBool(1) [Jet versions!] in the SQL statement itself - and not rely on VB - now all works fine. Thanks again Oh, and yes - I have all the SP's installed (up to SP6). Old school Alchemy engineer - trying to keep up with the...

But if the person is on the phone - then surely just pressing the DSS key (without pressing # first) would give you their voicemail? I've not tried it yet - so I'm guessing. Old school Alchemy engineer - trying to keep up with the times [hourglass] www.DataVox.co.uk "What do you mean - it...

Thanks for that - but it now works (cheers SBerthold) as it should. Old school Alchemy engineer - trying to keep up with the times [hourglass] www.DataVox.co.uk "What do you mean - it wasn't broke until I fixed it?

Ignore that - it works :D. Maybe I should try things properly next time. Old school Alchemy engineer - trying to keep up with the times [hourglass] www.DataVox.co.uk "What do you mean - it wasn't broke until I fixed it?

Oops - I can't use CBool within the SQL. It turns out as "...WHERE [Section] = CBool(0);" Back to my draeing board :(. Thanks anyway. Old school Alchemy engineer - trying to keep up with the times [hourglass] www.DataVox.co.uk "What do you mean - it wasn't broke until I fixed it?

Sorry - I meant -1 = True. I'll try using CBool within the string (good idea - thanks). Old school Alchemy engineer - trying to keep up with the times [hourglass] www.DataVox.co.uk "What do you mean - it wasn't broke until I fixed it?

Now I'm confused. I tried using the 'vbChecked/vbUnchecked' value - but that returned either a 1 or a 0. The mdb kicked that out as it demanded True or False (yes - I know they equate to the same - but Access is stubborn). This was the reason I used CBool (which converts 1 or 0 to True or...

[Section] is a database field with type set to Yes/No (Access' version of True/False). So, it's either True or False. Old school Alchemy engineer - trying to keep up with the times [hourglass] www.DataVox.co.uk "What do you mean - it wasn't broke until I fixed it?

Errr - I'm not. I am using "tmpVariable = CBool(chkButton.Value)" to make tmpVariable either True or False. The problem is when I convert tmpVariable to a string eg. tmpSQL = "SELECT * FROM tmpTable WHERE [Section] = " & tmpVariable & ";" This gives 'SELECT * FROM tmpTable WHERE [Section] =...

I have a cunning little problem with my SQL string. There are a couple of people using my program in Germany - with the German language etc set on their PC's (as you'd expect). Trouble is - when they run my program they encounter a little error that took me a while to find. If I run the exact...

To answer your 'DTE' question - try it!I have upgraded an old 2.1 unused unit to 3.2 by the back door (AT-X it, and let manager upload the 3.2 binary). Not such a good idea on a working site - but if you can't be bothered with all the in-between bits. Of course, it would need a reprogram (just...

Call pickup is also 'coming' in v3.? Old school Alchemy engineer - trying to keep up with the times [hourglass]

Just to 'expand' that a little... #XXX will work for any 3 digit extensions. #XXXX for 4 digit etc. S/C : #XXX F/T : Voicemail Collect T/N : . Old school Alchemy engineer - trying to keep up with the times [hourglass]

To get from Quick Edition phones to 406/412/SOE phones - it's just a case of loading the firmware like you would if you just bought the IP phones for the IP Office. You can not reverse the process once it's done as Avaya have blocked you from doing this, due to the IP Office versions being...