Search results

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?"

maybe Increase the Lockfiles and use Transaction on your update: Dim db As DAO.DBEngine Const maxDefault& = 9500 Set db = DBEngine ' temporary increase the lock files db.SetOption dbMaxLocksPerFile, 20000 db.BeginTrans With rs If Not (.BOF And .EOF) Then .MoveFirst End If Do...

here is a demo, view the code on the Button on form1.

i have just Returned the external drive i purchased, it's made of china and what inside is just like a small pendrive. the drive is 4T. i needed it to backup my files 90G. it copied alright, but the problem is all the copied files are not readable or not in expected format.

if you have already a solution just ignore the sample db. the demo db is for others, who will find your post and will find it useful for them.

here is another demo, the code provided by Mr.DougSteel.

you can add 2 dummy textbox in front of those comboboxes.

test your form and check out the code on AfterUpdate event of txtProductCode.