Search results

Hi, by clicking on an item of the listbox you 'select' it. After, the item is selected or not depending of the previous status. The focus is then set on the clicked item (see a dashed rectangle around it). The method used is then not the good one in this situation. By chance there are others...

Hello, Maybe I wasn't clear enough I listed choices so you had to pick one of the solution matching the most your requirements. From your reply I believe that you want to go for the empty table. There is quick correction of your function 2 things to make sure of - DataStaf.xlsx (the empty one)...

Hello, it's not that the export is deleting your header/title, you are creating a new workbook (i.e.: an empty one) and start writing in the lines from the 4th on. There are two options to have your title displayed: - Since it is a rather simple one you could had a few lines of code to write...

Using the method described by moke123, there is no need to store the image address in a table of your database. If now for whatever reason you can't or don't want to rename your images you should think about a new table having at least 2 fields, 1 being the part number and the second being the...

Hello Dave, being a bit short in time for a full reply I will share the approach I usually have in this situation. I use the afterUpdate event procedure of the combobox to collect the new combobox.value and update the recordsource of the subform with a new query (SQL string) more than...

Hello, if you set "Enabled" to No (Data tab of the property sheet in design mode) on all your controls the user won't be able to select any cell in the datasheet view and by extension no highlight of the row...

Hello there! I also noticed that, in design mode, the "Tab order" (available in the tab "Other" of the property sheet) is reflecting the column ordering of the datasheet view. It also works with split forms. Just to complete the panel of answers already given here.