Search results

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...

I Have the same problem. When I open another form (in restore mode) the original form also goes into restore mode. Very annoying! Does anyone have an answer?

Well, the where-option here has something to do if it is a character or numeric value, I figured out. I get no message if I enter: "Field1" Like compl But now, I don't get any results (I typed the exact word for name1)

Hi All, I have a problem and I can't figure out what I am doing wrong, I have a code: Private Sub Button4_Click() Dim compl As String compl = name1 DoCmd.OpenForm "form1", , , "Field1=" & name1 DoCmd.Close acForm, "form2" End Sub Now everytime I click on this button and I enter a value in...

Hi All, I have a parameter-query and when you execute it and 'fill in' the parameter it takes a very very long time when the results are displayed on the screen. Now, that seems normal if you have a very large table, but when I enter the parameter in the criteriafield manually it displays the...

Yes, it is larger then 2,147,000,000 (please note that it is not 2,147,000,000,000) etc. I have more than 50 values that are over 3 billion.