Recent content by and1_hotsauce

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

thanks for your reply Can I say this ( "ID = " & numMessageID  ) --> concatenates string ID with numMessageID --> i.e. ID = numMessageID

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?

Why was the stationmaster's son having a cake on a train seat? It was his berth-day.

if you replace smoking with these vaporisers, aren't you damaging the body the same way?

if he comes back he may tarnish his legacy like jordan of nba.

how does this work? Do you have to buy from ebooks from a particular website for it to work on the phone or can any .pdf document work?

thanks to both of your replies. I understand now.. I'll read up on functions and function calling regards, and1_hotsauce

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...