Search results for query: *

When I see this, it means I've got Access, and a table in design mode. Save the table layout and re-run... :-)

Switchrooms in the US, now use satellite GPS satellites for timing, and are synced to what is known as System Network Clock, or snyc, ("Snik"). T1's DS3's, OCC, Digital Switching networks, all running in sync. While it is true, there is a master / slave end for a T-1, there is no sending...

Depending on the equipment, it is possible to do a linear hunt to a second group, a rotary group will not. It is possible also to create a sub group, within a large group.

Create a table in Access for your hyperlinks. Use Dynamic SQL to query the database for the appropriate hyperlink.

The old VB6 used to support 'sendkeys' and apparently Excel 2007 still does... And according to MS "This function is used by the upgrade tools to emulate the Visual Basic 6.0 SendKeys method. In Visual Basic 2010, use the My.Computer.Keyboard.SendKeys method instead." You could do it... It...

I really miss control arrays...

Crystal Reports indeed shipped with the "Pro" versions of VB5. Just add a reference to it. It's not a component. I think it was available earlier. You need to look up the VB reference commands. It's not the full version, but it does most of what you need. Don't get too crazy with SQL. It's...

the Server is the machine with "listen" running. that's the only diff. Once you're connected, it makes no diff, who's who. I used it on a LAN, but built it with the same machine, and you had to compile and run the other, then connect with the IDE version of the other, on the same machine. when...

I used to do this, it required a handshake front end. I used to send an ack, and stuff... I remember "chunks" Lemme look into it... been a while, but once I have it one way, it worked both, you may want to make sure your firewall or port forwarding in the router isn't killing it. btw, you can...

You should hide it a little, I mean the load event is a little obvious, isn't it? Save it as a worksheet function or stick it in a module, and chain a couple of do-nothing calls to functions together, put a call to a gettime() function in the load event, then call something else in it... And...

grozer... Hi there from an ex-telephone grunt! (the CIRAS and CILLI codes gave it away.) :-) I did a pretty exhaustive search for you and it appears the only thing you can do is add a picture or icon to the button. "Face" won't do it, but I have learned alot about toolbar buttons, so thanks...

just for giggles try screen.mousepointer=0 jb

Below is a chunk of code, that was working fine until I added the "'Mid(a$, 91, 10)" line... The list control was listing over thirty smiths in the database. I add the line and run a test, and now the Query acts like 'Distinct'. It now only finds the first instance of smith and the k variable...

abby-normal, :-) I have went around and around getting the quotes right on SQL statements in VB. The following works for vb6 and probably for vba as well, and you will notice the single and double quotes surrounding text2.text. In this working instance, the clientID is defined as a long...

Found it, for all of you out there, Ck the FAQ's first! (And I even knew it!) Thanks John

Can't find it anymore, using 2000... TIA John

subject=Test&attachment=" & TempFilePath This looks like you're jamming everything into subject subject=Test, attachment=" & TempFilePath maybe semicolon? maybe just a space... John

'intRow = 44 this changes each loop - don't set it here intFirstRow =1 '? intLastRow=44 'these are all guesses intCol=1 '? For intRow = intLastRow To intFirstRow Step -1 intFound = Cells(intRow, intCol).Value 'now intFound will change each loop 'only fixed to here there are more...

ActiveSheet.PageSetup.PrintArea = "$a$1:$h$60" bResponse = Application.Dialogs(xlDialogPrinterSetup).Show If bResponse = "False" Then Exit Sub ActiveSheet.PrintOut Copies:=1, Collate:=True ActiveSheet.PageSetup.PrintArea = "$a$1:$AA$60" John

Anytime, But I really should look at code b4 I post! The two lines... ListBox1.ListIndex = -1 z = ListBox1.Text ...Aren't needed and are really refuse lines, left over while I was playing... John