Recent content by arnelgp

The code generated by our friendly AI. on the Module there are two test subs, one will create (or append to existing) table data from json string. while the other will create 3 related tables. if you see any error you can ask AI for code improvement by pasting the code to it.

No it will not happen, return a Null value. The subquery will return a Value or No record at all, but not Null value. Unless the OP has Null values on UserID field.

here is a comparison test using more than 1M records (but I doubt you will download it). demo dcount("1")

Since when did we believe everything AI tells us? :) I already told, that I have actually read this a long time ago by a book of an MVP (actual person not AI), and been using it since (here is a sample of my use...

I also encounter that, as If it is copying a Table (data and structure). maybe just copy the SQL string and paste it on the new query.

Actually I have read this long time on one of my Access books. I am too lazy to look through all my numerous books, so I asked AI. Here is what AI has to say: Question: Can i use "1" instead of "*" in Dcount domain function in ms access? Answer: Yes, you can use "1" instead of "*" in DCount...

use Dcount(): a Label can only have a .Caption property Me.lblCount.Caption = DCount("1", "ComponentOrderQuery", "[OrderID] = " & Nz([OrderID], 0))

if you are an engineer and has experienced building one from scratch, then go ahead. for us, dummies, just buy one, and be familiar with the for the dummies manual.

an SQL server is best run on Windows Server version. use the latest tech for your Server, not just a simple pc, use a Server pc. for workstation, there are i13 now.

i suggested not to Hide the access main window but to move it Off screen. this is working on my test.

you can also use the the Form's BeforeInsert event to Set a Variable to true. then Reset it on the Form's AfterUpdate

what is it? another end is near and so i face..

can you use webbrowser control? see sample db in post #12 of this thread: https://www.access-programmers.co.uk/forums/threads/access-product-catalogue-website-style.333196/

i also tested my code before posting and it does work, just for clarification.

SELECT tblHousehold.ID_Household, tblHousehold.[Family Surname] AS [Household Name], tblHousehold.[Family Address] AS [Household Address], tblHousehold.[Family Phone] AS [Household Phone], (select top 1 Person_First From tblPersonal Where ID_Household = tblHousehold.ID_Household And...