Search results

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.

you can also use the ISO 8601 standard date format: YYYY-MM-DD.

the subform's table should also the Sales/Invoice ID, so that you can Link it to the main form (Link Master Fields/Link Child Fields).

the OP can "hard" set the format by going to control panel and change the Loale date setting.

is it so hard, considering he is the programmer?

add also the Format (Property) of the data textbox in design view.