Recent content by tom4038

ok thanks for everyones input, but sorry if im asking the question all over again but... whats going to be the quickest way to get this out on the web within subscribing to an addtional service? I just want to display the results of a few queries! nothin fancy! i have a adobe dreamweaver cs3...

out of interest what kind of costs are associated with the solutions above, also which is the quickest route with the least experiance?

ive got an ms access application i want on the web, whats the quickest way to do it. been googling and found this http://creator.zoho.com/ has anyone used it or something similar. havent got a budget in mind so 2 users for free seemed a good deal! i just want a few quieries and the ability...

arr! smslog is a linked table to another access db, will modifying it cause a problem? offline say zz also what is meaning of pk?? i know it could be anything but why pk?

there is abit of info held within the unitDetails (previously unit status) ie. address contact information etc... there were 5 status's.... alarm, where table smslog field data contains 'ff' reset, where table smslog field data contains 'bf' inspect, where table smslog field data containing...

I have another question! I now want to design another update query... similar to the one above but updating any unitstatus to 'outstanding' when it exceeds 7 days since data contained "ff" if you know what i mean? Is it just a case of putting in a criteria of 7 days??

this is great.... problem solved, it was only returning one result per phone number. It's been good fun sorting this out and will SLOWLY! build the database over the next few weeks. Next problem is automating this update query, and not being asked to give persimssion to update the tables...

i have tried this if i run the query from design mode to view i get this... The query gives two results but , which is correct based on the data porovided but it does not update the field to "failed"... if i run the query from the 'task bar' on the left hand side i get this... error...

Hi, thanks for that, where would this code go? before, after or in another query? thanks

I easy one i guess but im still learning: SELECT smslog.* FROM smslog INNER JOIN qryMaxDates ON (smslog.SentTimeStamp = qryMaxDates.MaxDate) AND (smslog.PhoneNumber = qryMaxDates.PhoneNumber) WHERE (((smslog.Data) Like "*io:BF*" Or (smslog.Data) Like "*FE*" Or (smslog.Data) Like "*7f*"))...

all sorted, thanks getting use to this access stuff!

hi im abit new to this access, wonder if anyone can point me in the right direction. I have a table containing the following, below is a sample of the data: PhoneNumber 447903212345 Data id:0001,IO:FE,A0:02D,T0:000 000,A1:02D,T1:000 000,A2:02C,T2:000 000,A3:02C,T3:000...