Search results

  1. N

    Solved MS Access Forms cannot allow edit and shows #deleted record in Link tables in MySQL

    This is very strange indeed I have never seen this before: (1) Table with data type BIT(Yes/No) in MYSQL will not allow editing , but if I delete that field then all is fine. What do we do here we need those fields (2) When inserting the data in MYSQL the update shows horrible #Delete error...
  2. N

    Solved Insert data in phpmyadmin MYSL from MS Access

    its looks like its the issue of primary key not assigned as auto increamental, let me invegiate on this one
  3. N

    Solved Insert data in phpmyadmin MYSL from MS Access

    Okay here is the message I'm getting when trying to insert data in Phpmyadmin cPanel database from MS Access
  4. N

    Solved Insert data in phpmyadmin MYSL from MS Access

    I think I need also timestamp here
  5. N

    Solved Insert data in phpmyadmin MYSL from MS Access

    I'm trying to insert data into cPanel MySQL with MS Access linked tables, I'm failing what should I do , I simply exported all the access tables to cPanel using ODBC for MYSL all went well and the speed is extremely good, even combo boxes with a lot of data they are working okay and fast. Any...
  6. N

    Solved Forwarding the port number to access Tomcat server in MS Access

    Well it is sorted out What it wanted was to reference the IP address for the server, that where I was making a mistake. This code below was just referencing the local workstation IP address: stUrl = "http://kocalhost:8080/nectordbs/items/save" So the correct way is to do it like below...
  7. N

    Solved Forwarding the port number to access Tomcat server in MS Access

    Okay When I try to send the invoice details to the server so that the server now takes up the communication with the virtual machine about the tax and sales details that is when I get that error, it looks like the communication is blocked somewhere.
  8. N

    Solved Forwarding the port number to access Tomcat server in MS Access

    I'm using an MS Access to process invoices by trying to connect to the Tomcat Server which is located in another room, I'm able to access the MS Access database by using the local area network without any problem. Now to access the Tomcat server file(communication file) on that computer by...
  9. N

    Using MS Access with WAR File

    The WAR File act as the communication centre , and so all the workstation to communicate with the Virtual Server they have to go through this resources which is stored on the server. Strange thing The MS Access DB application stored on the server shared and workstations using WIFi works well...
  10. N

    Solved Urgently needed a third party QR code generator seller for MS Access Invoices

    Many thank to all people I'm grateful for the contribution
  11. N

    Solved Urgently needed a third party QR code generator seller for MS Access Invoices

    Ok thanks Private Declare PtrSafe Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, _ ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long Private Sub Report_Load() ' Declare variables Dim...
  12. N

    Solved Urgently needed a third party QR code generator seller for MS Access Invoices

    Okay finally I have found the answer, its now working okay even you scan by a smart phone
  13. N

    Solved Urgently needed a third party QR code generator seller for MS Access Invoices

    I can buy it at $200.00 Simply contact me on the email indicated
  14. N

    Solved Urgently needed a third party QR code generator seller for MS Access Invoices

    Dear all, I need a VBA QR code generator from a third party seller urgently of high quality , can somebody point me to that person as soon as possible . For example in the database control called QR I'm storing the URL received from the Virtual server see below: QR (Text control) =...
  15. N

    Can Studio Management for MS SQL Work with MySQL

    Many thanks for the valuable information, actually it has turned out to be cpanel to do the job that we normally do in MS SQL Management Studio , we need to download Mysl connector ODBC depending to the window bit installed. Exporting is just the same like wo do it one by one using ODBC (1) We...
  16. N

    Can Studio Management for MS SQL Work with MySQL

    Sorry People, For the purpose of switching over from MS SQL Server which I'm used with to MYSQL which I have never used before I want to find out whether the SSMA studio can still be used to create tables, view and stored procedures for the cloud database under MYSQL. We have been doing this...
  17. N

    MS SQL Server cloud database Performance

    Many thanks Minty , I have now an idea
  18. N

    MS SQL Server cloud database Performance

    We are currently using WIFi all the machines are using one network or hooked to a router.
  19. N

    MS SQL Server cloud database Performance

    The performance of the cloud database is not impressive compared to local MS Access database evening after making sure that the following are done: (1) All calculation are done by the server itself (2) All combo boxes load empty until four matching characters are type in (3) All reports are...
  20. N

    Solved How reference an IP Address Control In MS Access

    Many thanks this is what I wanted
Back
Top Bottom