Search results

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)

I am using the openargs statement for the form that will be opened code on form1: Private Sub Knop7_Click() If Tekst1 = True Then DoCmd.OpenForm "formulier3", , , , , , Me.Name DoCmd.Close acForm, "formulier1" End If Set RdoRange = Nothing End Sub code on form2: Private Sub Form_open(Cancel...

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

Thanks, I thinks this will help.

Thanks, But the problem is that I want to tell the Open_form event that the rowsource depends if I came from formA or from formB.

Hi All, I have a question: I have 3 forms (a,b,c). Forms A and B are seperate forms and C will be activated by either A or B. The recordsource of C is a query which can be: [forms]![formA]![text1] = Qr1 [forms]![formB]![text2] = Qr2 How can I write a code (or adjust it in the query) that...

Pls don't look so angry!! I have a few comboboxes and I want to be able to reset them to their standard values. (blank). For example, a person who fills in my form realizes at the end that he has chosen the wrong department in the beginning and he wants to start all over again. It is much...

I Understand, but whatif the query you use on the specific field already has a query which does not return the default value?

Hi All, How can I use a button which restores all controls to their default values without adding a new Record? Regards, Martijn.

Hi All, Are there other ways to select multiple items in a combo or listbox? Now you can only select them by making them 'black'. Isn't possible that you can put a checkmark before or after them? That way you will have a better view of what you've just selected. Thanks in advance. Martijn