Recent content by MartijnAn

What would you suggest to do so? If I join the table, I still cannot grab the value I am looking for. For example: After running the query I want the value that is in the second observation and in field X

Thanks for your reply... I know how the dlookup function works, I just wanted to know if you can set your criteria by the 'recordnumber' / 'record listing' in the result of the query. For example, if I run a query, I want to know the value of field x in row 2

Hi All, I want to retrieve a value from a query with a Dlookup function, where the 'Recordnumber' is the criteria. Something like this... x = dlookup("[Field]","[query]","Recordnumber = 2") Is that possible?

Does this help?

It put the code in the page AND form footer (sorry I forgot to mention forms)

Thanks for your reply. I have only one checkbox before each record. And I don't want users, once they selected one record, to select another record.

Hi All, I have a continious form with checkboxes. How can I write code that users can only select one! checkbox? regards, martijn

I put the code in the footer but receive an error, does anyone know how that is possible?

Oh sorry, in a form. The checkboxes are in front of each record.

Hi All, I found this code in another Topic: Now, the code does work but it only prints the last record which is selected, not all the records I have selected. Does anyone know what could be wrong? Thanks.

I have a simular question. But whatabout you have selected 2 or more persons? Then you have to work with a loop function right? DoI created this, but it doesn't seem to work: Function Macro1() Dim sel_vak As CheckBox For Each [sel_vak] In [Forms]![frmlijstcomplexen] DoCmd.OpenReport...

I know, but I did not know how to delete this thread! Sorry :o

I solved it with the commandbar method, the only problem is that I have to enable everything each time I leave the form... @tpkstock: Yes, I built my own custom menu's. The funny thing is that a get no longer a run-time error, but he does not disable the menuitems that I selected. I tried...

SetMenuItem -------------------------------------------------------------------------------- Hi All, I have an issue which does not come to an end and it is making me crazy! In an form_load event I have the following code: Private Sub Form_Load() DoCmd.SetMenuItem 1, 1, , acMenuGray End Sub...

Hi All, I have an issue which does not come to an end and it is making me crazy! In an form_load event I have the following code: Private Sub Form_Load() DoCmd.SetMenuItem 1, 1, , acMenuGray End Sub Well, I do no not receive any error, but the specific item does not turn grey! Can someone...