Recent content by Thevince

I live in belgium. My clients ask me several times for an app to purchase any kinds of goods. I've googled on "access user activity" and found what I was looking for here http://www.business.com/business-intelligence/tracking-user-activity-in-your-access-databases/ Hi

It should be a great idea but how can I do a user activity table ? Could you be more explicit? Thx

Hi everybody I made an access 2013 application. I want to sell licences per users. How can I know how many users are connected in the database ? Is there an easy way to know that? Thanks

Hi guys This is what I was looking for https://www.youtube.com/watch?v=BRCOj7sJ7rg Thx Post may be closed

Hi guys I have a table products with a field "id_product" and "total" (Total items in stock) I have a query with the fields "id_product" and also the field "total in stock" I want an update query to update the field 'total' in table 'products' with infos from that query For each id-product...

Hi pbaldy. That was it! The autoextend property was on "yes", I put it on "No" and now it works perfectly! I've never used that property before. So, I'm like Pharel WIlliams, i'm happy now! Tadadidadaaa ! Thanks to all of you guys ! This post may be closed.

Then you miss it, the last control on this form has the name modifiable12 an its label is "Liste déroulante", the listbox (secondcontrol) on the same form has as name "liste_produits" and as label Code_produit. So the combobox is "Modifiable12".

Ok here is the whole DB zipped, it's a test db with nothing confidential. The form is Frm_recherche_produit and the control label is Liste déroulante. www;clicinfo;be/access/db;zip Thanks for all the efforts you do ... :)

I believe all what you say and the website is realy interesting. I wonder what you say because the rowsource is in fact based on a filter updated every time the control changes. I've just add a top 5 to the query to just select the five first records and the behaviour is just the same...

Hi vbainet Thanks for fast reply I've more than 2000 records but that's not the question. I want to implement that sort of search with more comboboxes. For each combobox so much coding ... There must be another way i think.

Right for the 2 code lines. So much code for so a basic functionnality. Put 3 vba codes in 3 different places... only for one combobox with one field. Seems a bit complicated to implement in my project. I thought using this for more than one combobox. Isn't there an easier way? Thanks

Hi JHB and thanks for the post. That works perfect but unfortunately I really need a combobox because I'll need it in a subform to chose a product in order lines. That's why a listbox is not what I need. Thanks Is it so complicated ? I mean ... that's a basic in searching items. Search...

Hi I've tried many thing but nothing changes What do you mean with "change in criteria" ? A requery forces my combobox.value to a blank string and I can only put 1 letter instead of more. You can see a video of my problem I may not post video links because I have less than 2 posts and I...

Thanks for fast reply No, I have only one combobox that must change on the fly ... Not cascading one's Another idea ?

Hi everybody I have a drop down list and I want that the rowsource changes on the fly. The code written here works perfectly for the dropdownlist but the control itself works not good When I type "all", the combobox list shows all the items with "all" in it, that's perfect. When i type "bo"...