Search results

  1. 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...
  2. 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...
  3. 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...
  4. S

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

    Hello Everyone, I have an relation issue which is working in MS Access but not in SQL Server BE. That was my relation completely same when I had BE also in MS Access. Now I did this in SQL Server BE with linked table. I have following table structure and database relation between two tables...
  5. S

    Linked Table from SQL Server is done. But the Excel export macros are not working.

    Dear Friends, I have linked tables from SQL server and adjusted all queries based on new linked tables' names in my MS Access and tested it. İt workes a little slow in compared to compact MS Access (When the table is also from Access itself). Forms and reports are opening a bit more slowly...
  6. S

    Providing Linked Table for MS Access FE from SQL Server BE

    Hello Everyone, I am struggling for creating a ODBC data source and then link my tables from SQL server. (And please keep in mind that I will distribute FE MS Access with Email to all users after linking process has been done. So they need to be able to make data changes as linked with SQL...
Top Bottom