Search results for query: *

Worked like a charm. Thank you sooo much!!!

First of all, I just want to warn you that I know very little when it comes to Access AND VBA. However, I've been looking through the forums and FAQs trying to find the answer to my question and I think I am almost there. I've just got one problem that I can't seem to fix on my own. Any help...

You're right. I did not know that. It worked perfectly. Thanks for the help.

I have, in the list, major components, and under the major components are the individual pieces of equipment. Like in my sample, the major component is the boiler and the auxiliaries. Those lines just sum the dollar amounts in that particular category. When I do the subtotal, I do not want to...

I'm trying to do use the subtotal function in an Excel spreadsheet. I have 5 worksheets in the file. I got the subtotal function to work perfectly on the first three tabs, but the last two units are far larger and there are too many references for the function to work. Is there another way to...

I have a table created in Microsoft Word and I was wondering if it was even possible to add conditional formatting to the cells. I have three cells that I want to automatically format when the contents change. If the cell contains the word green, I want it to turn green, yellow for yellow and...

I have the "Title" as my primary key and when the user goes to save the form, if the title they have entered already exists a message box appears. However, this message box is unclear as to which field is the duplicate. I want to create a message box that appears as soon as the user tabs out...

I have an Access database that includes information that needs to go into an Excel workbook that is already created. I can import the information into an Excel spreadsheet, but it is nowhere near the format that I need it to be in. Is there a way, possibly using VBA, to get the information...

Thanks. I did a search and did find the script. I'm a little slow on the uptake. Sorry to trouble you and thanks again.

If I have a column in a Report with an e-mail address can I automatically generate an e-mail to someone that will attach a short message and the report?

I'm not exactly sure how to do that, but that definitely gives me something to play around with. Thank you so much for your help.

I need to open a new record when a form is opened for employees to input suggestions and recommendations without deleting existing suggestions. Also, if an employee opens the form and decides he/she doesn't have time to finish, I don't want Access to save the blank or incomplete record. I've...

I'm trying to create a spreadsheet that changes the color of the cell based on the number that is put into it. The numbers are 1-5. I used the conditional formatting option, but it only allows for three conditions and I need five. What do I do? Thanks, Veronica

Using multiple IF functions worked perfectly! Thanks so much! I tried using the MATCH and OFFSET functions, but I really don't know how to go about doing that. It seems like it would be much easier than having a 7 line function, but I just haven't quite grasped it.

I'm trying to create a spreadsheet that will take a project's cashflow entered into one sheet and put it into another sheet, but I need it to automatically be placed into certain cells depending on the date that is entered. For example, if on the input sheet, they put in a project that will...