Search results for query: *

Sorry for my stupid question. I have just found out Me.requery makes the deal in the click event ...

Hello, I think it is not a hard question but I do not find the correct answer yet. I have a table subform in my main form. This table contains a checkbox field, I have just noticed that by clicking on the checkbox from the subform, it is not direclty updated to the current table. I need to...

Thank you so much.It works but I am still not sure to understand the reason why...

Hello, My problem is that the string length does not fit. When I display the string "FileList.Item(I)"(see the code below), it is OK but when I check the length using "len" I obtain like 4000+, instead of 19 ... I was looking for a Common Dialog where the user can select multiple files. I...

Ok thank you for the information. I take note but I cannot make this change now. I have so many table to change :) But if I have a problem with order, I will know where it comes from.

A bit late but I just found why my table acted odd. Maybe it could help someone who may have the same problem. When you open the table in the design mode, on every field, the "index" parameter must be set OFF. Then there won't be any sort problem. In fact, sometimes Access set it ON for some...

Thank you for your quick reply, I will test that !

Hello, I have a problem to use correctly this statement. I have one table with 2 different fields A and B. When I open the table, I can see that the table is sorted according A by double clicking on the table under Access. Then I use the Movefirst statement and display my position by using...

I tried with the Expression Builder, it worked very well. Thank you so much for the help. I will use it from now when I am lost with the syntax. Concerning my tab problem, I have just understood that a tab inside a subform, is like a subform inside a subform.

Thank you for your quick reply. Sorry for my poor explanation but the combo box is inside a tab, this tab is in a subform. To update the data in the combo box, I use a button a the main form which creates a pop up (unbound form). From this pop up, I update the combo box. Anyway, I will try the...

Hello, I recently began with VBA and I have some trouble to requery a combo box inside a tab. In my main form, I use an unbound form to update the combo box. It only works one time ... if I try to update the combo box again, nothing happens. Here is the code ...