Search results

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.

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

maybe change the function to: Function GetTreeViewText(tv As Object) As String Dim treeText As String Dim node As node .. .. .. end function

Date format is not an issue. the problem are those people, not having guidance as to the Basics of Ms Access. It is a good advice to Read the Manual first before you try to Operate.