Recent content by arnelgp

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.

maybe your db apps get Stoned:sick:

alternative use tLookup() and other domain lookup alternative: https://www.access-programmers.co.uk/forums/threads/replace-dlookup-with-as-sql-query.319710/#post-1787342

can't you manually Default printer to print on 600x600 resolution. i think you can.

HEU KMS

from Copilot answer. you can add "trigger" to your sql server when a record is modified or added. like creating a record on the audit trail table on your sql server. on ms access part, again from CoPilot: MS SQL Server cannot directly “push” notifications into Access when a linked table...

vhung see the two new form.

you can also Save the Current Exchange rate of US$ to GBP to your table. then using Query, you can Compute the Conversion of each field.