Search results

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?

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

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.

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

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

Hi All, This question has probably been asked before, but couldn't find a related topic. My question: How can I import long numeric values (integers) greater than 2,147 billion (standard long integer). I tried a lot, but couldn't find the answer. Thanks.

Hi All, I have a continious form where each record can be edited. After editing a record the form does a me.save and a me.requery (is important). After this it jumps back to the first record (seems logical), but how can I write a code that he goes back to the 'previous edited record'. Thanks.

Hi All, I have a subform in which users kan edit a field. Some contain more than 100 records. After 'an edit' the code save the adjustments in the table. Then the subform automatically jumps to the first record, but I want it to go to the previous record which they just edited. Is that...

Hi All, Is there a way that I can make a button which will undo all the changes being made on a form (on multiple records). I have a continious form with a checkbox after each record and want to restore the 'old values' if necessary. Thanks. I know it's possible by record, but the tricky part...

Hi All, Does someone know how to validate data entered in textbox to a table? In other words: how to check the value entered in the textbox exists in the table. Thanks.

Hi All, I Built a form with a selectbox. On each form there a several records shown. After each record you see a selectbox wich you can turn on and off. Now, everytime I click on a selectbox it automatically goes to the first record on the screen, why is that? With this action I want the...

Hi, If a datefield is empty (null) the result is 12:00:00 AM, we all know that, but I do not want to show that value. How can I make that possible? I tried several things like: if datefield.value = #12:00:00 AM# then datefield.value = "" but nothing seems to work, can someone help me? Kind...

Hi All, How can I count records with a by-statement? For example: I want to count all the citizens by city. All fields are part of the table and form. I used dcount, but doesn't seem to work, or I am just to stupid :) . Thanks in advance.

Hi All, I have multiple fields on a form, does anyone know how I can make them unvisible without writing 30 times .visible = false.. Someone told me I could use the tag property. Thanks in advance.

Hi All, I have a problem. When I update a datefield with datefield.value = Null it doesn't empty the field but I receive 30 Dec 1899. Now I know that is the standard voor datefields, but how can I just display an empty field? Thanks in advance.

Hi All, I found out that it is hard to write code for a report. What I want to do is the following: I want a report that is exactly the same as the results showing on a form. Because a Form is not for printing I use a report. On the form I have a checklist wich depends whatever the value of...

Hi All, How can I write a code where a form only prints the PageHeader and not the Formheader (don't know how you call it in english)

Hi All, I made a form with a specific field. If I enter a value into this field it automatically runs a query. The results are shown in another form. However if I return to the previous form and enter the same (or another) value it still runs the query but this time with no results? I think it...