Search results

  1. V

    Solved How can i upload or download a file from Google Drive In VBA ?

    I didn’t mention that i’m an expert or i did write this code , And sure i did my best trying to figure out what’s missing and i suspected it was a missing reference and it probably is . thanks for your help
  2. V

    Solved How can i upload or download a file from Google Drive In VBA ?

    Thanks for your reply , I searched my references and didn’t find any google and also the person who shared the example didn’t mention any special library . I don’t know what to do :(
  3. V

    Solved How can i upload or download a file from Google Drive In VBA ?

    Decompiled with vbs script then compiled again
  4. V

    Solved How can i upload or download a file from Google Drive In VBA ?

    I compiled it with no errors and saved as accdb try it , The both of them work fine
  5. V

    Solved How can i upload or download a file from Google Drive In VBA ?

    Thanks for reply , I can open it normally in 32-bit office . The error happens in form settings if you press Get token button like this image
  6. V

    Solved How can i upload or download a file from Google Drive In VBA ?

    Hello again , I got this example and got all the needed credentials but i get this error when it tries to connect to google account , can anyone help ? these are current references , Any missing ? Thanks guys
  7. V

    Solved How can i upload or download a file from Google Drive In VBA ?

    I think it’s not the complete guide , But i will take a look . Thanks Sorry Bro my bad o_O.
  8. V

    Solved How can i upload or download a file from Google Drive In VBA ?

    No , My point is to use API but i don’t know the exact steps nor the right code.
  9. V

    Solved How can i upload or download a file from Google Drive In VBA ?

    Hi guys , As the title i need to download and upload files directly to google drive with vba code without using synchronize folder as it will be used on different PCs . Thanks in advance
  10. V

    Solved how can i change color of certain characters in string ?

    I believe there is a way of every thing , Nothing is impossible
  11. V

    Solved how can i change color of certain characters in string ?

    Hello Guys , I have this table named TblCondition and a form that contains a textbox i need a way to colorize some characters in textbox which exists in the TblConditions . Example : Let’s say the form textbox contains this phrase "Hi my name is Amr 01002503...
  12. V

    Problem with query after adding WHERE Date Parameter

    Exactly what i want just Perfect , Thanks you (y)(y)
  13. V

    Problem with query after adding WHERE Date Parameter

    Hello again , Some may wonder why i didn’t just mention PlanSerial in TblSales and join the QryPlans with QrySales on PlanSerial ? my answer is the sales report come from another department and have so many records and it will be exhausting to add PlanSerial Manually . So i have new idea First...
  14. V

    Problem with query after adding WHERE Date Parameter

    Thanks for your reply , If you took a look on the join relation between QryPlans and QrySales you will find >> show all the records from QryPlans and only the records from QrySales where the joined fields are equal ("Code","Client") And Where the Zdate From QrySales Between ClcFromDate And...
  15. V

    Problem with query after adding WHERE Date Parameter

    Thanks for your reply , This Dsum is hypothetical just for making my point ignore the syntax entirely it is just for clarifying the idea .
  16. V

    Problem with query after adding WHERE Date Parameter

    Yes , that’s the point , I tried every thing and the problem here with the date parameter , I need to figure it out . Thanks
  17. V

    Problem with query after adding WHERE Date Parameter

    I made an example for the desired result , Thanks.
  18. V

    Problem with query after adding WHERE Date Parameter

    Hello Guys , I have a problem with Query Result in the attached database. Short Version : I need the query named Result to sum the QtyOut from QrySales Like the Following hypothetical Dsum QryResult.[QtySold] = Dsum("[QtyOut]","QrySalesPlans","='"&[ProductCode]&'" And [Client]='"&[Client]&'"...
Back
Top Bottom