Search results for query: *

Thanks! I checked that box. We shall see what happens next. I'm guessing that since we are on the 6th of the month, I'll be missing data from the last close until now. At least I should have something to go on now. Thanks again! Dave djnewman@itrweb.com

ProdOps- Wrap the prompts with a CVDate call. In the criteria cell, put between cvdate([BeginDate]) and cvdate([EndDate]) If you get an error with this, then you are not giving the cvdate conversion function a good value. Good Luck! Dave

Vinay, You can write a bit of code to accept the software name from the user and save it in a variable. Use the variable to fill the parameter from the query. I assume you have a canned query or filter that runs when you open the report. You can put the code in the OnOpen event of the report and...

Bill, Notice that both mdb's have an associated .LDB file when an access is made to the back end database. The lock file tells you that in fact, a slot is being used. In Access 97, you can view the lock files as text to see what ID's are in use. Dave

Hi! I've been trying to get the Sales Order module to save history to tables SO_04SOHistoryDetail and SO_08SOHistoryARInvoiceLink. The information is also in AR4_OpenInvoice, but I need the detail transactions AFTER the monthly close is completed. I have this for 2 companies, and I need it for a...