Search results

  1. Y

    Formatting True/False for export to Pivot

    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...
  2. Y

    Linking Macros/Modules to a form Control (?)

    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...
  3. Y

    Module Exporting Mutliple Queries

    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"...
  4. Y

    Make Table on Start up - Autoexec?

    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...
  5. Y

    Look Up Table Data - retaining the previous value in the core table

    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...
  6. Y

    Union Query - Date Parameters

    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...
  7. Y

    Converting attendance data for reporting

    Hi All I think I am out of my depth here - but desperately need to get reports created out of a database that captures dates and attendance marks. Currently the table was 12 weeks so there is: ID 12WeekProgramme.Week 1 Date 12WeekProgramme.Week 1 Attendance 12WeekProgramme.Week 2 Date...
  8. Y

    Updating Fields with Wk Comm Date from a Start Date

    Hi All I am in no way a programmer so please bear with me! Basically I have a field called "12 Week Programme Start". After this there are 12 Date Field (1 for each week) - What I would find really useful is if you enter the "12 Week Programme Start" and it would work out the Week 1 date (+...
Back
Top Bottom