Search results

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

The problem is that a property may be both Redeemed and Abandoned but the statement only provides that is is Redeemed. I'm looking for a way that it will identify that it is Redeemed Abandoned. Once it meets one condition is stops.

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

So assuming my one formula is: penalties=([RedemptionDate]-[CertificationDate])/182.5)+1 where does the following go?: If [RedemptionDate] is null use Now, if not, use [RedemtionDate] to trigger using the Redemption Date or Now()

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

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

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

Record First Where Condition ="[PIN_Number] = " & "'" & [Screen].[ActiveControl] & "'"

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

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

The users are familiar with the PIN. The same property can appear in subsequent years. The combo shows the PIN and the PropIDs (unique ID) for each PIN as separate records. They also show as separate records in the table and query. But, the combo box will only select one of the records (1010...

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

Thanks to you both. It works great. Tried something similar but a macro had the form closed. Now with the form left open I get exactly what I want.

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

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

The bound column of the combo box is text. If I direct the query to a text box it selects the buyer as entered. But the same buyer number in the combo box returns no records.

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

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

Bob,good to hear from you. You helped me a ton when I was doing Access development in 2003 a few years ago. The Data Entry property for this form is set to NO. Not excactly sure what you mean by trying to open it but it is opened from a control button on a menu page. It opens fine but...

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