Recent content by supersezzie

Hi everyone, I'm creating a database and wanted some advice on the best way to set up my table. It is for a service with clients where we need to carry out a review every 6 months, so I need to create a way of entering a date every time a review is completed, then ideally a field that...

Hi, thanks for this. Yes, the data for the time values are just added on the form manually as the day goes on. They're not stored anywhere else or calculated from any more detailed info. Thanks for your help - I will have a play with the query and date fields and see what I can come up with!

Hi, thanks for your help. I've attached a picture of the two tables to give you an idea. I need to use all the fields from the Time Monitor table except the ID. I just need to use the date of contact and length of session from the Student Appt Log table, and possibly the count of the number of...

Hi, please forgive my newbieness! I'm learning fast and you guys are brilliant :) I have two tables and want to compile the data onto one query - can you help? One table is a time monitor table with one record per date, with date as the primary key. It contains a number of fields where I enter...

Thank you! I don't know if this is a bad move or not but I've resolved it by creating a tabbed form with a subform on each tab! I'm a complete newbie so it was very good to know, thanks :)

Hi, It's a long record source! Here it is: SELECT [Student Details].*, [Disability Information].StudentID AS [StudentID_Disability Information], [Disability Information].[Issues / Conditions], [Disability Information].Formal_Diagnoses, [Disability Information].Medical_Evidence, [Disability...

Hey, just wondering if you guys ever resolved this as I'm in the same boat?! Hope you did in the end! :)

Hi, Can anyone help with this? I have read all over the internet but am still drawing a blank! My form was working fine but when I added an extra tab it started showing as completely blank in design view. When I deleted the tab I had added I still was left with the same problem! Please help...

Thanks for your help, sorted now! :)

Hi, I'm new here, I hope you guys can help! I'm just a beginner in learning access and a m having what looks like an easy fix problem. I'm creating a tabbed form in Access 2007, and in the first 3 tabs, when I dragged the field controls onto the form, they stretched to the width of the form...