Search results

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.

Vhung, you need to Edit the Registry (Registry Editor)so that the Logo will Rotate and Zoom. If you have x32 bit Windows edit this registry setting: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION If your window is x64 bit...

see Query1. note that you can only have 255 columns on your table/query.

add Zoom In, Zoom Out effect.

what version of MS Access do you have? this is the result you will get:

is that legal? rotating your municipal logo. anyway, check first your lgu if that is legal. i am using webbrowser control to rotate your logo (only 1 logo is enough). open form2.

sample code: ' valid create table sql sql = "CREATE TABLE Employees (" & _ "EmployeeID AUTOINCREMENT PRIMARY KEY, " & _ "FirstName TEXT(50), " & _ "LastName TEXT(50), " & _ "HireDate DATETIME, " & _ "Salary CURRENCY)"...