Search results for query: *

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?

...= 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] = True;" in English (which works fine)...

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

make sure the lan card in the vm server doesn't have power-save enabled as well (the cause of many a vm problem!) Old school Alchemy engineer - trying to keep up with the times [hourglass]

You missed: Set ParmQD = Nothing Set ParmRS = Nothing DB.Close Set DB = Nothing Old school Alchemy engineer - trying to keep up with the times [hourglass]

I did - but thanks a lot for your input. It would have proved very useful had I not found it in time. In fact - your line is better than mine - so I'm still going to pinch (err - use) it ;). Thanks again Old school Alchemy engineer - trying to keep up with the times [hourglass]

Sorted this now guys (after much fiddling). I just needed a dsrData.tblGBA command. That refreshed the links and all is fine. Thanks anyway. Old school Alchemy engineer - trying to keep up with the times [hourglass]

I've seen this happen when a customer plugged a computer in to them. I've also had a customer blow up a DS unit the same way. Has someone been 'playing' with the patch leads? Have you earthed the unit? Can you get 'blow' on the ports? Either way - it's probably time for a new box. Old...