Search results

Okay thanks Minty I missed the key word snapshoot, very correct

I'm only pulling one record at a time to be used by the VBA record set from Cloud SQL server, I'm using this strategy as per advice from this platform , yes there is an improvement , but the 10 seconds its taking to pull data is too much and users do like this. Here is my simple Query: SELECT...

Thank you for the advice to all contributors

I want to clear the input form so that new record can be added, I'm using this code below, but it's creating a new PK number, this is leaving some gaps in sequencing my record and it's an audit issue because it's not always when people should continue capturing at some point they have to knock...

Okay thanks , this one has worked IIF(Len(rs!stockreleasing), rs!stockreleasing, Null) This was given by Josef P. Many thanks him and all the contributors. Regards Chris

I'm still getting the same "" instead of null by using the provided function: Company.Add "stockRlsDt", NullIf(rs!stockreleasing.Value, Null)

The field below is a date release now sometimes the date field is empty , now in the Json dictionary it keeps return "" instead of null as result I'm always getting an error. Company.Add "stockRlsDt", rs!stockreleasing.value I want this field to return null if empty and actual date if not null

GPGeorge & Minty Thanks you so much to you valuable professionals , the timestamp field has sorted out the problem, this has been a thorn or nightmare for us for sometime. Regards Chris

We have a pricing table which is linked from access by ODBC link tables to SQL server cloud , now this table is required to change the prices regularly , but whenever we want to do the changes we always receive a message that the table is being edited by another user even if there is non , and...

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