Recent content by zazar

  1. Z

    Sum rows and update another table

    The tables have to be distinct and they have much more fields (almost 30 for the main table actualy). I just create and example with the 02 fields that where I need the calculations to be done. I already know my way when it comes to built query in design view but I'm not yet good to code in VBA...
  2. Z

    Sum rows and update another table

    Yes but the code behind those queries... I assume it must be something like for each... sum but I can't do it.
  3. Z

    Sum rows and update another table

    Hello, Thanks to y'all I had this great code yesterday Private Sub ImportXls_Click() Dim Filepath As String Dim strTable As String Dim MainTable As String Dim strSql as String Dim base As DAO.database Filepath = Me.fpath.Value MainTable = "Operation" strTable= "TemporJ"...
  4. Z

    Solved For each..... insert into

    Yes. I'm seeing how it works Thanks again.
  5. Z

    Solved For each..... insert into

    Hi, your code gives a error 3450 "Syntax error in query. Incomplete query clause" I know the post is solve but now I found that i actualy need to put a where clause... I try this : strSql = "INSERT INTO MainTable SELECT * FROM " & strTable WHERE ID_Stock IS NOT NULL but i'm getting error
  6. Z

    Solved For each..... insert into

    It works great... Thank you all guys...
  7. Z

    Solved For each..... insert into

    I had this wich work great : Private Sub ImportXls_Click() Dim Filepath As String Dim strTable As String Dim MainTable As String Dim strSql as String Dim base As DAO.database Filepath = Me.fpath.Value MainTable = "Operation" strTable= "TemporJ" DoCmd.TransferSpreadsheet acImport...
  8. Z

    Solved For each..... insert into

    Thanks for the link. I'll try
  9. Z

    Solved For each..... insert into

    hello, I have this simple code to import data from an excel file to a temporary table Private Sub ImportXls_Click() Dim Filepath As String Dim strTable As String Filepath = Me.fpath.Value strTable= "TemporJ" DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12...
  10. Z

    Solved upload file to blob field in mysql BE

    Hi guys, I got it worked. cheekybuddha I followed yours links and from one of those pages to another one, I found the code below : 'Function: BlobToFile - Extracts the data in a binary field to a disk file. 'Parameter: strFile - Full path and filename of the destination file. 'Parameter: Field...
  11. Z

    Solved upload file to blob field in mysql BE

    Yes i'm using linking table and thank you, hope I get through this issue with your code and links.
  12. Z

    Solved upload file to blob field in mysql BE

    Hi everyone, I create a simple database wich works great with few users. Recently we needed to move the back-end to MySql and just after this they aks me to allow users to upload file to the database. Moving the db to MySql weren't so difficult (i read a lot of thread). But now in the table...
  13. Z

    Hi everyone

    thank you to all of you
  14. Z

    Hi everyone

    🙋‍♂️ Hi, Just a newbie who want to learn about vba to improve his access app.
Top Bottom