Search results

We have 10 salesmen who go in the field to go and sell our products (They all have tablets with Windows 11 and Access 365 as FE), the taxman require them to issue a digital tax invoice right there in the field, but to do that they need to connect to our local server and this can be done via WIFI...

Records from the query are loaded into a form where I disabled record navigation, on "form_load" the record is set "inUse=true" and a DoCmd.RunCommand acCmdSaveRecord is run, if another FE instance is open, this record should never be loaded from the query and so the form. why not use XML to...

Here am talking about MS SQL Server provided by win Host which has a total space of 30 GB, now I was thinking of sharing this database in 5 GB for medium enterprises, but for security reasons I have backed off instead I will be offering them the one with 5 GB and bigger companies with 30 GB. Ms...

Thank you so much Josef , I appreciate your efforts and I hope others will learns something here. regards Chris

Many thanks Josef P. The original code works very well and it takes only 1.5 seconds to insert 20 invoices from the internet so I would not want to change anything now.

Well below is my final working code Private Sub CmdlocalPurchasesSearch_Click() Dim n As Integer Dim z As Integer Dim JSON As Object Dim item As Object Dim lineItm As Object Dim itm As Object Dim Request As Object Dim strData As String Dim stUrl As String Dim Response As String Dim requestBody...

Many thanks David , with your concept it led be to use Dlast function , finally its now able to link all the invoices correctly, I must say without your contribution I was completely lost here Many thanks sir. Regards Chris

If the foreign key can be insert logically then that will be very fine but all the same.

Many thanks martin , now I'm receiving all the data except the foreign key issue , once again many thanks sir. regards Chris

Kindly note sir , the top part purchases header is working okay no problem , the challenge is on the second part or the purchases details or child table. Below is my full code : Private Sub CmdlocalPurchasesSearch_Click() Dim n As Integer Dim z As Integer Dim JSON As Object Dim item As Object...

I'm guessing that invoices are the rs recordset and invoice items are the rst recordset. It should pick up the PK for every new rs record added. Yes that is correct See below Dim db As DAO.Database Dim rs As DAO.Recordset Dim rst As DAO.Recordset Dim PK As Long Set db = CurrentDb Set rs =...

Thank you so much cheekybuddha This works , but saves only the first PK , I have sometime 5 invoices to save .

I have updated the code above and now its working okay, except how to force the created primary keys to also appear in the child table as foreign key This is only picking the last record I want to from the most current to last DLast("PurchID", "tblpurchases")

Although I have an option to recapture the received Json manually from the report into both the parent and child tables, but I see this option to be somehow risk because wrong data can be easily captured we are human and this is also alot of work So, in view of the above I have struggled to...

EBS 17 is right here, thanks

I want to filter related record quickly and below is the suggestion I'm getting Microsoft: Indexes on Foreign Key Constraints Unlike primary key constraints, creating a foreign key constraint doesn't automatically create a corresponding index. However, manually creating an index on a foreign...

I'm not a fan of indexing the foreign in my SQL Server Database, some people suggest that indexing the foreign can help queries data retrieval faster as but the queries be parameterized. Especially when the front end is MS Access, could this be true? If yes any supporting material evidence?

Anyway, we will leave that way rather start storing data locally is again waste of time and in addition to that users can easily forget to update the local tables

We have two backends (BEs, that is Cloud SQL Server and MS Access) using the same MS Access interface as front end (FE) to send data via the internet to the server. If we send the data using the code below and save the response to the backends below, see results: (1) Cloud SQL Server will take...

Many thank Edgar sir, with your assistance I managed to use your idea and came up with the solution below: This is what worked for me on windows 10/11 Add ALLOWED_HOSTS = ['*'] in nector settings.py file run nector server with Java manage.py 0.0.0.0:YOUR_PORT. I used 8080 as my port. Make...