Search results for query: *

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...

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...

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...

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...

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...

Hi, My database contains various information about leaflets, with each leaflet a seperate record, with a unique ID number. I want to have a button on the form which will open up Adobe Reader and display the PDF relevant to the record. Each individual PDF is saved as the ID number from the...

Here is what I want to do: In my database of products each individual product has a specific stock level, below which the product has a shortage. From the main record page, I want to have a button which previews a report which lists all products there is a shortage of. I guess I need to make...

Hi, Being relatively new to Access 97, I have a problem that is driving me crazy, but which is probably straightforward. In an existing database of customer details, I want to add a subform (in the shape of a tab) to the main record page. This subform will show the details of a particular...

Hi, I want to print labels from a database of customer contacts. Each record can have two different types of address, each of which is held as a seperate field, although not all records will have both types of address. I want to generate a label which will display one or the other type of...

Hi, Not knowing Access 97 particularly well, I am finding it difficult to solve this problem. I have a form which allows users to insert booking details, including the date on which a booking will take place. I want to be able to prevent a user from putting in a date that is in the past, and...

This is probably very simple, but I don't know Access particularly well. In a form I am displaying four fields taken from a table. One of the fields is the date of an enquiry. I want to display the records by date with the most recent at the top. I have set the date in the related table to...

Is it possible to justify text in DW4? Whenever I try this, it looks justified in DW4, but is not justified on the web.