Search results

I have a field in a form and I want a person to be abkle to type in a calculation expression and then to press a button to get the answer in another box. For example, you might type into the text box : (4+5)/3 The thing I don't know how to do here is to create a function which grabs the above...

I am making a database which records people's contributions to a pension plan but then invests these contributions by splitting them up and investing them in a variety of funds according to a certain ratio. This ratio by which a contribution is split among the funds is to vary with age so for...

I have a form which operates perfectly well, but when a filter is applied to it and you then try to move to the next record (using the record navigation buttons at the foot), I get a message saying that Access caused an illegal operation and will be shut down. It says to contact the vendor if...

I have a report which must include a Company's name in it. My database has a Global form (tied to a Global table) which contains the user's company information and one field is CompanyName. There is only one record in this table - the company's information. In my report, I want to display the...

I have an Orders form which has on it a field which is a tick box which is ticked if there is nothing left outstanding on the order - ie if it has been sent and if it has been paid for. I would like it that when an order is signed off, a user cannot accidentally change any of the information in...

I am trying to set up a Query By Form. I have a form with an unbound field on it and when you click a button it opens a form where the data for it is tied to a query. The underlying query has one of its field's criteria dependent on the first form. The field that the query is sorting on...

I have a pretty standard Orders form which contains an 'order details' subform for selecting products to be ordered. The subform is in datasheet view (like in the Northwind database) and you use a combo box to select a product from a list of available products. This is fine for if you don't...

I have no problem creating a mailing labels report which produces one label for each record in the query. However, the query contains a field that has on it the desired number of labels for that particular record. How do I amend the labels report or create a new labels report that produces a...