Recent content by arnelgp

you can even shorten the control source on the main form to: =[F10Test_1]![F3]

SELECT YourTable.DateField, [DateField]-(Select Top 1 T.DateField From YourTable As T Where T.DateField < YourTable.DateField Order By T.DateField Desc) AS Diff FROM YourTable ORDER BY YourTable.DateField DESC;

Version 2. Resize the Msgbox form (made it shorter). Make the Icons much bigger. Add background color to the detail section and also background color of the IE webbrowser control consistent with the MsgType.

on design view, click on the subform, and on it's Property:

still using the old IE webbrowser control to have an annimated icons and to quickly catch the attention on the message.

maybe add On Error Resume Next: f Me.PriceListItemsPicked.ItemsSelected.Count = 0 Then MsgBox "MUST SELECT @ LEAST 1 ITEM" Exit Sub End If On Error Resume Next Set ctl = Me.PriceListItemsPicked For Each varItem In ctl.ItemsSelected rs.AddNew rs!CustomersID = Me.CustomersID rs!Customers =...

it's too late, just in case. please try this.

to make it simple, just add a Delivery table. will hold the DeliveryID (Autonumber), WOTicket, DeliveryQty, DeliveryDate use combobox to select which WoTicket on the form.

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.