Recent content by mike60smart

  1. mike60smart

    Report in Label format

    Hi The attached is one way of doing this. I created a query for each Section ie Sec-1, Sec-2 and Sec-3 I then created a Report for each Section Then the Final Report has all 3 sections Look at the rptAllSections and see if this suits. Please also study the relationship diagram - I changed how...
  2. mike60smart

    Solved Cumulative sum of form text boxes

    Which Field are you trying to get the Total for?
  3. mike60smart

    Please can someone help?

    Hi Sam This is now fixed. I changed the Status Field in the table "Machines" from a Lookup Field
  4. mike60smart

    I want to see the name not the Id

    I would recommend that you get rid of the MultiValue Field as suggested by others. You need to sort it out now as you are sure to encounter similar problems in the future.
  5. mike60smart

    Input Form to display sessions on one page

    Hi Your Form DefrmStaffLesson is constructed very wrong The Main Form is based on a qryStaffLessonDays which consists of 5 tables Going by your Relationship Diagram this Form should allow you to select a Day of the Week - I would suggest that this would be based on the tblWeekday You then...
  6. mike60smart

    Input Form to display sessions on one page

    Hi Which is the Form that you have created for the above process?
  7. mike60smart

    Input Form to display sessions on one page

    I realise this but as I said previously this is just a suggestion which you can either manage or ignore.
  8. mike60smart

    Input Form to display sessions on one page

    Hi In ate attached the List on the Left are all of the fields for the Student Table. All Other fields in the List on the Right should be in related tables.
  9. mike60smart

    Input Form to display sessions on one page

    I would also suggest that both the Students & Staff tables are not yet normalised.
  10. mike60smart

    Creating a form with a list

    Can you upload your database?
  11. mike60smart

    Copy table and subtable into other table and subtable

    Hi It would be a lot easier if you had a field for Status ( Quote or Order) and then enter a Date for each of the following as appropriate. QuoteDate OrderDate
  12. mike60smart

    Solved Mixed Layout

    Can you upload a zipped copy of the database?
  13. mike60smart

    Solved Mixed Layout

    Look at Crosstab Queries
  14. mike60smart

    Bug? Access Form design - Copy and paste textbox controls not working

    Hi Minty It worked just fine in both for me.
  15. mike60smart

    Forms like Table

    Hi June Here is the Form
Top Bottom