Search results for query: *

How would I do this? If A2 is >= 1/1/2003 and <12/31/2003, put "2003" in T2 If A2 is >= 1/1/2004 and <=12/31/2004, put "2004" in T2 If A2 is >= 1/1/2005 and <=5/31/2005, put "1H2005" in T2 If A2 is >= 6/1/2005 and <=12/31/2005, put "2H2005" in T2 If A2 is >12/31/2005, put "2006 or over" Thanks...

I have a spreadsheet that I want to hide. I go to Properties and click Hidden and then Apply. What happens is that once I exit out of Excel, the hidden files appear again. Am I missing something? Thanks in advance.

I have a main form and a sub form. In the main form, I have a button that when clicked, prompts for the ID number and then emails that record from the subform. I would like to include the ID number in the email subject. However, because the ID resides on the subform, it is not recognized...

I have a spreadsheet with a hyperlink bookmark to a separate worksbook. There are several worksheets in the separate workbook that I am navigating back and forth to, so when the user navigates back and forth, it thinks it wants to open it again. Is there a way for Excel to know that the...

I get the following error message when trying to save a template (kind of, anyway, my version is in Swedish): 'Excel cannot complete task with available resources. Choose a smaller amount af odata or close other applications' (OK button only) This is followed by an immediate new msgbox...

I have a spreadsheet that I would like to add up a column if the below criteria is met: Sheet1 If Column A = whenever it equals "red" If Column B whenever it is between "03/01/2005" and "03/31/05" If Column C = whenever it equals "0712" Sheet2 Put that value in Sheet2, Column D. So if on...

I want to create a macro that will group columns F & G and columns J & K - all at the same time. This worksheet has the "Forecast" and "Actual" numbers. So when the macro is run, it will only show columns A-E and columns H-I, and any columns pass column K (these are the "Forecast" numbers)...

I have a report that I have a field [Total/Project Balance]. I also have lines for CustName that each have a Total/Project Balance. There may be many lines for each CustName, each with their corresponding Total/Project Balance. I want to total up all of the [Total/Project Balance] for the...

I have an Excel spreadsheet that is updated every week. I would like to import this spreadsheet every week into an Access database. I know how to do this, but now I need to take this further. When I import the spreadsheet every week, I am using the CustName field as the primary key. The...

I have a form that has two fields. [DateTransitioned] (mm/dd/yy format) [NoTransition] (yes/no format) If the user checks the [NoTransition] box, I want to grey out the [DateTransitioned] field and so that the user cannot put a date in there. The error message that should appear is "Since...

I have a report that is based off of a query. In the query, I prompt for employee's name [EEName]. The EEName may be in several places, so I added a field that combines all of the several places in one field. Then I put in a prompt that asks for the employee's last name. EENameAll: [Field1]...

How do you open up to the first worksheet (tab named "MainMenu") each time you open up your Excel file. I want to send an Excel file to a few people and I want Excel to automatically open to MainMenu each time they go into the file. Let's say they open up the Excel file which is an attachment...

I went into Startup and checked off all of the boxes. Now I cannot get the Toolbox or Menu bar back. I need to change some forms, etc. Is there a way to get the menu bars and toolbox back?

I have a subform that I would like to only be able to limit 18 records. Is there a way to do this? Thanks in advance.

Right now I have a report with 20 records. I want to number the records in the report in descending order. So, beside the first record, I want to have 20, the next record would be 19, etc. Thanks in advance.

In Word, when I send an Word attachment via email and then try to open up the attachment in the email message, I'm getting "Do you want to merge changes in documentname.doc back into w:\path\documentname.doc?" In some instances, when I open up the document that I have sent, it comes out as a...

I have a combo box haircolor that the user chooses different values. What I want to have happen is when the user chooses a option in the combo box, when they tab to the field addtlinfo, I want the controltip to be dependent on what choice they made in the combo box. So for instance, if value...

I am trying to add alternate grey lines to a header. The reason I am using a header is because I'm using the header for summary information. I made the detail section not visible. I looked on FAQ and it has this, which works in the detail section. I need to make my line alternate grey in the...

I have a Comments box that is a memo field. I would now like to separate this Comments field into a datasheet format. The comments field is one big field and the user puts the date, then a dash and then the comments. To put in another date, they currently stay in the Comments field and press...

I need to calculate the difference between two dates not including weekends or holidays. Is there a way to build a holiday table and have the formula subtract those holidays automatically? Also, I tried NETWORKDAYS but that gives me the wrong answer. For example, if the date in A1 is...