Search results

  1. B

    Invalid Use of Null

    What type of data is "B3", if is txt, instead of Null put "" or vbNullString. Variables defined as Integer o long cannot be Null in VBA, try to define the variable as Variant data type.
  2. B

    Issues at opening a Excel file

    After other attempts, the only solution was to make a copy of the excel file.
  3. B

    Help with opening for multiple users

    Read this link, maybe help you with more details.
  4. B

    Issues at opening a Excel file

    Yes I did, but same issues is presented. If you can, please try to open the Ms-Excel file with other office software such as Open-Office (simulating that it is open on another PC) and use the Ms-Access database, there you will see the error that I tell you.
  5. B

    Issues at opening a Excel file

    Hi guys, at the end, the second option worked , create a copy of the file in another temporary directory. Below I leave the code I make in case someone else needs it. Thanks everyone for your help Private Function MakeCopyFile(strDirPath As String, strFileName As String) As String Dim iFilenum...
  6. B

    Splitting Database With Different Front Ends

    Check this small example, it will give you an idea to create a single Front-End for different types of restrictions according to the type of users.
  7. B

    Issues at opening a Excel file

    Hello, Sorry for the delay, I've been very busy with a lot of work. I tried point (1) and I still have the same issues. I follow this link I will try the point (2) that I think will be the...
  8. B

    Issues at opening a Excel file

    There is no problem if only one person is using the Ms-Access database and gets information from the Ms-Excel file. The problem occurs when the person in charge of updating the Ms-Excel file has it open and someone else using the database in Ms-Access wants to obtain information from the...
  9. B

    Issues at opening a Excel file

    Hellos Guys, having same isues yet, somebody help me please.
  10. B

    Issues at opening a Excel file

    Yes, now use this code Private Function F_BuscaObservacion1(strId As String, strCampoBusqueda As String) As Boolean Dim MyConn As New ADODB.Connection ''Creamos el objeto Connection Dim rsExcel As New ADODB.Recordset ''Creamos el objeto Recordset Dim strSQL As String F_BuscaObservacion1 =...
  11. B

    Issues at opening a Excel file

    No, but is a way I will try. Thank for you help. Update: Same issues:banghead:
  12. B

    Issues at opening a Excel file

    Hello everyone, I come to ask for your help by a problem that has me crazy. I have an application in Ms-Access (used by several users) that obtains information from an excel file through ADODB and is displayed on a form. The excel file is only updated by a person via Ms-Excel. The problem that...
  13. B

    Question User cannot start Access database

    Some times that same happends to me, I have to rename the file and all is solved. Try this. I dont know why this happen, but that procedure works for me.
  14. B

    Click button to retrieve Now()

    Hello, see attached file, I hope is that you looking for
  15. B

    Validation on textbox not to accept any alphabets

    Try to use IsNumeric() Function.
  16. B

    Pass PK to popup form as FK - Modal

    "Me.Dirty = False" Thats means not changes in data on current records. See this link.
  17. B

    Pass PK to popup form as FK - Modal

    Yes, do it, this line of code is a way (trick) to get a debugging the code and prove the data is catched well. Or simply put as a comment, example: 'MsgBox Me.OpenArgs
  18. B

    Pass PK to popup form as FK - Modal

    Hello Zydeceltico, attatched file include tree ways using OpenArgs argument, opening form reference back to calling form or with global variable. Note: Open first "Tabla1" form. Regards
  19. B

    AND criteria not working

    Try Not (field1="b" AND field2="b")
  20. B

    Using Dlookup

    The best thing you should do is put a date to infinity (31.12.9999) in End Date.
Top Bottom