Search results

Hi Looking at ‘Departement’, I suggest you change the keys to numeric, leaving the data (‘Nom’) as-is. In your example form, the drop-down box should have two fields, rather than the one as coded. Thus the Row Source should be “SELECT IDDepart, Nom FROM Departement;” (thus returning the primary...

Hi I can't see the relevance of your two boolean flags in this code? It seems to me that the key is in the callback flags ("enabled" and "visible"). In essence, you need to set these to either "true" or "false" when the callback is invoked. So where you have "bolEnabled=True", subtitute...

If you open your form in design view, you'll see the control name is "ID" (same as the table field name). In your VBA, change Me.Date2Day to Me.ID and it will work. How do you cater for multiple entries created on the same day? Do you allow duplicate keys? If you need to make keys unique, you...

You might find this link useful www w3schools.com/sql/sql_union.asp (I omitted the '.' between www and w3schools because I'm not allowed to paste links as a newbie to the site). Have a look at the SQL UNION query. If your tables have different field names, you can do something like this...