Search results

Hi Craig, Wow all these questions :D I did get your PM...thanks, unfortunately I'm not able to download any chat software as I only have internet access here at work, this is the best and only forum I use ;) I'm leaving shortly so I'll respond to this tomorrow Rob

Hi Craig, Here's a revised example. Basically tbl_Massage will become your main table. The reason why StaffID & MemberID are displayed is that these are the link fields. What you would need to do is create a query like I've done to display all the relevant information. Then you create a form...

Hi Craig, Sorry for taking so long to come back to you. OK, tbl_Massage needs to act as a junction table between tbl_Staff and tbl_Members. If you think about the relationships logically you have the following: 1 staff can give many massages. 1 member can have many massages but onyl 1 staff...

Hi there Pat, Yeah I agree with what you say regarding storing current values. My only concern was that if Dave was using the 'Reducing Balance' method for calculating depreciation then this relies on the current book value, hence why I sugessted storing the current value at then end of a...

I totally agree Rich, I just hate having to account for it...it's such a blooming minefield :confused:

And the moral of the story is.....I HATE TAX! :mad: :D

In short yes...but to be honest I don't get too involved with dealing with the company tax return. I leave that to the auditors ;) The whole idea behind capital allowances is essentially its the IR telling you what you can deduct off taxable profits as depreciation. The mechanism for...

Rich, Are you talking about depreciation for corporation tax purposes or tax on company cars for private use? As far as I'm aware the IR is not really concerned about depreciation methods as when it comes to calculating taxable profits the depreciation is added back and then you use whats...

Hi Dave Having never used Access for essentially creating a fixed asset register (i.e. hold the details of all the assets, depreciation etc.), my guess is to follow on from Pat's suggestion and run an append query to your depreciation table at the end of each financial year. Looking at your...

Hi Craig, Can you post an example here so I can better understand your table structure and relationships?

No problem :D

Hi Dave, Hope you don't mind me jumping in here but being an accountant I thought I would explain the rules of depreciation.:) Basically depreciation is a way of spreading the cost of an asset over its useful life. The 2 most common methods of depreciation you can use are the straight line...

You can also set the default file format in XP. Tools--->Options---->Advanced Tab

Hi Craig Ok have a look at the relationships in the attached example which is in Access 2K. I've created 4 tables: tblVideo tblVideoDetails (Junction Table) tblRentals tblMembers tblVideo will contain the details of all the videos available, tblRentals contains all the rental history for...

Hi Craig, Ok I'm looking at the first question for you now. With regards to your last post, assuming in your 'Staff' table you have a primary key field e.g. staffID to uniquely identify that member of staff, then in your 'Massage' table you need to add another field called 'staffID'. Set its...

Hi there Without knowing too much about the structure of your tables, it can be done quite easily but I need to know a bit more information about your project. Will your project allow for more than one copy of the same video? Can a member rent more than one video at the same time?

The delta quadrant doesn't have rules...only The Borg! Oh well maybe I'll engage my cloaking device and speed off at warp 9 ;)

Hi dcx This is just a simple example but your quite right to point out that with a bit of extra coding the calculation can be automated without pressing the convert button. Also the calculation would need to test for a null in both fields otherwise it won't work. I just wanted to prove to...

I'll try that one again :o

Here's one I prepared earlier Take a look and see what you think Rob