Search results for query: *

I have encountered the problem as well a couple of times since the original posts. I have also put together a solution that definitely cleans it up so the Excel process does not hang around. You can use this to kill off any process or VB-initiated VBA/OLE app - just pass the procedure the hWnd...

You use "32770" for the classname parameter. I am doing a lot with this currently - for example, I have a program, commanding a IE session that downloads files. It looks for the Download popup, fills in the filename to save field on the popup, then clicks the save button, and waits for the...

in your app, do you issue a .Quit call to the Excel OLE object? and then set the OLE object to Nothing? if you don't set it to nothing, it will not go away.

if you use File->Get External Data->Link Tables, after you identify the DSN/ODBC data source, when it provides the popup with the list of tables you can choose from, on the lower right of the popup, there is a checkbox for Save Password. after linking the table, if you run the mouse over the...

I see now. Are you able to link one table from the target database in your Access DB/App? Access gives you an option with linked tables to store the UID/PWD with it. I am certain you could then read the properties off the linked table at run time and use that connection string directly or...

Having re-read the other thread a little, I guess I didn't catch that you wanted to read the UID and PWD from a DSN and then send it to another Access front end. Let me ask - why would you want to read the UID and PWD out of the DSN and not just use the DSN itself in the Access front end? You...

one simple way I can think of is to set environment variables for what you want to send in to the Access app. set up environment variables for the UID/PWD, then when Access starts up, let your code read the environment variables. this is what a web server (like Apache) does on Windows when you...

Instead of relying on the correct keyboard/mapping, how about creating hotkeys or buttons on the form, where if the user wants one of your special characters, he hits the button or hotkey, your VB form then adds the desired character at the current location.

you also might want to look into using SHFileOperation API function as it provides a parameter/option for displaying a progress bar.

yes, you can. that being said, I think that you (or your users) are blowing the "privacy" issue out of proportion with regard to a webserver. additionally, to the other suggestions, if there is a privacy issue, then how is email going to reduce it any? are you going to build encryption into...

you have privacy concerns about running a web server, but not about giving out your IP addresses? sure you can do it - but how are you then going to prevent anyone in the world from printing to your printer?

I don't have my classic Network Programming book handy, but I'm sure you can use the sockets API to do it. If you do a ping with the external host name, does it return the IP address you are looking for? If it does, then surely you can program it.

who's/what grid control are you using - MSFlexGrid? Two options: 1. grdResults.Clear - will just blank out all the rows 2. this will actually delete the rows from the grid (better if you want to use AddItem to repopulate). Dim l As Long For l = grdResults.Rows - 1 To 1 Step -1...

Also, how to close the application at the end of the sub?" The VB sub? You mean like "End"?

check if setting objExcelApp.DisplayAlerts = False prevents the error from popping up.

you mean remove leading zeros or zeros in the least significant digits after the decimal in a string format? or just test for zero and change it to a blank? for your simplistic case, the simplest thing is: TextBox = iif(TestVar = 0, "", TestVar) you can get more elaborate using iif()...

have you tried turning statistics and trace on both machines and see how they compare when running the sp? I agree that the problem is probably with the sql server/machine, but, you might not find where the holdup is until you see where the time is being monopolized on your test box when the sp...

if you want multi-selection then you have no choice, you either use the listbox(combobox will not work), or come up with a different paradigm for making the selection - for instance, maybe, like other programs, you display all the images as thumbnails, put a checkbox under each called "select"...

you can use DoCmd.OutputTo but not with an ADO recordset. create a generic QueryDef (if your query isn't fixed), in your code, you can change the SQL tied to the QueryDef (if you need dynamic SQL), and then use DoCmd.OutputTo on the QueryDef.

when you say "I find that some queries/stored procs appear to hang(more than 20min)" are you saying it completes after 20 minutes, or you give up waiting after 20 minutes and restart the server? are the resources available to the sql server the same on both machines? are you giving the sql...