Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Gerimc
  • Content: Threads
  • Order by date
  1. Gerimc

    Updating a field in a record

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

    Showling Redundant fields/data

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

    Report Filtering Criteria

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

    Adding a new year - and checking to see if its already there

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

    Data Validation - Stopping duplicate data

    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?
  6. Gerimc

    Treeview - Sorting

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

    Microsoft List View Control - Fields are Invisible

    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?
  8. Gerimc

    Filtering data to produce report results.

    I want to create a report depending upon a selection from a combo box. Should I create a form with a combo box on it to filter the results I need for my report or should i have a combo box on my report or is that possible? I am filtering data for a particular year. I would ideally like a box to...
  9. Gerimc

    Filtering using data contained in two combo boxes

    I have a form which contains accounting data for different companies and for each year. I want to be able to filter by a year and then by the company and all the data for that particular selection will appear on the form in text boxes. How would I go about doing this? I have my combo boxes...
  10. Gerimc

    Filtering data using a combo box

    In my database I have a form called Population and from here I have a combo box contain different years. I want to be able to select a year from the combo box and it will filter the populations for different places into text boxes on the form. How would I do this ?

Part and Inventory Search

Back
Top