Search results for query: *

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

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

I'm a VB programmer trying to help a friend's db. I have written a routine to copy the results of a subform to a textbox on another form. The error says "must have focus" Access help says: "To run the GoToControl action in Visual Basic, use the GoToControl method of the DoCmd object. You can...

I'm writing a project that moves column data for an account to a dedicated sheet. If the account is new, I create a sheet. How do I scan for the next new sheet. NewSheet=sheets.add doesn't work. (Error 438.) Thanks guys, Upside down in VBA help, and I'm sooooo embarrassed! :-) John

I need this for a class project... not for grade, I'm 52 y.o. and a pro vb6 programmer. I'm rewriting the old startrek game, with the 10,10 grid screen, and you have the enterprise and you have to visit x amount of quadrants and sectors in x amount of time to kill all the klingons... (you must...

Sorry I couldn't read through the whole 115 responses... This one is pretty good.. Hold the ctrl key and click on any control, keep drawing them till you're done... esc breaks the sticky... hehe I like it!!! John

Does anyone tell me the max length of a sql statement in MS-SQL? Is Access the same? Thanx in advance! John

I used to have some code that would save a sheet without the user box. I can't find it anymore. Didn't ask (SAVE Yes). Can anybody clip that to me? A star for the winner... all the winners...!

I have a network of machines, that randomly drop the internet connection, internal servers still answer up. The connection comes through a cable modem, to a Cisco 2600 router, then to an NT server, running DHCP,cisco 400 switches to the internal network. Five of the machines, are 2-98's...

I have a probably basic system meridian, with about 20 stations, and a single t-1 The "applications module" looks like a pc. it has a mouse and keyboard port, marked with icons, and a printer port and two serial ports. Additonally there is a standard nic card, and a plain jane...

Anybody got a small one? TIA John

instead of that standard nasty blue "e"? Anybody know? Thanks John

This is just a curiosity now in that I built a workaround... Windows NT 4.0 sp 6 VB 6, sp 4 I built a automated dialer using a dialogic T-1 card 24 lines due to the nature of the third party control I am using (visual voice) each tel line needs it's own seperate program running. It won't...