Search results

  1. S

    Problem with Transform Data

    hi guys i got a problem with my access my client ask me to change my data to this form ( see attch ) :confused: :confused: anyone know how to make that ???:D :D
  2. S

    ASk : Query result for Latest Date

    ups , i always forget about its :D :D
  3. S

    ASk : Query result for Latest Date

    tq for your help , i got it but its look so messy :D :D
  4. S

    ASk : Query result for Latest Date

    hi , i try to make a query that can show me data from the lastest and max date from the table i have ( see attchment file ) I try using max but still the result is not what i am looking for Anybody can help me ???
  5. S

    how to lock folder

    hi guys , my friends ask me to make a folder base on invoice number so they can put some picture on it i already make it ( attached ):) but one more problem , they ask me to lock the folder so only related invoice number can be open :confused: So invoice number 001 can only open folder no...
  6. S

    flashdisk

    its works tq :D :D
  7. S

    flashdisk

    hi... is there anyone can help me with my flashdisk problem ?? usually i use this code to back up my client data to falsh disk Source = "D:\Data\BUBU\Data\DataI.mdb" Target = "g:\Data\DataI.mdb" FileCopy Source, Target the problem is sometime the flashdisk drive change from G to H or to I...
  8. S

    Question data transform

    can u give more detail about it ??? or may be some example still confuse about is
  9. S

    Question data transform

    there is about 50 or 60 columns :(
  10. S

    Question data transform

    this some data i got from my friend : and this is what the table my friend want to make
  11. S

    Question data transform

    hi guys anyone know how to transform this data to this ?? any idea how to make it ???
  12. S

    how to print 4.5"x6" report

    i using EPSON LX-300+II ESC/P , there is no custom size i already make new papersize in printer server properties , now how can i tell access to print that kind of size in my report ??
  13. S

    how to print 4.5"x6" report

    hi all anyone know how to tell access to print report with size 4.5" x 6" ?? in access paper size there is not such size
  14. S

    help plz

    1 more thing my data source is from SMS_in table how can i set them to read it from my source data ??
  15. S

    help plz

    SMS_IN is linked to my gateway database Temp is the table where i place data from SMS_in after i "extract" them so , there is no link between them After some one send SMS to my server ( eg. 1020.2010x10 ) , access wil read the sms and split them into 1020x10,2010x10 and insert this data into my...
  16. S

    help plz

    i try this code CurrentDb.Execute "INSERT INTO Temp (NumND,Price) VALUES ('" & strArray1(i) & "','" & strArray2(i) & "')" Its works ( Tab 05 ) but stil i got nothing in Date , CustID and Sender Field Do i miss something ??
  17. S

    help plz

    The sms_text in SMS_in is from my gateway SMS
  18. S

    Help Please

    u mean like Jan >> 31 days , Feb >> 29/28 days ?? if u mean like that u can use this First Day of The month : DateSerial(Year(Now), Month(Now), 1) Last Day of The Month : DateSerial(Year(Now), Month(Now) + 1, 0) So number of the day : Last Day - First Day +1
  19. S

    help plz

    its works perfectly...:D >>> Tab 03 but how can i put those results into my table ?? I have two table , one for SMS_in >>> Tab 01 another one for result >> Tab 02
  20. S

    help plz

    This is apart of Singapore Pools ( 4D ) Some of my friends are selling that kind of toto For ex. Someone want to buy some number 1001 for $ 10 , 2010 for $ 10 , 895 for $ 15, 893 for $ 15 , 5677 for $ 15.... Usually i told them to sent message to my SMS Gateway by using this format ...
Back
Top Bottom