Search results

cheers you guys thanks a lot for the help, i'm just trying to locate the code you put in so and where so I can do the same again! I really appreciate it :)

I'm afraid the coding didn't work! Thank you for all your time, which I do really appreciate. I can't believe i've spent a whole day trying to figure this out mind you and have gained zero progress...Battenburg, with all honesty, everytime I checked that link it worked (a person downloaded it...

thats what i've just done! (look above)

Take a look at the form ask and the table entitled asques http://www.geocities.com/davidg031984/DatabaseDG.mdb i've edited it sufficiently

lol okay, right there is no query. Right lets try this again - I actually think I know why it's not working too, I just don't know how to get around it. I have a form that has a number of scores. Some of these scores are based on other numbers in the form An example would be Score X = Score...

okay, i have found the event heading (under properties) but still before and after event rather than current. Sorry about being really slow on this!

there's only before and after update under event and when that it, in said invalid syntax? :(

the initial numbers do not change in the table but because it is a complex questionnaire, i dont want to be spending a long period of time working out different subsections for 120+ patients. Plus it won't always be me inputting the data and in circumstances, people inputting will not be privy...

I understand that any data that is inputted into a form is always transferred back to the table in question. In the form I created, I had 4 subheading scores added together to form another subheading named function =([1]+[2]+[3]+[4])/4 was the formula that I put into the control source. The...

I can't really post it, medical confidentiality. Although I can clarify something for you and that is that the control source for the Age is the DOB score on the Form. I just find it odd that everything updates from the form back to the tables from whence they came, yet anything that have a...

It actually is so it shouldn't be a problem I thought yet it still isn't updating, on the same token, for other calculations such as the sum ones, the forms do the maths and present it but back on the tables, its blank.

I appreciate your help Rickster, however, I may have actually misguided you partly. Basically, I created a table for a questionnaire regarding hip pain, and then I transformed it into a Form. Once I did that, I then used the following formula to convert the Date of Birth to Current Age...

Please, I really need your help here! Someone has got to know Plus, I have an additional query now and that is: If you insert of formula into a form, such as one to determine age, how do you transfer that back to the tables because at the moment, while all the rest of the numbers are going...

Please someone help! This is very urgent! I am designing a database for a clinic basically, One Form is a Demographic Form, which was been designed. Each person was given an identifier code. However, they all did 3 questionnaires. Each one of them has their ID code on it. Is it possible...

I can't actually give you access to the database cos its got private information on but I can try explaining again: I have people come in and do questionnaires. Each person is given an ID code which is related to them and each form they do has the ID code on it and the ID code is the same...

I was wondering if you guys knew of a way by which highlighting a group of ID numbers in Access, could generate a letter for someone, eg, say, i had 15 people that had yet been posted a reminder, is there a way in which I can set a macro up or something and using autotext that I can produce...

Greetings, I was wondering if you could advice. I have 5 or 6 questionnaires and each of these is linked together by a person Identifier number. How can I do it so that all the questionnaires recognise that these tables are all linked by the same number. Secondly, if I wanted to say, do a...