Search results

another AI brilliance. create an xml Recordset-like class. see module TestModule for various test.

again, I asked AI to generate a json recordset class, that you can Apply Filter and Change Value just as you can with a normal recordset. this will become very handy if you have a consistent, single table, json file and you want the ability to show it in the form and perform Edit and Filter to...

The code generated by our friendly AI. on the Module there are two test subs, one will create (or append to existing) table data from json string. while the other will create 3 related tables. if you see any error you can ask AI for code improvement by pasting the code to it.

It is sometimes desirable to darken the background when a Msgbox appears so as to catch the attention to the presented message or warning. This is not new, but just wanted to share if it can be of use to you. The code can be used on older Ms Access. Open frmDemo on the attached.

the code for the saving image and blurring is generated by our favorite AI friend. demo will show you how to "simulate" blurring of the background so you can pay more attention to the Msgbox presented to you. the demo forms are using "Tabbed documents" (not overlapping). so that frmOverlay can...

I cannot add new update on the original "cheap alternative to access imagine" thread since it is already closed. With this update (form frmCamera2) there is no need to configure the camera (unlike before) before it can be used to take a snapshot. You may want to experiment with various...

As I search the forum for a sample form with Analog Clock, I came across many samples. ashleedawg has some interesting demo in https://www.access-programmers.co.uk/forums/threads/making-an-analog-clock-on-an-ms-access-form-manipulating-controls-no-activex.294673/, also Markk has one on the said...

simple demo to save in Normal table the values selected in Multi-value list. Related threads: https://www.access-programmers.co.uk/forums/threads/sorry-folks-access-world-will-not-accept-my-posts.334416/page-4#post-1970100...

here is a demo db that can play video and view pdf and images on a webbrowser control. on my test, first time you open a Video, you will get a Yellow warning message. just click this message and choose "Allow blocked content...", then you won't get any more message when you open other videos...

The idea came from this thread: https://www.access-programmers.co.uk/forums/threads/screenshot.333824/#post-1959302 the form frmCapture on the database is Opaque at the moment, maybe on a new version I will make the Detail section to be Transparent, so you will see (see through) what you are...

the idea came up from this thread: https://www.access-programmers.co.uk/forums/threads/export-blob-ole-object-field-item-instead-of-attachment-field.333667/ with old OS and older MS Access, it was done easily. with New OS and Newer MS Access, it seems it needs more VBA. all the codes from the...

The library can be found here: QR Code generator (image) using Zxing (Zebra Crossing) library | Access World Forums (access-programmers.co.uk) You must be knowledgeable of the various coding system (check and google the Wiki of these barcodes and how to construct them). Don't be surprise if no...

as the title suggests, there is a form (128_demo) inside the db that you can generage Code-128 barcode using zxing library found in Github. the library is the same here: (3) QR Code generator (image) using Zxing (Zebra Crossing) library | Access World Forums (access-programmers.co.uk) that i did...

It does not change the recordset (of bound listbox), but just search the list. Maybe somebody will find use to this.

The same Excel QR Code generator found somewhere here. This time, you can create a colorful QR image instead of the usual Black on White image. It was written in A2021 and references Excel XX.X object library. There is not much documentation on the code, but I think you can follow the logic...

the demo is for simple appointment calendar only no attempt was made to validate for overlapping schedule nor duplicate schedule. there is also simple Auto-resize Control code used on this demo, with the original found in here...

the db can also be found here: Generic Form with "Save", "Cancel" buttons | Page 2 | Access World Forums (access-programmers.co.uk) (post #34). you can delete, edit as many records you want. to revert what you have done just press the Cancel button. to permanently save your work, press the Save...

Totally free sample for you. The idea come from this thread: How to encode some field from Json string into the related tables in MS Access | Access World Forums (access-programmers.co.uk) The main workhorse is the Attached excel file (I think came from ExcelRock.com) and some code I added to...

pure VBA code to mimic Pattern Lock in smartphones. the idea came from this thread: Pattern Lock | Access World Forums (access-programmers.co.uk) (same sample as the attached). need some polishing of the code and the UI.

Using the Date/Time Extended field type give many sorts of problem. You can however create a Query and including field with Data/Time extended on it. But if you try it in an expression, say you want to Dlookup("DateTimeExtField", "YourTable"), or if you have created a query with DTE field in it...