Search results

Thanks! I'll give it a try. Cheers! Sheila

Yes. And i already have the code for new records using Candace Tripp's "Autonumber without autonumber" sample database. What i need is a code to apply to my existing records. A million thanks! Sheila

Yes it does. It's the PK of my 3rd table which is tblPolicyData.

Hi lightray. Thanks for your response! I need an incrementing unique number for each PolID. If i add a new PolID, the ColNo should start at again at 1. I hope i explain myself well. Thanks again. Sheila

I have 4 tables on my dbase. On the last table underlies all records pertaining to customer payments. tblCollectionData ColID - PK PolID - FK Amount ORDate ORNumber I want to add another field which i would name -- CollectionNumber. In this field, i need an incrementing number for each PolID...

Thanks a million! It works! Sheila

apr pillai... I CAN'T THANK YOU ENOUGH! Exactly what i needed! Thanks a million! Sheila

Thanks for your help apr! I'll give it a try. Cheers! Sheila

Hi Rich! Thanks for your response. I need to sum up all the records on my report. I just emphasized one policy number. If i have 4 records of PolicyNumbers with Premium amounting to 12,000/each, the sum total should be 48,000.00. But because there are possible multiple payment for each...

I need assistance on one of my reports. :-( How do i limit the sum total of one record? PolicyNo PremiumAmount CollectionID AmountCollected OfficialReceipt DateOfReceipt ABC 12,000 1252 2,000 152680 21-Sept-05 ABC 12,000 1253 2,000 152681 21-Oct-05 ABC 12,000 1254 2,000 152682 21-Nov-05 ABC...

Thanks for your inputs Rich, but it gave me the same result. :-(

I have the following fields in one of my tables: CollectionID AmountCollected OfficialReceipt DateOfReceipt I made a query out of these fields: CollectionID AmountCollected OfficialReceipt DateOfReceipt 1252 2,000 152680 21-Sept-05 1252 2,000...

In one of my forms, i have this event procedure: Private Sub Gross_Com_LostFocus() If Gross_Com.Value >= 1000 Then Full_Com.Value = [Gross_Com] * 0.2 Else Full_Com.Value = 0 End If End Sub Is it possible to put such code in a report and query? If so, how? Thanks a million! Cheers! Sheila

Thanks Curtis! I'm beginning to get the idea now.

Hi Curtis! Thanks for your inputs. I actually have the tables you've stated. I just mentioned the two tables just so to make it simplier to explain. I guess, i didn't explain the scenario well. I am so confused with how to go about my project. I'm a novice and i'm not educated well on...

I have two tables: Table1 - show details of customer payment (full payment / with credit terms up to a maximum of six (6) months) ColID - (PK/Autonumber) Col1 Col2 Col3 Col4 Col5 Col6 Table2 - shows insurance agent's prorata commission (based on cleared payment). ComID - (PK/Autonumber)...

Hi Curtis! It works!!!! Thank you very much!!!!!!!!! Sheila

Hi ejstefl! What i meant by not working is that it doesn't give me notification. I intentionally added record (Plate Number in particular) which has duplicate. The code should have notified me that there's a duplicate record, right? Nothing appears on the screen and i was able to fill in all...

I used this code, but it's not working. Someone please help! On BeforeUpdate property of PlateNumber Private Sub PlateNumber_BeforeUpdate(Cancel As Integer) On Error GoTo ErrorHandler Dim msg As String Dim strCriteria As String Dim rst As DAO.Recordset Set rst =...

Help! I have 2 tables with the following fields: Table1 CustID - (Autonumber/PK) FirstName MiddleName LastName Address City ContactNumber Table2 CustID VehID - (Autonumber/PK) PlateNumber FrameNumber ProdNumber.... etc. Property of all fields in Table2 are set to Indexed(No Duplicates). I...