Tiffany, did you ever get this to work properly? I am trying to do exactly the same thing with 50 xls files and would like to see your code if possible. THanks
Thank you all for your answers, I applied PVHs solution first and it did close Excel properly, so that is the one I'm going with.
Problem solved and I appreciate the help....
Hi all, this is driving me crazy. The following routine is called to open a workbook, find two sheets, import them into a table and close the workbook.
Here's the problem, everything works EXCEPT closing Excel. Checking the task manager after this routine exits there is an instance of Excel...
John, I have looked at the link you sent, it is not the same, the file I am looking to create will be a text file, the link you sent was for a code base.
Thanks anyway for the response.
Licensed SQL will not work as all the users are not local and support for a formal SQL db would not be...
Hi, I am developing a text document retrieval application which needs to search for and retrieve a specific document with sub-second response from a data file. A traditional SQL-type database is not acceptable due to licensing/support issues based on number of users this will roll out to. This...
Hi Mark, thanks for the suggestion, I have looked into the C:\windows\System32\spool\PRINTERS folder several times today and there are no files listed, however, based on previous experience, I am sure that the previously printed jobs will start again if I reboot the print server.
It is always...
THis is so strange. Each time we reboot our server, every document that was printed in the previous 24 hours for every printer gets re-added to each printers queues and starts to reprint.
I am at a loss to find any caching area where the print jobs are being saved after they print once.
Does...
Does anyone know how long it would take, ballpark, to migrate a 22gb SQL 7 db to a new server with SQL2005 running in SQL 2000 mode?
Are there any special considerations to be planned for? Thanks
Benlink, I am starting a new job in 2 weeks and they have Domino. I am thinking about implementing something similar in the new place. Can you share with me how you did this and maybe even your code for the application. I would appreciate it.
Regards
Rod
I have heard there is a setting in the administrator for R5.0.3 that stops mail at the server when it is not addressed to any internal user. I have been unable to find this setting. Does it really exist and does anyone know where it is? I can't find it in the help files. Thanks.
cascot, have you figured out a solution to the other half of your question, how to receive email into the app programmatically?
I would be interested in knowing what approach you used to accomplish this.
I can't answer for Hackster, but as far as i am concerned, HarleyQuinn gets as many stars as possible. His/her solution was EXACTLY what I was looking for, I have an app that uses multiple search terms to build a SQL string and return data to a richtextfield, and I have been trying to perfect...
Thanks, Andy, for the response. This issue happens whether there are images in the imagelist or not. I set up a test project and put a toolbar on a form in it and it worked perfectly there. That's what led me to believe it was somehow a programming issue. I have decided to replace the toolbar...
I added a toolbar to my app at the very end of development. Here's what happens: when the form is activated and while the form loads a listbox the toolbar and all buttons are visible, but as soon as the listbox is fully populated the buttons go invisible. I can click on where the buttons are on...
Ahhh, error resolved in part thanks to Sheco's tip. Viewing the source I noticed incorrect picture names, which led me to a logic problem in how the temp table was being built. Once the code was fixed the trouble went away and all is as it should be. Thanks for the answers guys.
Thanks for the replies. I will check out the 'view source' as Sheco suggests.
DNG, the counter forces a page break after 5 records so the output fits nicely on 1 printed page without breaking a single records' details over 2 pages.
I have a client application that uses an MSDE local database to build reports formatted as web pages including pictures. Pictures are stored in a virtual directory. Reports/web pages are built against a temp table in the MSDE with picture names in a field in the records. The problem is that not...
Thanks George, for your response. Yes, I am expecting just two records (in this case) however there are other header/detail relationships that have as many as 12 details to one header. I have intentionally marked all fields to be returned for simplicity in posting, whereas I actually will select...
Here's my pronlem. I have an MSDE database with two tables, tblHeader and tblDetail, a one to many relationship. In my code (posted below) I use an ADODC control. Data is returned, but using the control on the form I have to click the next record arrow as many times as there are detail records...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.