Search results

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

In general here is what i want to do: I have an SMS software that communicates with Access and enters Incoming messages into "Messagesin" table and outgoing messages are placed in the "messagesout", as soo as they are entered then the SMS message is sent. What i need is this: When a message...

Tnx guys. this really helped. I think i'll go with the "SQL" option. :) select trim(left(myfield,instr(" "))) as TheNumber, trim(right(myfield,len(myfield) - instr(" "))) as TheRestOfIt from mytableorquery;

Hi all. I have a question about something i'm doing. i have a table with a text field that contains "34 XKY45" I need to somehow automatically Seperate "34" and "XKY45" and place the text "XKY45" in a field with an ID "34" on a different table. How can i do that ? Please help out.

yeah,tnx that's how i did it. Once again tnx for the help

Never mind the software. I have ended up with a simple solution but i need some help. I basically need to Auto Run a Query every 1 or 2 seconds, how do i do that? If i create a blank form what would the code be for the timer to auto run the query every 1 or 2 seconds?