Search results

What is happening here is that whenever I move from one location to another my public IP address changes which is cumbersome, now Imagin we have salesmen moving to different locations in a day. This means that they cannot login or connect to PHP cPanel MYSQL database, is there a way to sort out...

Thank you so much Edgar! 1. It seems like the error message indicates that there’s an issue with the parameters in your request. You seem to have a very clear understanding of this error message, I need to concentrate on this point, I will be back with the results tonight.

Point taken and thanks for the correction to all contributors

Now the last part I'm struggling with is how to make a wildcart IP address which will allow connection for all IP addresses in the range. Here is my public IP address which which I use Public IP address = 41.224.117.250 Submask = 255.255.255.0 Now how do I make a wildcard IP address from it ...

@ComputerVersteher Mnay thanks. I can tell you after implimenting the following all is working great! (1) #Deleted data , here I'm using Me.requery to clear that (2) Timestamp = require current time on both Default and atribute Plus a null tick (3) BIT data type I have gotten lid of it...

Finally the Timestamp is solved by using Now() function

@theDBguy Not sure if this is relevant, but the same thing could happen with a linked SQL Server table if the bit field doesn't have a default value assigned since Access cannot contain Null values in bit fields. Actually I followed your advise and it has sorted out 90% what happens if the BIT...

The PK is there, I remove the field with a BIT datatype all is fine, that is where I am getting puzzled. I use requery on the add or save button the #delete error also goes away on the form , now on the subform where do I put the Requery?????????/

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

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

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

I think I need also timestamp here

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

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

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.

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

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

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

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

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