Recent content by Yoplumpy

Thanks very much David - your help is appreciated. Paul

Hi All I have a table holding the data I need and this has quite a few yes/no check boxes. I am planning on connecting this as a datasource in Excel - with a pivot table to summarise the data. The table shows 0 for false/no and -1 for true/yes. When connected to Excel they show as FALSE/TRUE...

Cheers Trevor I will give that a go! P

Hi All I would really appreciate any help you can give - I am not very good with the modules side of things in Access so laymans terms would be useful :) I have multiple make table queries that are being linked to excel. The only problem is that the macro that intiates these queries has 3...

Hi All I have to export various files which are queries to a single excel workbook. I am using the code below (which I haven't been able to test - which is why I am here!) Public Function ExportTblToExcel() strFullPath = "C:\Users\Paul\Documents\FFP\Data Exports\QuarterlyDataExports.xlsx"...

Cheers - I did see that when I was pasting it in. Gone now.

Hi Yes I am guessing a single table would make sense but there will also be reports that are excluding certain types of marks so I wasn't sure how to keep them separate. I attach a screenshot - It's not huge as the size limit is only 100kb. Cheers Paul

Right I will try :o It a database that captures core details of young people and then they attend certain pre-education/education/mentoring/casework sessions which can be anything from 3 to 24 sessions for each but it depends. I have a tabbed entry form with the main core fields coming...

hi Thanks for your advice. I had actually tried that before and was using a Union query to combine the data but had problems when I started using a form to set From and To parameters to report. This seemed to work so I stuck with it! It's not anticipated that there will be a large volume of...

Hi The MakeTable is combining attendance from 3 other tables - they are all holding the same information (but for differing types of attendance) so Mark, Date, Date Month, Cohort etc. It just makes one table of attendance by their ID. Cheers Paul

Hi all I have a 2007 database that on startup needs to replace a table of student attendance as this makes is easier to report on. I am not the best at VBA! I can easily set up an autoexec macro to do this but get the warnings messages. I tried to get around it by converting the Macro to a...

Hi All - hope you can help with this one. I have my db with various lookups set up which is working fine. It's just that in the future someone may want to tweak an existing value. I am using Access 2007. I have found that it I edit the lookup data it immediately shows in all the records it's...

Hi Any help on this would be greatly appreciated. I have a database that is a main core table and linked to 4 different types of attendance (don't ask!). The user will enter the date for the attendance type and mark it as "1" for present etc. All have the same field names - including...

Thanks very much for your help. Paul

They are classes and they would attend a few times a week usually. thinking about the potential for problems in the future what I may do is just create a separate attendance table that is viewed as a data sheet and then can just add the dates through the subform. I can then report on the...