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
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...
hI
thanks for your reply.
Are the double quotes and single quotes in the correct place? I have colour coded for readability
CourseName and Grade are both text(string). txtPassword is also text(string).
"SELECT tblCourseInfo.CourseName, tblResults.Results, tblResults.Grade
FROM...
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...
Hi,
Im in exactly the same boat as you. I've looked at VBA for dummies which is ok but it only lists some code and it doesn't take you through practical examples that you can try yourself. But it has some important sytanx so I recommend you BORROW it from the library
Also have a look at this...
Yes I'm starting to understand now. Just one more step!
at this point Password = ' " & txtPassword & " '
What are the two inner double quotes for? Are they to show vbs that txtPassword is a string?
Hi
Thanks for your reply. I tried out the sql statement you had wrote and it did ineed work. But there are some steps I don't understand.
I understand that ILoveJane has to be in quotes because it is a string. But at this point why are you using concatenators? The first & links the string but...
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?
hi
thanks for your reply!
But I'm not quite sure how strsymbol is storing the text message. For eg. if I send 'BB', I can't see in the code where strSymbol=BB for it to be used in the sql statement
The variable strSymbol is only used twice
Once as an argument for the Function QueryStock...