Recent content by bdra2778

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.

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

Read this link, maybe help you with more details.

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.

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...

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.

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 https://www.ablebits.com/office-addins-blog/2017/08/02/excel-shared-workbook-share-file-multiple-users/. I will try the point (2) that I think will be the...

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...

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

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 =...

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

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...

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.

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

Try to use IsNumeric() Function.