Search results

Hi jdraw, Thanks for posting and I'll certainly read through that information you provided. For background, I work in an insurance brokerage which has recently merged with another company and I have been tasked with merging four databases into one. With this new database, it is centred around...

Ok many thanks for that. I've changed the tables to show ClientID in each of the sub (related) tables. Just one thing, If a new record is created in the Mainform, how does this filter the results in the Subform to just show that record's subdata? What I want to happen is that when a new...

Hi there and thanks for replying. I probably have! Can I ask, would I need ClientID in each subform? And link these in the relationship manager? Thanks!

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 there, Yes, ClientRef is on the subform as well as the mainform. Main form = frmClients Sub form = frmCombinedProducts Both of these have ClientRef as it's a one to many relationship. Private Sub cmdCreateFileCheck_Click() Dim strWhere As String If Me.Dirty Then 'Save any...

Many thanks for replying. I tried as you suggested, but the report is still blank? The report is based on a query but I was looking to not have to put a parameter in to run the report. Would this have something to do with the code not running? Also, the cmdbutton clicked to create the...

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

Argh sorry, total brain freeze! You're absolutely correct, it needed an extra pair of eyes. thanks :)

Hi thanks for replying. Sorry I should have explained, i also need to take into account that OurFee may already be filled. So in the explaination below Total 500.00 which was been calculated by adding up other fields including OurFee lets say ourfee is 50.00 but once the PaymentMethod is...

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 there, Feel a bit shameful by the phrase 'because it has too' so sorry, please accept my apologies. The FeeIncomeTotal (as all the others fields in the database) will be used in a mail merge ms word document to populate a questionnaire/proposal form so I need to store the value somewhere so...

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 The existing four databases only have one table in each. There is no rationalisation. I would say I'm a beginner only because I don't do this every day but I did build two of the databases and am ok with running queries, reports and designing forms. My real issue is getting all the data to...

This is great thank you. So assuming I set it up like you say, the relevant client - policy or policies and claim or claims data will only appear for that particular client under ClientID? Thanks

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