Search results for query: *

By the way, I did try using double quotes "" and also tried substituting parenthesis () and brackets [] in place of the ones around the text, but neither one worked. I even tried putting an ampersand & in front of the middle quotes, but that didn't work either. There's got to be a little VBA...

I seem to have stumbled upon a problem creating an html file programatically with Excel VBA. I'm taking information filled out in Excel sheets and using it to create an html text file, mainly using WRITE and WRITELINE. Unfortunately the context requires using quotes around the text being...

Thank You! Thank You! Thank You! Much obliged. All's well that Ends!

This script runs OnChange, so that as the user types, the filter is run - saving them from hitting "Enter". To do this I need to get back into the field and place the cursor at the end so they can keep typing. I tried ESC, Right Arrow, everything I could think of, then happened upon F2. Works...

I have a series of search fields across the top of a form, with detail rows below them - allowing the user to search a large database by several fields at once. Unfortunately when they type * for a wildcard, the sendkeys F2 (escape) is read as a SHIFT +F2 which brings up the zoom window. Does...

If they get it solved, please post it here. I need to do something along the same lines.

I have the opposite problem - I can't get my form to take focus over the other windows. I have tried: form.ZOrder 0 and form.SetFocus Both are supposed to work, but neither did. I think the other program that I'm dealing with might be taking over. If either of these commands are in your...

I'm back on this project, see what we can do today. Thanks for all the input. When an operator prints from their database, it creates a file, either in a manual or auto folder. My main program then opens it and sends it to this proprietary Linx 6800 printer. If they choose Manual, there is...

How do I stop my own executable? I have a small app running constantly - then when something happens, it opens another app using shell. I do something, then I need to close the second app. I have the Do Loop using a While x and y, so it exits the loop, but the app still runs. I've tried...

How do I stop my own executable? I have a small app running constantly - then when something happens, it opens another app using shell. I do something, then I need to close the app. I have the Do Loop using a While x and y, so it exits the loop, but the app is still running. I've tried...

Thanks, That does the trick!

I've researched the Date Convert function, so I know that the output that I need is 101 for "1/24/2004". But what do I use to pick an input in the form of "24-Jan-04"? This is SQL 7.0, so that may be the problem, but it seems like it should be possible. Here's what I found: Without With...

I was given a backup of a database - actually I was given the "data" folder - is that the same as a backup?. I need to know how to take that backup and load it up into SQL Server 7, so that I can write import code for this DB. I don't need the database for any other purpose than testing. I...

I was given a backup of a database - actually I was given the "data" folder - is that the same as a backup?. I need to know how to take that backup and load it up into SQL Server 7, so that I can write import code for this DB. I don't need the database for any other purpose than testing. I...