Search results

i will look into it later. but in reality, max flag colors can be 3 to 4 colors. The colors on the Textbox is for display only. the actual records are save to the Junction table.

you could also try the database on the Sample Database section: https://www.access-programmers.co.uk/forums/threads/multi-value-field-mvf-faked-form.334428/

you browse to code of the Public Sub Init() of from frmMVF. the Init() sub, does some initialization, like where to position the pop-up form (frmMVF) and setting the Listbox Rowsource. you pass the SQL string as the rowsource. the Listbox is bound to LukID field of table tblDummyMVF. since that...

added another table tblNationalities and junction table tblCountryNationals for more test. also adjusted the code to prevent the "mvf" form from getting off the bottom of Access screen. added extra "multi-value combobox" to the three forms. combobox nationals' records will be saved to...

it is an MVF. See the table structure you will notice that it is combobox, multi-select. maybe you have learned something new aablut MVF.

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

i must submit may entry. if you find errors on the sample db, just rectify them. this is for you to develop further. please open 1_README form for some background and attributions.

you have 87 post (as I see it). just keep on posting.. we all went through this, if you have endured and survived the difficult times of your life, so you will and be refined as gold..

only problem with the code (possible to revise) is when the field you want to set to Null has a Property="Required". otherwise the only problem is if the field to set to Null is MVF (which you can't just set to Null, you need to open it as recordset and delete one by one).

you can also use: Filename = "Quotation" & " " & Format(Me.JobID, "\M00000")

very good vhung, your macro works well. i added 2 more records on Table1, open Table table1 and click on the link.

apology, overthinking of me.

i think it is impossible to accomplish if you are using a bare-naked table. but if you use a Form (datasheet form, open dsTable1 form for example) you can capture the Click event and redirect it's action.

If you have A2021 or 365 you can copy the form on the demo to your db. run the form to delete records from your table. there is a little table on the demo, table1. see it's content and run the form to delete it's record. Edit: what happened to your Map thread, did you got it solved or have...

You can also do the Deleting or records from another database. open form frmTableList from the demo and select the external db. then select which tables to delete records from (note the Listbox will Not Contain linked Excel/text file and the DB to open is not encrypted with password). the demo...

so now you copied from 4B + 1 AI? finish or not pass your papers..

watch out.. DanielP, is watching..

people might construe, that he did all the effort. even if you write a book, and you quote it from another book, you put the reference on the footnote. or you copy someones code, you put attributions.

expanded the table and CF for some colors.

don't you think you need to give acknowledgement/credit to ChatGPT on your presentation after all he does the heavy lifting?