Search results

  1. K

    Excel Tick box help

    Hello can someone help me. I would like to set up an excel spread sheet which when loaded only displays the first sheet. i would then like to give a tick box to the person. For example Do you study maths (yes tick box) Do you study French (yes tick box) if yes is selected I would like it to...
  2. K

    Linking a form to a report

    Is there a way to print a report for only the form you are on. Let say Iv got a list of customers on a form and I have a query for all the customers.
  3. K

    hide 1 record

    I was wondering if there is a way to hide 1 record from a query say I have 3 user accounts and on a form I only want to display 2 of them form the query,so the other record is still present but cant be deleted by accident or viewed
  4. K

    Access levels

    Iv got a user table with an admin record and head teacher record with the highest access level I then have 2 teacher records with a lower access level The admin and headmaster have access to the whole system this includes assigning user name and passwords. However I don't want the head master...
  5. K

    Help explain code

    Can someone explain what the following code does.Thanks in advance Set dbUser = DBEngine.Workspaces(0).Databases(0) Set rsUser = dbUser.OpenRecordset("SELECT User.UserName FROM [User]WHERE (((User.UserName)='" + txtUserName + "'))")
  6. K

    Print VBA Code

    I need to print out my VBA code , I was wondering if there is an easier way to do it without cutting and pasting it onto Microsoft word.
  7. K

    Main form to sub form

    Hello, I got a main form with a save ,edit , view etc. I then have a sub form within it. The problem is that the buttons on the main form don't seem to apply to the sub form. For example my form is suppose to load in view mode and then if I want to make changes I click edit . However the...
  8. K

    Student Attendance

    I was wondering if someone could help me design an Access database to store students records and be used at classes to monitor attendance. I currently have 4 tables Class table classid Register table registerid ,studentid,classid student table studentid Attendance table registerid Iv...
Top Bottom