Recent content by krellda

I have figured out the solution to this problem. I feel i should post it here to help the other person involved. The simplest way to do this is to create a Field with unique information in my system it is 'Case Number' i fill in the case number which currently is just 1, 2, 3 and so on but...

I need to post to move this back up the forum. Would it be a case of making primary keys and linking them, and then making some kind of function, or macro or whatever to open the other form to the form of the same primary key? if so what function can do this?

Right so that links the tables together and solves the problem?

fk? sorry i'm not good on the abbriviations. i'll set the primary keys up then, by doing that do i add something to the query telling it to only open the records that are linked via the PK's? if so how?

i haven't actually set a primary key in either but other than that yes you are right. The ONLY reason i haven't setup primary keys is cause i'm currently testing everything and am likely to re-build the system after this, what do you think would be a good choice for the primary key on each, it...

good point. i'll change it in my system then, i did think about this now that you mention it because its changing from january 1st here. and i just thought i don't mind changing the number, but what you said makes more sense. thanks. any help on my other issue of filtering the query results...

This is pretty much exactly what i need too, if anyone can help I, and i'm sure kmeulemans will really appreciate it. Thanks Dan

i'm not sure, i'm a bit nooby on all of this really. i'm making this database to help me with this job more than anything, the previous system was too messy, even if the last guy knew how to use it, excel is not the best way to store logs like this i'll try to explain the best i can The...

Oh! whats the difference, its still in the calculation. Surely it can't matter, can it? And any idea about the query, is there a way to display just the one set of results. i've set it up so that when the button is pressed i get Days hired Rate of hire Cost of hire Rate of insurance Admin cost...

Is there an easy way to show only one result, ie i fill the info in press the query button and want only the result from that form as opposed to every result from every form that i've ever made, because otherwise the list will start stacking up and it would defeat the object of trying to...

Done some thinking, i would need to make a button to open the hire rate page on a new record aswell for when i have new clients. Also i think the best thing to do would be to use the reg plates as a primary key, but to not add them into any form other than the Owned vehicles form. If you know of...

I need to continue this thread, i'm trying to do a very similar thing, i have two forms one for clients and one for car hire rates, when i open a page for a client i want to make a button to open the relavent hire rate page. I see i need to use primary keys, what would be the best thing to use...

sorry i was unclear about this, even tho the problem is now solved i think i should explain, the save button was for the form that i made for the cars we hire out, not for the calculation. when changing the dates on the form it wasn't updating the table unless i moved to the next form and back...

thanks thats working perfectly, just need a query to add the 15% it'd be best if i made a new field in the same query because we need both numbers for our records. so i'll do that. i tried noobishly to just write +15% but % causes a syntax error. I'm guessing i have to write is as a decimal...

also how can i add VAT of 15%? is there any way to display the nuber for only one form? i've added a save button as the form wasn't updating when i changed the numbers as far as the query was concerned.