Search results

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

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