Recent content by sofie

I would like to calculate with a form. In my current form I fill in several fields. When evertything is filled in, I click oon a button. This button have to calculate the eprice. The price depends on the fields who were filled in. In an other form, I mention wich field is wich price. Do I have...

Hi, I would like to click on the button and previeuw the speccific record, to print out. What am I doing wrong? Thanx Private Sub cmdPreview_Click() On Error GoTo Err_cmdPreview_Click Dim stDocName As String stDocName = "rptFormA" DoCmd.OpenReport stDocName, acPreview...

If I click on "cmd_edit" I would like to receive the information of 1 client of the frmKlantenfiche. With the following code, he gives me an error in : DoCmd.OpenForm "frmKlantenfiche", , , strSQL What do I have to do, or what am I doing wrong? Private Sub cmdEdit_Click() Dim Db As...

I thougt this was the code, to enable a button, when there is no previous or next button. But it doesn't work. Who can help me? Private Sub Form_current() If IsNull(Me.Code) Then cmdPrevious.SetFocus cmdNext.Enabled = False Else cmdNext.Enabled = True End If End Sub

I thougt this was the code, to enable a button, when there is no previous or next button. But it doesn't work. Who can help me? Private Sub Form_current() If IsNull(Me.Code) Then cmdPrevious.SetFocus cmdNext.Enabled = False Else cmdNext.Enabled = True End If End Sub

Who can help me??? I made a querry of several tables, and now I want to make a form of this querry. But when I made it, the form is blanck. How come it? Sofie

Hi, I would like to know what I am doing wrong. Private Sub cmdSearchKeyword_Click() On Error GoTo Err_cmdSearchKeyword_click Me.Filter = omschrijving = [Which category are you searching for? Me.FilterOn = True Omschrijving.SetFocus Exit_cmdSearchKeyword_click: Exit Sub...

Hi, I would like to know what I am doing wrong. Private Sub cmdSearchKeyword_Click() On Error GoTo Err_cmdSearchKeyword_click Me.Filter = "omschrijving = [Which category are you searching for?]" Me.FilterOn = True Omschrijving.SetFocus Exit_cmdSearchKeyword_click: Exit Sub...

I tried your repley, but my computer says it is wrong. Private Sub cmdSearchClient_Click() DoCmd.OpenForm "frmKlantenfiche", acNormal Forms!Products.Filter = "naam_kl = [Which Client are you searching for?]" Forms!frmKlantenfiche.FilterOn = True Forms!frmKlantenfiche!Naam_kl.SetFocus End Sub...

I made a querry from several tables. And now I would make a form of this querry, but the content is not visible. What do I have to do? Who can help me? Or can I make a form from several table? How di I have to do that? Thanx Sofie

This is already very good, but if I want to do this in an other form, and go to the specific form, what have I to do? Can you help me? If the command button is on the same form, you can try this Me.Filter = "naam_kl = [Which Client are you searching for?]" Me.FilterOn = True naam_kl.SetFocus

When I click on the command button, I recieve an inputbox. There I fill in the name of my client. Then when I put on Ok, I would like to recieve only the record of the client. I tried olready, but I always recieve all the information of all the clients. What am I doing wrong? Who can help me...