Recent content by stc

Thanks for the suggestions. In the end I went for the fairly low-tech, but effective, solution of just creating a new list. This does the job the way I had hoped!

Hello, I have a shared document that I intend to use as an order form. The idea is that all users will open the document (which is an MS Word document with a table), insert a new order and then close it. At the end of each week, one user will check the document for all the new orders...

Thanks for the help!

Having tried the suggestions on the FAQ, I'm still not quite managing to do what I need to. The problem seems to be that the values in column I are figures and I want to be able to sum the values of all the cells in that column if they meet the criteria in column A, unless they are negative.

Thanks! I expected it to be something simple...

I have an Excel workbook in which I want to look at the contents of column A, and if they meet certain criteria (A,B or C) sum the contents of the corresponding cell in column I, unless that value is outwith a certain range (less than zero or greater than 1000). I have tried using sumif in...

Part of my spreadsheet lists percentages. So C1 = 50%, C2 = 47%, C3 = 42%, C4 = 32%, C5 = 27%, and so on. I want to count the number of cells which fall into ranges, for example, 50%, 40-49%, 30-39% and so on. I have used countif(c1:c10,"=50%") for counting the cells with 50%, but I can't...

Thanks for the replies. I actully had set all the Locks and changed the Allow Edits and so on, and it still didn't work. But I was doing it on the form itself, rather than on the individual text boxes. I have done that now, and it works fine. Thanks again.

Hello, In my Access 97 database, I have a subform which has two text boxes showing information based on user-input criteria. When the form opens the first text box is highlighted, as though it has been clicked on. All I want is for the form to display the information based on the underlying...

Hello, I want to use the Find Record command on my form to, well, find a record. But using this means that when the Find dialogue box comes up, the user to untick the Search Only Current Field box and change the Match from Whole Field to Any Part of Field. Is there any way to have Any Part of...

Hello, I am having problems with a query I am trying to run. The query involves two fields, BusinessTypeID and DateCustomerActive. I want to be able to count the total number of customers within each BusinessTypeID (which ranges from 1 - 24) who have a value in the DateCustomerActive field...

Cancel the above! I sorted it out - there was a "rogue" record for both of the troublesome records, with different contact details. No brainer...

Hi, My database contains a table called Account Grade, which records, amongst other things, the Last Contact and Next Contact dates for various customers. In order to see which customers need to be contacted between a given set of dates, I run a query which returns any record from the Account...

Thanks for this advice. Simple and effective!

Hi, I have a database where the date on which a particular event has to happen is recorded. The form displays each record individually and shows when the event has to happen and what has to happen. Currently the database opens at record #1. I would like to change it so that it opens to any...