Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rkasnick

    Code to link many tables to a master table

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

    Excel not quitting in code

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

    Excel not quitting in code

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

    Large volume .trt file research help needed

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

    Large volume .trt file research help needed

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

    reprinting on reboot of server

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

    reprinting on reboot of server

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

    migrate from SQL 7 to SQL2005

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

    Notes email VBScript

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

    Mail Delivery Question

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

    Email Options

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

    Hightlight All Instances Of A Word In Richtextbox

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

    Toolbar disappears after form activate

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

    Toolbar disappears after form activate

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

    Pictures not displayed randomly

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

    Pictures not displayed randomly

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

    Pictures not displayed randomly

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

    SQL query with join not working

    Thanks to all who have responded, I have resolved this with other coding structures.
  19. rkasnick

    SQL query with join not working

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

    SQL query with join not working

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

Part and Inventory Search

Back
Top