Search results

  1. M

    Query to show grade,GPA and comment at once.

    Hallo! i have the following database with: -tblGrades-contains: gradeID,Grade,MaxGrade,MinGrade,GPA and comment -tblStudents_marks:StudentId,name and marks in various subjects -qryResults: calculates totals and average in all subjects -qryGrades: Grades the students as per marks and also the...
  2. M

    Edit conditional statements in vba via form.

    this is what i want to achieve. I have a table of marks of student, a query that calculates totals and a form that displays results. on the query, i have an if statement. comment:IIf([Marks]>=80,"good",IIf([Marks]>=50,"fair",IIf([Marks]>=40,"Work harder"))) So i want to be able to make the...
  3. M

    Question Cant rank according to filter in query

    hallo! would really appreciate your help here, so i have created a table called "tblStudents" with studentId,Name and marks as the fields in it. i have also created a query to rank the students according to there marks obtained. The query works fine with a Ranked output 1 2 3 4 5....etc BUT...
  4. M

    Question Can you intergrate Finger print reading in Access Apps?

    Building a voters registration/voting system, needed to know if i could use a fingerprint device to capture data.:rolleyes::confused:
  5. M

    Question Which SQL Server version to choose when upsizing Ms-Access 2010 apps.

    I have the following questions regarding this topic: 1.I want to upsize my Ms-Access app to SQL server back-end and then PACKGE AND DISTRIBUTE it. So after i upsize my app, how will i distribute it in one package and or "server and client" the issue is how will i package the back-end which is...
  6. M

    Question Custom table based on users choice of fields.

    I want to create a form where by the user can select the fields he requires and the table is created. example: i have a table of subjects like maths,english,french,chemistry etc, the user can choose what subjects are available in that particular school and therefore a table is created based on...
  7. M

    Question add and delete records in multiple tables

    I have 2 tables, Students information and Accounts information. the two are related with the field "Admission number" which is common in both tables, which also acts as the primary key in the 2 tables, i have Enforced ref integrity,and also enabled cascade deletes and updates. the two tables...
  8. M

    Help Fix bugs and improve a complete ms access app.

    hallo, I have succeeded in creating a complete standalone ms access app, of-course using the run-time Access 2010. I am looking for professionals who i know are all over this forum to help me fix bugs and improve the app. any help will be highly appreciated. thank-you very much guys.
Back
Top Bottom