Search results

sorry if i'm missing something here but how will i calculate the debt for each customer every time? Are you saying in the member table have a field for all the loan charges and a field for all the payments made? How would you add a new charge to the previous charge?

In my make loan form I am showing the charge due for that particular loan and the charge forany previous, unpaid loans (ie-debt) made by a member. I want to add the debt to the current loan fee and have that toal replace the value that was previously in my debt field. so say if member 3 has...

ahh, that makes more sense now. I can see why you were calling my method illogical :)

First of all, can I just say thanks for helping me out with my problem. I apologise if I seem to be dismissing your suggestions but its probably because I don't understand you properly as my grip of access is fairly basic at the moment, as you will have noticed. So anyway, are you suggesting...

sorry, what I meant to say was that you will have to enter a price for each item when you add it to the item list, I wasn't sure that this was a good idea because there are only 8 possible prices that an item can have, so I thought it would be easier to store the 8 prices just once in a table...

oh, is that what you meant. I had thought about that but then decided against it as it would mean having to enter a price twice for each item, even though there are only 8 possible prices. this is what I was thinking of: tblcharges: member_type charge_item_1 charge_item_2 charge_item_3...

i'm still not sure how i'd have the prices looked up from the table. How would i get it to look in a certain record based on what was selected in member type and item type?

Can you do that? I thought the only way of doing it would be the If function.

How do you use the code builder to get the reference? I've been right clicking the appropriate control and choosing properties>Other tab, and the "name" property as the field name. is that right?

How do you use the value written in a control of a form as input for a query? eg-if the user inputs 100 into an itemid text box on a form, i want to use 100 as input for a query. I thought it was: Forms![name of form]![name of control on form] but Access automatically puts brackets around...

thanks, i've had a look at the IIf function, would I have to use 8 seperate IIf statements to show what I want to? I'm trying to use the function as a control source of a text box in a form but i'm having trouble referencing some of the fields on the sub form, basically I want to pull the...

Maybe im approaching this all wrong but im more used to using excel. in that i would put something like IF conditions=whatever then show cell B20, else show cell B10. Is there a similar method of referencing fields in access, something like [table name], [record number], [field].

Wasn't quite sure where to post this. i've got 2 types of members in my system-member A and member B for the sake of simplicity, there is also 4 types of items that these members can get, lets call them item 1-->4, each item has a different price depending on the item iteself and what member...

I'm trying to work out the difference between 2 dates stored in a table. I want to work out how many days exist between [date1] and [date2] and update the value in another field of the same table. I can do this using a query but that way (correct me if im wrong) I can't simply show the value in...

thanks, i'd already seen that thread so i'm now thinking of having unique ref's for each item-eg-if item 2 has 3 copies it will have a id of 002-a, 002-b, 002-c...i'm not sure exactly how to implement this without duplicating data though. Also, is it possible to add a prefix to the item id...

I'm setting up a database to keep track of book/video loans. Trouble is that some items have more than 1 copy and it'd be a waste of time and space to enter the data for each item 2-5 times. I was thinking of having a drop down menu labelled "copies" for each item, so the user selects how many...