Recent content by dianaha

  1. D

    DoCmd.TransferSpreadsheet for exporting table from another Access database than the current one

    I have already tried with the code of arnelgp but I needed to change "a little" but that causes actually the bug: "Set dbX = wrk.OpenDatabase(path_to_the_data_base)" instead of "Set dbX = Currentdb"
  2. D

    DoCmd.TransferSpreadsheet for exporting table from another Access database than the current one

    Because if the table is not in the CurrenDb it does not work. (the "DoCmd.TransferSpreadsheet")
  3. D

    DoCmd.TransferSpreadsheet for exporting table from another Access database than the current one

    I find a solution, not the best, but at least it works: Import the table in the current Access database (which should contain only the forms..), export with the "DoCmd.TransferSpreadsheet" statement, then clean up: delete the query and the table. If someone has a better solution in order to...
  4. D

    DoCmd.TransferSpreadsheet for exporting table from another Access database than the current one

    *precision: the string called data_base_name is a global variable which is set at the opening of the form, that is why I don't declare it in the sub.
  5. D

    DoCmd.TransferSpreadsheet for exporting table from another Access database than the current one

    Hi everyone, I am struggling with a new problem, when I want to export a Table into excel file. Before it worked well as I have used "CurrentDb" (forms and tables in the same Access doucment). but when I want to export a table from another Access DB (where there are only the table) by using...
  6. D

    Solved Detect through ACCESS if an Excel file is already opened

    I have found my problem, It was in the error handling setting in VBA options... the option of "stop to all errors" was choosen instead of "stop only on non managed errors".
  7. D

    Solved Detect through ACCESS if an Excel file is already opened

    Okay thanks... Are there any settings concerning the errors messages?
  8. D

    Solved Detect through ACCESS if an Excel file is already opened

    Okay thanks! So it is what I have planed, it will lead to an error if the document is already opened. How to skip the skip the error but treat the error depending on the type of error? I use the "On error " statement, but I have still the windows which appears with the error n°70, which I...
  9. D

    Solved Detect through ACCESS if an Excel file is already opened

    Hi, Yes I have already a very similar code (with Msgbox) where I call this function, but the error occures in the function IsOpenedFile(). My problem is actually to avoid the message error (I still do not understand why the message appears even if I use the "On Error Resume Next Statement) and...
  10. D

    Solved Detect through ACCESS if an Excel file is already opened

    I have tried different ways to open/modify/save an Excel file which is already opened. With the Workbook.Open() method, it opens it. But after modification, when I want to save and close it, of course it ask to SAVE AS the document.. I don't want to create a new Excel file. I would like to...
  11. D

    Table remains unlock

    I will see documentation about debug.print, but actually I always test my Private Subs by pressing on F5 key when I have my opended Form. I have managed to make the dynamic search, here the solution (use of "LIKE" instead of the equal sign "="): DCount(field_name, table_name, "[" & field_name...
  12. D

    Table remains unlock

    Hi Gasman, Do you speak about the two first parameter inside the brackets? (field_name, table_name) There have actually been already determined previously as strings
  13. D

    Table remains unlock

    Hi again, I have tried to do with the function DCount() what I have made before I want actually to make a dynamic search and make a listbox appear if there is a partial/complete match. So I need to find all items (in the field of table) which contain the written string (in the textbox of the...
  14. D

    Table remains unlock

    Hi arnelgp, Thanks for your answer! I didn't know the function DCount(), which is really useful indeed and more simple. I am going to modify my subs and see if it solves my problem..
  15. D

    Table remains unlock

    Hi, I am a beginner in ACCESS and not a native English speaker, I thank you in advance for your understanding :) I am at moment confronted to a weird problem. After attempting to create a sub to append new field to my table (called here "Table1"), I have realized that the name of this table...
Top Bottom