Recent content by Gerimc

I have a field in a table called balance carried forward, i have this field stored in a table called yearlyrates. When i run my form i want it to pull in the value from the table, this I have done. The figure can change from time to time and is calculated using a number of other values. I want...

I have a database which holds ServiceTypes, Services and SubServices for an organisation. There are approx 5 ServiceTypes and from these there are a number of Services and from the Services there are a number of Sub Services. They make up a sort of a tree structure. Some of the reports that I...

I am setting up filtering criteria for my report. I want the user to select the report type then from a combo box they choose the financial year they want the report based on. I am trying to do a comparison report here and I want to be able to select a number of different areas to compare. I...

My financial year description isn't my primary key so there is no validation on my form to stop me from having the same fiancial year string entered more than once. I am inputing my fin year in the following format 2001/02 the primary key is just an autonumber so the database is just letting me...

I have a table called FinancialYearTbl which contains the fields FinYearPkFld, FinYearDescritpionFld and a RedundantFld. I also have a form called MaintainFinancialYearFrm Which shows the FinancialYearDescritpion field and a redundant check box. A user will use this form to add new financial...

The year is a text field - but i am still getting that type mismatch error. I am wondering do I maybe need to reference the Primary Key field of the Financial Year tbl ?

I have entered the following: If IsNull(DLookup("FinYearDescriptionFld", "FinancialYearTbl", "FinYearDescriptionFld = " + str$(Forms!MaintainFinancialYearFrm!FinYearDescriptionFld))) Then I am getting a type mismatch error. Do you know what the matter might be ?

The value yrval would that come from the financial year table and if so would it be the financial year primary key field or the description field ?

I have a maintain financial year table – when a user enters a new year I want my form to check if this year has been added before. If it has an error message should come up telling the user this year already exists else the user should be able to input the year, How would I go about doing this?

I am using Access 2000 and have developed a treeview that displays service types which are broken down into services which are then broken down in sub services. They each have a primary key field but they also have another field called for example when its a service - service order fld and for...

I have a list view control (version 6) and all fields displayed in it are invisible. How can I make them visible? I can see the outline in the list box so i know the fields are there I just can't get the text to appear. Any ideas?

Thanks for the tip about allow edits that worked! How would I alter my form to allow the query to be a control source? Also in my qurey would I put the code under yearid or year description. My combo has these two fields with the description being shown.

Jim, I entered the code as you had shown but on my form I can see my list of options for the combo boxe but it won't let me select one. Do you know why this would be ? Also do I type "MyYearGuy" Or do I put data of my own in here?

My Combo boxes are in the form header area and my text boxes are in the detail section

I have a country table - contain country id field, description, contact etc... I have a yearly rates table which contains country id, yearid, various figures for the country and population field is stored there. I also have a year table which holds yearid and year desciption. I want to select a...