Search results for query: *

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

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

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

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.

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

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

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

I have a client who has a group of 12 designers and production engineers who all have a need to share data in a database. Better than half of them take work home as well as working in the office so a copy of the database travels with them, to be synch'd up to a master copy when they get into the...

I have a SQL2K database that is 12 GB in size. I would like to make the max size 9 GB. Shrinking the db frees up space but doesn't reduce the overall size. THe online manuals aren't much help, probably because I am using the wrong search term. Can anyone point me in the right direction? Thanks

This one has me vexed. I am trying to validate two fields, name and email address, if the validation passes then send an email with both, and then open a form which has a download link on it. I want to have these three actions all performed with the same 'submit' button (one click of the mouse)...

Hi All. Here's a question I have not been able to get my mind around. On a form I have a checkbox for each month (12), a checkbox for each week (4) and a checkbox for each day (7). If a user checks Jan and week 1 and Tues, I want to calculate the actual date for that day(assuming the current...

OK, I'm stumped. I have a query and in the design grid I am using the following criteria: Like '" & [forms]![fBulkEmail]![text101] & "*' which bases the selection on a field on a form. This syntax returns no records. I cannot find my reference for this and I KNOW it should work, but am sure I...

This version may be beyond this forum's limits, but does anyone know the procedure to import data from Access 2000 into MAS 500 for purchase order data and export to Access 2000 Invoice and Advanced ship notice data? I am not looking for a specific script, only the procedure(s) that would/could...