Home » Business & Finance

Business Software

Hi, I have a table called payer_det which will record the details of the payers. This is a subform. I have other fields on the table which are not shown on the form. However, when a field such as payer_code is selected in the subform I want the other three fields i.e., fin_code, HESA, and...

Comments (1) | Promote | Bookmark

I'm using =IF(ISERROR(formula),"",formula) and it's giving what I want: the cell(let's say B1) is blank instead of saying #VALUE! (B1 has a formula related to A1) but when I try to put a value to the A1, I get a #VALUE! reponse instead of the original answer to the formula. I...

Comments (1) | Promote | Bookmark

Currently I use Access form/subform to design a database interface. I have a couple of combo box fields, one of the field will pop up only based on the upper field value is true, for example, field "individual_session" and field "nationality", the nationality field will pop up a...

Comments (1) | Promote | Bookmark

I have just started using Works 7 after years of Word 97 and when I create an address template for letters I cannot remove the header from appearing on the second page. The only option I can find is to remove from the first page which is not any good! I am operating on XP....

Comments (1) | Promote | Bookmark

We are a group of freelance translators. Our customers send us their documents to our email address. We are using MS Outlook 2002 SP-2 (Spanish Version). The problem is that this account is installed on one pc and this means only one person can send and receive at the same time. We'd like to...

Comments (1) | Promote | Bookmark

Hello Tom, I asked Bill this question and he responded and gave me a formula but when I went to ask a follow up it said he's not taking any more questions so I thought I'd ask you. Is there a way in MS Excel to manipulate a cell to know the date from Monday to Sunday and update every...

Comments (1) | Promote | Bookmark

I am using the Vlookup command, in order to search for previous stock prices of the 20 previous trading days prior to a specific time. The problem I am running into is that the stock market is only open 5 days a week. For example: =VLOOKUP(('Winter Earnings'!C45),Historical_Prices,5,FA...

Comments (1) | Promote | Bookmark

Excel Formula...

Comments (1) | Promote | Bookmark

Hi Ken, I have macro that i'm currently working on. What this macro does is it loops through excel files stored within a folder and applies table formatting and etc. However the problem that i'm running into is the Range for Table is fixed to 2702 Cells however there are spreadsheet...

Comments (1) | Promote | Bookmark

I am using Word 2007 and want to retain duplicates when doing a label mail merge but it automatically removes the duplicates. Thanks, Dorothy...

Comments (1) | Promote | Bookmark

How can I convert amount into words? For Example, I want to write PHP 125.75 into words, how can i get this into "One Hundred Twenty Five and 75/100 Pesos"?...

Comments (1) | Promote | Bookmark

Hello and Thanks. I am trying to create subtotals by "Name" as shown below: Here is the data: Name Amount John 10 Mark 10 John 20 Mike 40 Mark 20 etc Here is how the output should look like. Basically, we need to search the "Name" column (cell A2:A100) and subtotal by ...

Comments (1) | Promote | Bookmark

Hi! This probably have a simple solution, but I can't find my way out here. I need my Access 2007 database users to select "Month" or "Quarter" or "Year" in the Option Group in a form and pass that selection to the "RegDate" criteria field (Date field type) ...

Comments (1) | Promote | Bookmark

I am trying to write an if then statement. I would appreciate any of your help, thanks in advance. Let me first try to explain to you what I am doing. There are 16 teams, and I am trying to have excel automatically calculate the points based off of where they finish. Take team one for...

Comments (1) | Promote | Bookmark

how to lock word documents for edit...

Comments (1) | Promote | Bookmark

hi, i need to write some data in an excel file to a text file. I've a macro for this. But the requirement is that i need to place data at specified location (column) in the txt file. I've no clue as to how this can be done. Bit more explanation on the requiremnt: Lets say column A has...

Comments (1) | Promote | Bookmark

Hi, I have an access database that has several custom fields, and over 50 queries set up in it. (I have never used Access). How can I do 1 single export that will show every record and every database field into 1 spreadsheet so I can see the full database in excel? Thanks, Jesse...

Comments (1) | Promote | Bookmark

Hello Tom, I hope that you are well. I would like to find a text string within a long list of possible responses. For example the list could be: A1: Mary is tall A2: John is short A3: Brenda is medium A4: Mark is medium I would like to be able to find a string such as "is medium" and ...

Comments (1) | Promote | Bookmark

Hi Scott me again. Thanks mate, that's working a treat :) Now, I don't know if you remember, but I did mention that I had a couple of things I wanted to ask you. Here's the rest........... 1. I'm using a Switchboard to open my Form to view the data and when the form opens I...

Comments (1) | Promote | Bookmark

I have deleted all of the normal files from the template folder. I have uninstalled and re-installed office 2000. When I open word from programs, it opens with a blank document but no headers at the top, file, edit, view, etc. It then does not respond. When I click on a word file to open, it...

Comments (1) | Promote | Bookmark

I have a huge clearing account to reconcile and would like to automate the process using Excel. I would like to be able to drop new data into a spreadsheet each month (about 3000 lines)then sort it by purchase order number, subtotal data by PO #, and then delete all information that has a...

Comments (1) | Promote | Bookmark

What is the equivalent animation in the 2007 version of PP to "Credit" in 2003 version of PP? I'm trying to scroll text in 2007 and don't see an equivalent scheme.Thank you!Jackie...

Comments (1) | Promote | Bookmark

Hi - I am trying to install the Microsoft Global IME for Japanese. I have downloaded the imejpn.exe from the Microsoft Website, yet when I click it to install if gives me an error saying, This set up required Office XP. I am running genuine versions of Microsoft XP and Office 2003. I have found...

Comments (1) | Promote | Bookmark

I have Sheet 1 which is a data entry form (of sorts). Some of the cells on sheet one are drop down "pick" lists housed on Sheet 2. No problem with those. But, on Sheet one, I also have some data that requires the user to look up a combo box (created as a control) on Sheet 2 which has two...

Comments (1) | Promote | Bookmark

Please find a copy of the question I have posted and have now been directed to someone deals with MS office as suggested. Hope you can help. Thanks Merike Question I emailed Lorry - who is now on holiday. He very kindly sent me a reply which gave three links to the MS solutions for Publisher...

Comments (1) | Promote | Bookmark

I need to multiply a single text cell to 5 or more cellsPlease Help! (this needs to be done on a large scale)i.eaim = aimaim1 aim aim aim aim aim1 aim1 aim1 aim1 aim1...

Comments (1) | Promote | Bookmark

Hi Miguel!I'm trying to write an excel macro that will copy the contents of a worksheet and paste them into a second worksheet below exising data whose row count can change. (a very basic append). How do i select/activate the first blank cell in a particular column?...

Comments (1) | Promote | Bookmark

Ideally - I want to create a form that has a place to put the cursor and when the bar code reader enters the code in it, the appropriate info on that customer will pop up. Then the receiver can enter the date received. Ideally I would love to have the date field automatically populate, but...

Comments (1) | Promote | Bookmark

Can I assign keyboard shortcuts in Excel 2007, and if so, how? I cannot find this information anywhere. Thank you,Dawn...

Comments (1) | Promote | Bookmark

Hi, Dale. Word 2003. I have been asked to set up a type of newsletter. They want page 1 with a heading (no problem) and a full length text box on the right for contact info etc. (again no problem); leaving a panel about threequaarters of the width of the page to type in. So far so good. However,...

Comments (1) | Promote | Bookmark