help with access project(ADP)

  • Thread starter Thread starter neolempires2
  • Start date Start date
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..
 
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
 
Back
Top