Recent content by sir_dan_mitchell

Val () Worked, Thank you very much!...again!!

Hi, I am using "+" and changing the Nz thing to +0 didnt make a difference it still added like 1040! How do I find where the code is. I have been into visual basic editor, but it only comes up with code for forms! Thanks

Hey again, Im trying to add up two simple queries. One is [extraoutgoings], the other [TotalVenueCosts]. They are both written as Nz(Sum([etc],0)) and come out correct in the sum calculations individually. Why then when I try to add say 10 and 40 together do I get 1040. I have tried...

Hey guys, I have a created a system wherby it calculates money going in and out of the business. Is it possible to add another table and then use this table for just entering extra costs to the business like stationary etc? Currently I have members, socials and Arrangements tables. The Extra...

Hi guys, Still havent managed to clear this problem up, so im guna place all the detail I can here, hopefully one of you will have an idea. Basically I have a 2 tables...Participants and Socials. I want to have Participants being added to their socials and basically I have worked everythign...

Im afraid not, I am calculating money totals, thats why ive had to use Nz( etc as if there are nulls I want it to display zero. All the queries displayed display a number (Sum), but I cant add them all up WHEN the [joined date] >= [venue Date] Anymore ideas? Dan

Hey can some1 help me with this problem. Its pretty simple probably, but we'll see anyway... I have 3 queries that I need to add up. One is adding non_members fees and one adding non members fees & if they became and member after the particular social date. Finally one with members fees. Now...

Hi, I have what i think to be quite a complicated problem, hopefully you can throw some light on it. Basically I have members and venues etc. In my form where I am adding members to each venue I look up the price. Prices vary between members and non-members. In the arrangements form (which...

i take it you mean deleting arrangments ID. I still want say one person to be placed on many different venues and one venue to have many different people on it. Just not the same person going to the same venue twice. Would this work if i JUST had primary keys of members and venues combined in...

hey, I have an arrangements table where its supposed to take all the arranged people and set them to a venue. I have Arrangements_ID as the primary key and then Member_ID and Venue_ID as foreign keys. And yet I can still put for example John Doe on the same venue twice! I think its a problem...

Very Simple Question hi guys, Really sorry to ask this, its been a while since ive used access. I have a very simple idea and i know its a simple answer, but i just cant remember what to do! I have 3 tables - members, arrangements, venues! I only want one member to select the same venue...

I have another problem aswell, in my forms. when moving between records the form doesnt refresh properly, the fields cross over from the previous record etc. is there a way to stop this?

correction, changes can be made through SQL server, but NOT in the table in access or in the form! Dan

hey guys, i have the strangest unexplained problem with my system! I have a system that has a large comments box! it is linked to SQL and the box stores any text. The system is working fine, apart from record number 16780 wont accept anything in the comments box! When you type anything in...

hello, I want to work out the length of service someone has from the 1st of april 2002 to the date they enter [Enter Date]. I have tried using the Days360 function, but it wont work! e.g. If they enter 01/05/03 then I want to know how many days they have worked for. i.e. 395 days. Can anyone...