Recent content by arnelgp

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.

as suggested by Jason Hayes (no Timer Event).

here is a video of the db run on Windows 10 x32 and Ms Access 2016 x32 on Virtual Machine. i already modified the Registry keys.