Search results

Hi there, I have a database with several tables which include the following tables Main Table is: tblClient Fields: ClientID (PK) - Autonumber ClientRef - text GenClientRef - text Name, Address etc. Other Related Tables: tblPI fields:PIID (PK) - Autonumber ClientRef - text GenClientRef - text...

Hi, I'm trying to run a report based on the current record. Having looked at Allen Browne's website (wow that guy knows his stuff!), I've created the following: [CODE] Private Sub cmdCreateFileCheck_Click() Dim strWhere As String If Me.Dirty Then 'Save any edits...

Hi, Can you help? I have the following fields in an A2010 form PaymentMethod Total InstalmentAmounts OurFee InstalmentAmounts field is populated based on the results of PaymentMethod which is a combo box Here is the current code Select Case Me.Payment_Method.Value...

Hi, I have a form (frmFeeIncome) based on a table (tblFeeIncome) On the form I have three fields which are FeesMonth, FeesYear, FeesUK (currency), FeesElsewhere (currency) and FeesTotal (currency). Each new record is entered like this January 2015 25000 25000 What I need is for...

Hi, I have beginner knowledge of Access but have been tasked with creating a new database by combining four existing databases but making them better. Our area of business is insurance. Currently have the following tables which will become more tbl_clients tbl_policies tbl_claims...

Hi there :) My name is Gillian and I'm from sunny (sometimes) rainy (mostly) Devon in England, UK. I work in Insurance and built a db with A2003 about 8 years ago with the help of Access for Dummies and a lot of work! I was pretty chuffed with it and my colleagues were impressed too...