Search results

  1. A

    Primary Key Problem

    My database has a table tblCombinedPropInvest which is a temporary table. Four of the fields in this table are Tax year, State, County and PIN Number. These fields are entered in a data entry form. When all entry is made and append query calculates a PropertyID field and the records are...
  2. A

    Message on Report from iif statement

    I have a report with the following equation to give a status message at the end of the report: =IIf([RedemptionDate] Is Not Null,"THIS PIN HAS BEEN REDEEMED",IIf([DateAbandoned] Is Not Null,"THIS PIN HAS BEEN ABANDONED",IIf([DateSaleInErrors] Is Not Null,"THIS PIN IS A SALE IN...
  3. A

    Formula with two conditions

    I have a query which is the data source for a report. To find the correct number of penalty periods the formula is penalties:(([RedemptionDate]-[CertificationDate])/182.5)+1 which is fine if there is a redemption date. It give an initial penalty then another penalty each half year. But if...
  4. A

    Object Dependency Window

    I opened the object dependencies window trying to print the information in the window for lack of a report. The dependencies window opened on the far right side of the screen as always. Somehow in trying to print more of the window I moved it and now it opens across the entire width of the...
  5. A

    Select Record from combo box

    I have a form based on a table with a combo box to select a record. The fields in the combo box are PIN (a ten digit number to identify a property: example 0208101010) and PropID (a field identifier made up of the tax year, state, county and PIN - example: 2008-IL-Lake-0208101010). PINs can...
  6. A

    Select Record from combo box

    I have a form for entering property tax. The form is based on a table called investments. The form contains a combo box to select the appropriate property for data entry to the table. The two fields in the combo box are Property PIN and Property ID. The property ID is a combination of tax...
  7. A

    Cascade Delete

    I have a database with two related tables based on a property ID code. I want to have a cascade delete so when I delete a record in the property info table the related record in the investment table is deleted. The rpobelem is this is a one to one relationship because the PropertyID is the...
  8. A

    Selecting Record from Combo Box.

    I have a form to modify existing property records. Each record has a PIN number and a unique ID which is a combination of year, state county and PIN. The same property can have a record for more than one year. On this form I have a combo box for selecting the record to be modified. The...
  9. A

    Between parameter on report

    I have a report based on a query with a between two dates parameter (Begin date and end date). This parameter is fed from a form. All works well - query, form and report. My question is can the date parameter appear on the report header so users know the report was based on a start date of...
  10. A

    Parameter query with multiple criteria

    I have a parameter query where I have paramers for the fields: completion date between two dates, State, County and Buyer Number. Everything works great. But, I want to be able to either select a buyer Number or have the query show results for ALL buyers. I tried {Enter Buyer Number] OR Like...
  11. A

    Combo box for parameter query

    I have a parameter query where the input is through a form. One of the field is a simple Buyer Number. To make it easy for the client I want to select this from a combo box. When I choose thw buyer though it returns no records. The same buyer when I choose it through a text box gives me the...
  12. A

    Paramater Query for ALL

    I have a query which has parameters for Buyer, Tax Year, State and County. I make my selection for each field and it works fine. I will always make a selection for Tax Year, State an County, but I need the flexibility to run the query for all Buyers. I can run the query for all buyers but it...
  13. A

    Modify records via form

    I have a form in Access 2007 where the record is selected by a combo box. The combo box is based on a query and selects the desired field (Property ID) as well as other fields from the query. Two fields, date redeemed and amount redeemed are filled in when the proper Property ID is selected...
  14. A

    Move to next field

    I have a form where the record is selected from a combo box. Once selected I enter a number of fields in a selected tab order. The form cycle is set for All Records. The Move After enter is set for next field. When I tab or enter from the combo box I want to move to the first tab field in...
  15. A

    Requery sorts results on form

    I have a form to enter data into a table. One filed in the table comes from a combo box based on a query. When the other two fields are entered the form is requeried to compare the entry against expected results. My problem is when I do the requery the record I am working on gets resorted and...
  16. A

    Field formats on form

    I have a form that has fields (text boxes) selected form a combo box. One field is currency format an the other is percentage format. The source for the combo box is a table and both fields are formatted properly and display properly as currency and percentage in the table. In the form I have...
  17. A

    Table names Back End to Front End

    I have a form using a linked table named TotalInvestments. This name appears in the table list on the Front End. But when I open the Back End there is no such table name. It is named TotalInvestmentsREV3. The form shows the data source as TotalInvestments bur when I add a record it appears...
  18. A

    Greetings from Wayne

    I'm not actually new but returning to the forum. A few years ago I was active in application development in 2003. Currently I am supplementing income on a new project in 2007. Much tougher than anything I've done before. When I'm not working in Access I run a non-profit, Andean Aid, working...
Back
Top Bottom