Search results

  1. arnelgp

    Date format reverts back to previous format

    you can also use the ISO 8601 standard date format: YYYY-MM-DD.
  2. arnelgp

    Combo in subform display the previous value

    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).
  3. arnelgp

    Date format reverts back to previous format

    the OP can "hard" set the format by going to control panel and change the Loale date setting.
  4. arnelgp

    Date format reverts back to previous format

    is it so hard, considering he is the programmer?
  5. arnelgp

    Date format reverts back to previous format

    add also the Format (Property) of the data textbox in design view.
  6. arnelgp

    Solved Code running report despite default set to not

    maybe your db apps get Stoned:sick:
  7. arnelgp

    Solved How get lid of domain function and replace them with opening recordset in MS Access VBA

    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
  8. arnelgp

    Solved Report resolution fix, maybe

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

    How Sql Server can interact with Microsoft Access (or other application) ?

    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...
  10. arnelgp

    Rotate an image

    vhung see the two new form.
  11. arnelgp

    Currency from US$ to GBP

    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.
  12. arnelgp

    Rotate an image

    as suggested by Jason Hayes (no Timer Event).
  13. arnelgp

    Rotate an image

    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.
  14. arnelgp

    Rotate an image

    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...
  15. arnelgp

    Query with heading and row and listing

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

    Rotate an image

    add Zoom In, Zoom Out effect.
  17. arnelgp

    Rotate an image

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

    Rotate an image

    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.
  19. arnelgp

    Solved VBA Database.Execute("CreateTable...") - Table created in CurrentDB, not the specified DB

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