Search results

Morning everyone I have a basic (pun intended?) question. I have a form ("Form1") which is not bound to any underlying table. On the form are 5 Option buttons ("Option1"..."Option 5"). I've been trying to figure out the code to write a new record to an existing table ("Table1") depending on...

Totally (no pun intended!). My structure was all flat, arnelgp really worked some magic on it and then went above and beyond in the 2nd database he posted so again, thanks a lot guys....really appreciate the effort and time you've put in. Cheers DDJ

Hi arnelgp I came on again to thank you for you help. Roadtest was very successful so really appreciate your work on this.....then lo and behold you upload an even better and more user friendly version. Will play with it tomorrow but, again, thanks very much....you're a star DDJ

Hi arnelgp That looks great, exactly what I need. I'll spend some more time on it today to fully roadtest it. Really appreciate your help (and all the other guys) You think you know ACCESS until you come on a forum like this and realise how little you know!! :) DDJ

Thanks arnelgp....downloading it now and will feed back. DDJ

Actually, during my recent bathroom break (it's where I do my best thinking!), I was wondering an easier way might be to add another column to my Subjects Table "Remaining Hours" (which would initially be set to the same value as "Total Hours") and each time the record in the form frmClassroom...

Hi Minty Apologies for the delay but I Hi Minty Thanks for all your help so far. I've uploaded a copy of my db as requested. Basically the tutor opens the form frmClassroom timetable and uses this to generate the timetable for a specific week using combo boxes to pick the week no. and...

Thanks Minty, I'm going to have a more in-depth look at what you suggest. Appreciate your help and input so far. Cheers DDJ

Thanks for all the replies guys. I'm not new to ACCESS but my coding is limited really to modifying existing snippets I find online. Maybe I could explain it better using the attached picture. Is there a query or piece of code I could run to calculate the number of times X and Y appear in my...

Morning ladies and gents. This is my first post so hopefully it's in the right area. I have a table with 31 columns where each row is a weekly class schedule (MonPeriod 1 to Friday Period 6). Basically the first column is the week number and then the remaining 30 columns with the subject for...