Search results

who is mr.B? i hope not the Mr.B with the Teddy bear.

will that mean we will see more of the "when i was in the navy.." thing? :LOL:

modify your code like this: Private Sub TrnType_AfterUpdate() Dim strSQL As String, frm As Form, subfrm As Form 'insert records to JR_TrClassesT table strSQL = "INSERT INTO JR_TrClassesT (JR_ID, TrnCnt) " & _ "SELECT Personnel.AFD_ID, 0 FROM Personnel " & _...

here's what AI has to say: No, JSON is not unstructured data; it is considered semi-structured data because it has an internal organizing principle (key-value pairs) but lacks the rigid, pre-defined schema of a traditional relational database. It is more organized than unstructured data, which...

Bye-bye Uncle G! "hope you have a lot of good friends out there.."

the Ai keeps generating test code (for export to json) on employee table which i dont have, so i just copy xompany table and rename the copy as employee. New_employee table is created from test code to import back from a json string to New table, which I provide as new_Employees.

Me.Dirty = False, means to save all your changes to the db.

it you need to save the last chckbox, do this On Top of your code: Me.Dirty = False ' your code below

another AI brilliance. create an xml Recordset-like class. see module TestModule for various test.

again, I asked AI to generate a json recordset class, that you can Apply Filter and Change Value just as you can with a normal recordset. this will become very handy if you have a consistent, single table, json file and you want the ability to show it in the form and perform Edit and Filter to...

I think when you change something in the combo and press Enter key, the Default behavior is to stay on the combo. unlike in the Textbox, when you press Enter key, you go to next Textbox/record.

you are Opening tmpCableTable and at the same time Updating The Same tmpCableTable using an Update Query. Can you not just Loop through this recordset and update it, since you said it is already Filtered correctly?

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.