Search results

  1. S

    How can I prevent the input mask problem while copying the row?

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

    How can I prevent the input mask problem while copying the row?

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

    A Problem occured while MS Access was communicating with the OLE server or ActiveX Control.

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

    A Problem occured while MS Access was communicating with the OLE server or ActiveX Control.

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

    A Problem occured while MS Access was communicating with the OLE server or ActiveX Control.

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

    A Problem occured while MS Access was communicating with the OLE server or ActiveX Control.

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

    A Problem occured while MS Access was communicating with the OLE server or ActiveX Control.

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

    A Problem occured while MS Access was communicating with the OLE server or ActiveX Control.

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

    A Problem occured while MS Access was communicating with the OLE server or ActiveX Control.

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

    How to test SQL Server connection and prevent Server failure message in MS Access FE?

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

    How to test SQL Server connection and prevent Server failure message in MS Access FE?

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

    How to test SQL Server connection and prevent Server failure message in MS Access FE?

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

    How to test SQL Server connection and prevent Server failure message in MS Access FE?

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

    How to test SQL Server connection and prevent Server failure message in MS Access FE?

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

    How to test SQL Server connection and prevent Server failure message in MS Access FE?

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

    one to one relation problem in SQL Server BE. Related int. field is not taking the value

    Dear Pat Hartman, Firstly I thank you for your time such a long explanation. I read it carefully and I understand that Ms Access is doing some user-friendly algorithms and the people who starts with MS Access as me suppose those are the proper database algorithms and expect the same working...
  17. S

    one to one relation problem in SQL Server BE. Related int. field is not taking the value

    Hello Pat Hartman, Thanks for your answer. But my relation is already the same what you told. Did you look at my Access which I sent in my first comment as attachment? One table's (Vehicle) PK auto-inc. field is linked to other table's (Plan) integer field. And the question is why is to enter...
  18. S

    one to one relation problem in SQL Server BE. Related int. field is not taking the value

    You say it is normal, but did you look at in Access file "vehicleplanform"? you can see there planid is taking the number value automatically same as vehicleid of Vehicle table.
  19. S

    one to one relation problem in SQL Server BE. Related int. field is not taking the value

    Hello Minty I had relationship in SQL Server between unique integer value planid and vehicleid (PK) which is 1 to 1. As I explained in my first message, planid is not taking the value of vehicleid after new entry. But it was taking in MS Access BE.
  20. S

    one to one relation problem in SQL Server BE. Related int. field is not taking the value

    Hello Minty, Plan table has a lot of date fields and note fields. Vehicle table has a lot of other relations with other tables. So, I do not think it is a good idea to take all parameters to Vehicle and detroy plan table. And secondly I would like to know why it is not working in SQL Server...
Top Bottom