Recent content by fgcity

i'm still testing it, i'm not sure if it's working correctly

tnx, i'm doing it now. Hope it works. It's getting a bit confusing now with allot of queries and updates. There are many restrictions that i have to have in mind for this :)

Yes, the question is what triggers the device to download. I can't say what are the purpose of the "spots" Yes, the file.TXT that i created earlyer with the format : 4 14 46 120 ghj35 IS what is actually posted on the internet (in a web link i have created) The IS File is : MyTXT.txt which...

the charges don't kick in. I recieve an SMS. That SMS contains the Text "34 KTL45" and the recieved time and the sender number I take that SMS Message and split it into "34" and "KTL45" i have a database of Spots from 0-60 so that "34" is the number of that spot. So the :KTL45: goes to...

The way i think of it is that ACCESS will make a file called "Stat.txt" Which will tell the status of the file (the main one) In that stat file there will be a Date and time so Access will update the date and time in that file only if the main text file has changed, So When i download that...

it's OK, i found a solution. Tnx for the reply though. I really appriciate it.

Yes i need to refresh every 5 seconds, Yes it runs 24/7, the device can identify the file size since it's running Linux. But the file size can still remain the same with data change since a letter could simply change so the file size would be the same. I;m getting the data into access with a...

Hi all. I have the following problem: I have 2 tables: On table A i have a text in a field "CVB45" On Table B i don't have that text in a field (i have some other text "FGH56") How can i automatically delete the Field from Table B if it doesn't exist in Table A ? The problem is that the...

ok, then please help out with the following if possible. i create a FileA from the fields i need in the format i need as described above. When my loop runs it recreates the file and rewrites it. Which is VERY good since that's the way i want it. But i need to do also the following: since my...

YES, Worked like a charm Tnx DCrake I appriciate the help ALLOT.

Tnx, Really appriciate it. I'll try it now.

yeah, that worked, i see what you mean here. To add all the data to a single field. But what if the data is more than 255 characters? one field can hold only that much does it not ? And then how do i save that single field to a txt file ?

Hi all. I have a Table with 3 fields. A: 54 B: XKR56 C: 13:03 (This is time) A: 32 B: YKT67 C: 14:12 (This is time) I need to generate a TXT file from this Table that would be in the following format: 54 XKR56 13 03 32 YKT67 14 12 ....... And so on How do i do that?

Tnx That really helped.

Hi everyone I have 2 Tables in the first one i have 2 fields A: 54 B: KKG45 On the second table i have fields with different data but the ID of each field is from 1 - 100 and each field with that ID has an empty field next to it so i need to update (in this case) Field with an ID "54"...