Search results

I just re-vamped our main form in the database. Now my users are complaining that the database will randomly close on them. It seems to always happen if they allow their computers to fall asleep with the db open but it also occasionally happens while they are working. There are no errors...

SQL Subqueries Can anyone tell me what is wrong with this complex query? It works fine without the highlighted subquery. The subquery works fine on its own. But they don't work together. I think that I might not be able to call multiple results from a subquery but I'm not sure about that...

I need to run a report via macro that runs once a month on the first business day of the month. I can't figure out how to specify that condition. Seems simple, but I just can't think of the solution. Any ideas? thanks in advance.

I need my users to be able to open a macro in design mode because they are using the transfer database function to bring in a report that changes names every month. So, they need to update the source file before running it. Is there a way to open a macro in design mode besides doing it from...

I have a macro that uses send to to email a report to various people in excel format. It works fine. The problem is when I use it on my computer (Windows XP), the file type choice for Excel is "Microsoft Excel 5-7" but on my main users' computers (Windows 2000), it fails unless I manually...

I am trying to create a report that has the number of cases and loose cans that a customer orders. The number is stored as quantity ordered (qtyord). It will tell me that the customer has ordered 1.25 cases and each case has 24 cans on it. I want my report to say that they need 1 case and 6...

I have a report that I run and output to a word document using rtf. Each page of this report is a release for a different cold storage. And I only want to send each cold storage (by emai) the release that applies to them. So, depending on where the product is coming from on any particular...

I have a macro that is running a series of queries to append order information to an archive table. Since the order info is held in 3 one-to-many tables (Order, Line, Lot), they MUST run in sequence or else there will be a key violation. In other words, the Order must be written to the order...

I'm hoping someone will be able to help me get my brain around this problem I'm having! I think its probably simple but I'm just too stuck in it to see out. :eek: So, I have a database (big shock, I know) that is tracking order dispatches. Usually, there is just one order per dispatch and...

I am trying to finish an Access database that someone else started. In many of the queries, the design grid is missing. In design mode, I can see the tables and relationships being used, but the bottom portion is simply not there. I have tried scrolling to the bottom to check and see if it...