help with access project(ADP)

N

neolempires2

hello..
i have a complex situation here,
i'm very new in programming
i try to make an application in Access project, some thing like book
order with sms messages
when sms incoming, it will insert "phone number" & "book order" to
table incoming msg.(i'm already do this apllication)

is any VBA or procedure in acces project to :
cek the "phone number" from table "members"
if there is no record , then update table"outgoing" with "you not
register" in field "status"


another condition

if there is any record in table "members" continue to cek the price of
the book in "book price table",and than calculate price and member
money in table "members",if member money-price="minus" than update
"outgoing" table with "you have not enough money"

flowchart:
msg incoming==> insert into table "incoming"==> cek the condition
register or not and cek the price and member money in table
"member"==>insert the condition into table "outgoing".

what is the fast way to do this procedure, because of incoming message
about 10 msg per minutes,

thx before..
 
T

Tom Wickerath MDB

you want SMS messages to get into a table-- ok how are you going to do that?

you just need to give us more info
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top