Search results

  1. A

    students results table

    Hi I have created a students results table below. Can I normalise the Reults table even further? Is this necessary? http://i52.tinypic.com/amqj4i.png http://i53.tinypic.com/2qmi4qc.png
  2. A

    Creating functions in VBA

    Hi, I am having trouble understanding how the below function (processmessage) works. The program (activexperts) automatically stores a received sms into a database called 'Message' database. The code below retrieves this message FROM message database But how can a variable be used without...
  3. A

    complex sql statement - 3 tables

    Hi, I have 3 tables(pictured below). When a student sends an sms I need to check the studentID and password and respond with his/her results. So far, I have created an sql statement which checks the studentID and passwords and sends a reply with his first name and last name from tblStudentInfo...
  4. A

    sms student results

    Hi, I would like to create an sql statement where it verifies a number and password before proceeding to the next statement. Why is there a single and double apostrphpe enclosing the statement &intStdNO&. And also what do the two ands mean? I've tried Is this correct?
  5. A

    having trouble with sql statements

    hi I have a table with two fields like below. The sender sends an sms with an ID eg. AA and gets a reply from the server ($1). However, I'm having trouble trying to decode the sql statement below ID................. VALUE AA...................$1 BB...................$3.59...
  6. A

    new member

    Hi, I;m new to these forums. I am doing a small project called: sms results checking system, where a student can send his student number and password and the server will reply a msg back with his/her results, I am very new to both access and vba but I've struggled through and am almost done...
Top Bottom