Search results

Do you know any other programming languages? I would do that in Java. Ant...

I think thats a bit vague! Can you describe it a bit better?

thanks, very handy indeed!

Hello, thanks for all your help up to now. How do i get a value from a subform to use in the main form? Heres what im working on: I want access to look at the value in a combobox in the subform, see what it is then if its "blahblah" then do this, if its "blahblah2", do that, etc. So how do i...

oh, ive already sorted it out, ive used "Form.Recordset.RecordCount" it works fine! now im trying to make a case statement accept "or" but it wont!

ok, Ive done the before update one. How do i make the before update event count how many records there are in the subform? Ant...

Ha ha, ive done it but it wont let me add a rcord now when there are no records present!

Thank you for your quick reply (and solutions), the button solution sounds good. Ill have a go. Thanks, Ant...

Hello everyone. Here is a picture of one of my forms. The idea is that, if the family tariff is selected the people subform will allow many records, else i want it to allow just one record. Is there some VB code i can use which will allow one record and wont let anymore be created if...

By the way, thanks for your support up to now, ive made the database much better (and improved my knowledge and understanding) after listening to your suggestions. Thanks.

Hello, im making a database for a charity as part of my work experience and id just like someone to check over it for me. If you see any issues please let me know. Im already aware of changing text PK's to autonumber, this is a prototype so im not going to change the PK's at the min. Any ideas...

Hello, This forum is a great idea by the way, its so helpful having a an array of experts who are willing to help! Its really cool, thanks for the forum. Anyway, here is my ER-D: OK, My problem is specifically in this area of the ER-D: Getting down to the actual problem: Notice that...

done! It was to do with indexing again!

Thanks for your quick responses. Thats not the problem, the problem with that was that for some reason Stakeholder ID was indexed with no duplicates!?!? Dunno why? I must of accidentally ticked it. Anyway ive just unticked it, enforced fererencial integrity and booking works 100%. Excellent...

Hello, Firstly, heres my ER-D thing: The problem, is with the relationship between: stakeholders and bookings. stakeholders and stakeholders letters. when i join stakeholders and bookings it says one to one, i want a stakeholder to have many bookings not just one, however, i havent tested...

Ive just appended the ER-D, this is the latest version: Ant...

Hello, Im creating a database for a charity. Im in work based learning at the minute as part of my degree course. Basically, I have my ER-D which im going to use in a few days to produce the database. Please have a look at this and criticise it! Here it is: Well, basically, i want to know...

Thanks, Ive had a look and theres a bug in it! Yes, that is a good idea though. I might give it a go. Thanks, Ant...

ok, how do i do that, ive never done it before, ive only used reports. ps. Whats it like in Kent now after the earthquake? Ant...

Thanks very much for your reply... Split the stakeholders table into two, One called letters and one called accounts. Ok, i understand what you mean. BUT... There are only going to be four letters for each member - ever! So i dont need space for loads more. If they dont pay the subscription...