Search results

That worked great. I created a brand new spreadsheet and just imported the macros and the tabs. The new file is only 400 KB. Thank you for your help.

I have a spreadsheet that I am using for a template. The template has two pretty simple macros and a handful of formulas. Since this is a template, there is no data in the spreadsheet. However, the size of the spreadsheet is about 28MB. I don't understand why the spreadsheet is so large, nor...

I'm actually trying to get an average of the days to process the orders. The easiest way I could think to do this is to give each order its' own line. So, if a project with 10 orders takes two days to process, the average days to process and order is actually 0.2, not 2.

In my database, I have a table that houses information based on order project. An order project can have anywhere from 1 to 50 orders tied to it. This is just one record in my database, but there is a field that states how many orders go with the project. For average purposes, I would like to...

Can the AverageIf formula be used as an aggregate formula? I'm trying to get an overall average from 5 tabs on a workbook. I tried using =AVERAGEIF('MON:FRI'!F6:F615, ">0"). Unfortunately, this returns a "Value" error. Is there a way to get this to work?

That works perfectly. Thank you very much for your help.

Is there a way in a query to calculate the number of workdays between two dates? I have an order received date and an order released date. I would like to see the number of workdays between those two dates. For example, if an order was received on April 8 and released on April 11, it...

I have a database that is split and I want the users to have a copy of the database on their harddrive, instead of using it off the network drive. The problem is that some of my users are over seas and the desktop on their computers is linked to a network. I have code that works great if the...

That worked perfectly. Thank you very much.

I need to combine the date and time column on my spreadsheet, so that I can calculate the number of days that it takes to complete an order. I've tried everything I can think of, but Excel will not allow me to combine these two columns into one. Do you know if this is possible? I have my...

Is there a way to monitor an Outlook Inbox (one that is not the primary inbox on the computer) through Access? My department has a department Inbox that everyone has access to. However, since it is not the primary Inbox, we are not notified when messages are received. Is there a way for...

Is it possible to update one record on a table from another record in a form? I have a form that tracks orders. It shows if one order is replacing another. If it is, the database checks to see if the old order needs cancelled. If it does, a message appears on the screen letting the user...

I have a table that contains order information based on order number. In that table, I also have a field labeled ReplacingQuote so that when one order is entered to replace another, we can keep track of it. Now, I want to create a query that will show this history, but I can't seem to get it...

Thank you for the information. I appreciate it. I added the code from the Allen Browne website and modified it for my Customer table. However, when I try to run it, I get the "Function not defined" error. Below is the code that I've added, could you tell me what I'm doing wrong? Dim...

I have a ComboBox on my form that has a lot of options (its for customer name). Is there a way that I can program the combobox so that once the user enters the first couple letters, the combobox will just show the customers starting with those letters? For example, when the user enters BO...

Okay, I'm a little confused. This worked yesterday, so I don't understand why I can't get it to work today. This is the formula I'm using : ={MAX(IF('Monthly Demand'!$K$1:$K$48330 = 'Executive Overview'!B51, 'Monthly Demand'!$I$1:$I$48330))}. I don't know if the problem is that column K...

That works great. Thank you.

Is there a formula that will show me the maximum value in an array based on a certain criteria? I have a list of parts and the teams that repair them. I want to find out the part in each team that has the highest dollar value. Is there a way to do that without needing to go through each part...

Does anyone have any suggestions on this? Do I just need to leave this code in Excel? If so, is there a better way to write it (i.e. without using the SendKeys command)? Is there a way to get Access to enter information in a non-Microsoft program?

Actually, what I need to do is take the results of a query in my database and use that information to update another system that tracks the technician inventory (that's the Extra.System that is referenced in the original code). The Extra program functions like a table. You pull up the bin...