Recent content by arnelgp

some minor fix, when the left pane is resized, each row's heigh increases/decreases but the right pane row does not change. have this fixed. the Task bars' height also increases/decreases proportionally. background is dimmed whenever pop-up window for New task or Edit task. also "remember" the...

updated the chart to version 2. added ability to resize the task pane (left side) by dragging on the blue dividing line. note that you cannot narrow the task pane further if the delete (x) button will get hidden (or out of view). added Days and Status column on the Task pane. both task pane and...

Many times I've seen someone aspire to have a Gantt chart. I have also made a simple one. And I also saw something more complicated. This comes from asking our favorite AI. It uses the old IE webbrowser control. I haven't thoroughly tested it yet. Put the .html file on same folder as the database.

ask AI to update the VBA and html file to replace right-click with drag-n-drop to move events. also added code for recurring events. also added combobox for Years, so user won't have difficulty going to any year (starts with 2025 upto 2050).

there is an Edge webbrowser calendar here: https://www.access-programmers.co.uk/forums/threads/calendar-that-works-in-the-edge-browser.335252/ for old version of ms access: https://www.access-programmers.co.uk/forums/threads/modern-calendar-on-old-webbrowser-control.335263/

Again this is a remake of Mr.Doozer's Kanban found in: https://www.access-programmers.co.uk/forums/threads/multi-board-kanban-in-the-edge-browser-control.335257/ It is using the Old IE-based Webbrowser control. Again, the "downgrade" was done by AI. I am surprised that AI now provided the code...

here is also a simple demo and may not reflect with the record on your database. open MainForm and select from the combobox. //Edit: I change the code to always show the 16 subform.

the original database (which is Edge-based webbrowser) can be found here: https://www.access-programmers.co.uk/forums/threads/calendar-that-works-in-the-edge-browser.335252/ the code is not mine and attribution goes to Mr.Doozer of the above thread. also the New code for old IE-webbrowser...

this a job for super AI.

that is the catch, c&r, purge deleted records and reset the table, so Last() will not be reliable. it also resets all queries execution plan, i think. but i don't always use c&r, it might do harm than good, specially if power interruption occurs.

i don't know why are comparing excel against access. just prove that Last("FieldName") is not returning the "Last saved New record". you can also create a query from the table, sort it Asc or Desc (if you want). then on vba->immediate window: ?DLast("FieldName", "YourQuery")

just tested it both, in Excel VBA and Access VBA: format(cdate(0),"mm/dd/yyyy") they both return: 12/30/1899

that is way off this topic.

if you acquire something, say a house, or a car, i am sure you get the "house plan" or the car manual. it include the technical manuals. you don't acquire and update (as ms does with mso) it blindly. i am sure you have those "field manuals", "parts manual" "tech manuals" while you are on the navy.

test it first. add a record one by one. Create a query that uses Last("yourFieldName") against your table and save the query (qryLast). run the query and note the result. edit any record (not the record qryLast has shown). then run/refresh the query and you will get same result. do any edits on...