Recent content by SORM2

Hello when you wirte the date like 09.03.2021, after this row took an PK id (saved in database), then it is automatically be converted into form 9.03.2021. Therefore when you want to copy and paste it to second row, it does not accept in this time because of the input mask.

Hi everyone, I have a tabular form which has input mask for date fields "00.00.0000". So when the user wants the copy the record and paste as new record, it is generating error if these date fields have the value like 9.03.2020 because day area is only one integer while the input mask was...

No, there is not ASCII Text. There is some charachters like "İ", "ı" in the other tab of propery section of forms. So it seems they were the reason of the problems.

Hi The Doc_Man, iI think today I solved the problem. There were some non-english words in the word headings in the forms which I did not realize. I have changed all of them. It seems now it is working. Thanks for the help.

Dear The Doc_Man, Should those version numbers be completely the same? I will test tomorrow.

Hey mike60smart, Yes it workes in this way. However When you think that you need to do that for more than one user and for each updated version of appllication, It does not seem the ideal solution. After doing what you told, the working application because is still not working in my computer in...

Dear The Doc_Man, Today I tested the both machine's access references. They are completely same and in the same order. But the application which is created in his machine gives the error message in my computer and vice versa.

Hello The Doc_Man, Thanks for comment. How can I check which references are used in the machine? I will look at it tomorrow accordingly.

Hello all, My application worked perfectly in around 200 users except for 1 person. He uses the same Access version with us (Prof. Plus 2016). He uses the same language for access, Windows and region language settings for unicode. However he gets this problem when he opened the application. I...

I used the function you wrote which is "CheckTableLinks" in a module and then put it to opening event of my form. What I want is simply to give a my own pop up message to users in case no connection.

Hello Minty, I posted my code in my 7. message already. Sorry if I dont understand. In the open form I called the function of that code like below, I wrote in 7. message. Private Sub Form_Open(Cancel As Integer) Call IsODBCConnected End Sub

it is the same as you sent me. I wrote the code you send, exactly like below to a module. One of my tablename = tblcustomer Function IsODBCConnected(tblcustomer As String) As Boolean If Not TableExists(tblcustomer) Then Exit Function Dim rst As DAO.Recordset On Error Resume Next...

Hi isladogs, Thank you very much. However I still could not get this function worked. I wrote your second code as well as Minty's code in a module and then call this function in the opening event of my beginning form. Nothing changed. that code did not affect anything. I will be glad if you...

Hello Minty, How should I apply this code? Should I write it in a module? Then where should I call the function "IsODBCConnected" ?

Hi Everyone, I have a database application with MS Access FE and SQL Server BE through the linked tables. When I forget connecting internet and then open my Access then I wait long and took SQL Server connection failure. I would like to create my own messagebox instead of SQL Server connection...