Search results

Thanks Mile-O-Phile and thank you Pat Hartman, played around with it a bit and it works wonderfully. You’re my hero and heroine for the week Tilda

Hi Folks Just a quick question, not sure if I’m making this more difficult than it is but here goes. Trying to create something to hold questionnaire data, 20 questions have the same sub-sections, for example How do you rate service A Excellent Yes No Good Yes No Moderate Yes No Poor Yes No...

Thanks guys I had set the properties in the query but it still keeps happening, trouble is not all the time! Tilda

Not sure if this is posted in the right area! but if anyone's got any suggestions for a small but very annoying Date format problem it would be appreciated. In the UK we use the dd/mm/yy format and in my tables the date fields are set to medium date (19-jun-94) and the machines set to GMT, but...

Thanks Colin I'll give it a go Tilda PS Everyone have a Super Christmas

Hi Colin Yes I can try that; the extra field is not a problem. Would I do the code in the form? Tilda

Hi Shay Thanks but unfortunately students can do different amounts of courses, but it does need to be controlled. Tilda

Hi Folks Small problem here if any one can help! I have two tables with a one to many relationship, does anyone know how to restrict the amount of records entered on the many side. For example if we have student details on the one side, some are only allowed to take five courses, my problem is...

Hi folks Strange problem, but may be very simple, each time I open a form (its got a sub form) for some reason it keeps saving the form, even when nothings changed. Can I do something to stop this happening, its really slowing things down Thanks in advance Tilda

Hi kmp Not sure if this is any help but I did something similar, I did a query and got my running total, I then saved this and added it to a union query. Hope this is some help. Tilda

Hi Pat Thank you but I’m still not sure if its what we need, this maybe a bit rambling so I apologise in advance, the trouble is that sometimes the address will be the patients and sometimes a relative of the patient, so I need the patients name in the patient details but also the name of the...

Hello Access World Silly problem this time hope you can help. Doing a small DB for a patient waiting list, have two tables with a one to many relationship. One table's got patient details the others got addresses, each patient can have more than one address, ie patients own address or family...

Just a quick thought have you checked the object libraries that are available on the computers you are having trouble with. This happened to me a couple of times?

Hi Everybody Just a quick question, I've seen an article in the Microsoft Product Support that talks about a lightweight object, and just don't understand what it means or find any infor about it. I would be very greatfull if someone could explain what it means or point me in the right...

Thanks Everybody Its starting to make sense at last, just got to try and put it all in to practice! Can I hit you with another question, I’ve got the navigation almost beat, just one last problem, when I filter the records on the form and then click a command button which opens another form and...

Thanks, great it works, except the middle line recordset.recordcount but if I comment it out it works great. Do you think you could tell me why? A happy tilda

Just started with Recordsets and Code so please be patient. My problem is form navigation, I’ve created (mega deal for me) a set of navigation buttons on a form whose record source is a query. The navigation buttons work fine, however the recordcount is the problem. When I open the form its...