Recent content by arnelgp

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

you said you already has a resulting query? you only want to group them? create an Expression on your original 90 days query: Expr1: Date() - InitialDate now create new query to add the Group: SELECT [90daysQ].ID, [90daysQ].InitialDate, [90daysQ].FN, [90daysQ].LN...

suggested on post #2

the code came from Ai. first the printer must be set (default) to a real printer (not pdf). you open the Report in Report View and there is a "little" button that user can click if he want to Print or Save to PDF. Open ReportDemo1 in Report View.

there is an old Chinese story: a Chinese man complains to the court: "me no come" "wife no come" "baby come, how come?"