Recent content by Cocis91

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

Perhaps this time! ------------Fund1----Fund2----Fund3 Start age-------------------------- --20---------20%------40%------40% --40---------30%------35%------35% --50---------50%------20%------30% --60---------80%-------0%------20%

Hopefully the alighnemt will display better this time... ------------Fund1 Fund2 Fund3 Start age --20 20% 40% 40% --40 30% 35% 35% --50 50% 20% 30% --60 80% 0% 20%

Here is an example of the sort of layout I am looking for. It is basically as you would set up a spreadsheet - with a spreadsheet you would be able to add another fund if you wanted or insert a row to add a new age band. Fund1 Fund2 Fund3 Start age 20 20% 40%...

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

Many thanks for your solution. I did the same thing as you described but with a Macro. It works fine.

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

Thanks for the reply. I got round the problem by setting up an expression column in the query : Expr1: nz([Customers].[LastName]) And now in the criteria part I have : Like ([Forms]![MainForm].[SurnameSearch] & "*") This is now doing just what I want. If no surname is entered then all...

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

Thanks for the responses. I solved the problem with the use of the code that can be found at: http://support.microsoft.com/support/kb/articles/Q95/8/06.ASP?LN=EN-US&SD=gn&FR=0 This code is intended for producing a specified number of labels for a print job where you are only printing one kind...

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