Recent content by JB83

Dear reader(s), I have a "problem" with creating / using filters. There is a form with a few subforms, and in those subforms are data fields. The subforms are linked with the main form. When I filter the data in the main form, the filtering succeeds. But when I want to filter the data...

krispi, thank you for your reply. I know what you are saying, but what I would like to know is why. Is it a linking problem, or can't it be updatable at the same time and it there a solution for it? -------------------------------------------------------------------------------- It never hurts...

Dear reader(s), I have a problem with subforms. When I want to set the view property of a SUBform in a SUBform to continuous forms it says: "A form with a subform can't have it's DefaultView property set to Continuous Forms. You tried to add a subform to a form in Design View. Microsoft...

Thank you for your reply. I already have found a solution myself. Keep up the good work! [2thumbsup] -------------------------------------------------------------------------------- It never hurts to help and it never helps to hurt.

Thanks for all the help, but I found a solution myself. Keep up the good work! [2thumbsup] -------------------------------------------------------------------------------- It never hurts to help and it never helps to hurt.

Dear reader(s), I have a problem with DoCmd.RunSQL: when I want to add a record in a table with a WHERE-clause I get a syntax error, and I don't know how to solve the problem. DoCmd.RunSQL ("INSERT INTO [tblReasons] (Reason1, Reason2, Reason3, Reason4, Reason5, Reason6) SELECT " &...

Dear reader(s), I have a problem with DoCmd.RunSQL: when I want to add a record in a table with a WHERE-clause I get a syntax error, and I don't know how to solve the problem. DoCmd.RunSQL ("INSERT INTO [tblReasons] (Reason1, Reason2, Reason3, Reason4, Reason5, Reason6) SELECT " &...

Dear reader(s), I have a problem with a report: I would like to strikethrough (with a line) a value on a report. I have already tried to use an if-statement with the Visible-property and temporary values of the DLookup values to get the line on the screen. The problem is that the DLookup...

Dear reader(s), I have a problem with a report: I would like to strikethrough (with a line) a value on a report. I have already tried to use an if-statement with the Visible-property and temporary values of the DLookup values to get the line on the screen. The problem is that the DLookup...

Dear reader(s), I have a problem with a report: I would like to strikethrough (with a line) a value on a report. I have already tried to use an if-statement with the Visible-property and temporary values of the DLookup values to get the line on the screen. The problem is that the DLookup...

KevCon, Great information on printing reports, this is what I needed ... :) Thanks for sharing! Jochen. -------------------------------------------------------------------------------- It never hurts to help and it never helps to hurt.

Guys, thank you for your replies! I already found an answer in this thread: thread181-427408 up the good work! Jochen. -------------------------------------------------------------------------------- It never hurts to help and it never helps to hurt.

Bill, Thank you for your incredible fast respond! I have tried your code and it almost worked: the variables ln1ProdGroup and ln2ProdGroup should be between quotes, otherwise Access can't find the variable. It is not critism on you, but there might be another member who can also use this code...

Dear reader(s), I apologise for the title of this thread, but I couldn't define it different. My problem is that I want to use a variable which has to be "variable". Dim tempProdGroup As Variant tempProdGroup = Report_ProdForm.lstProdGroup.ListCount For prodGroupCtr = 0 To...

Dear reader(s), I apologise for the title of this thread, but I couldn't define it different. My problem is that I want to use a variable which has to be "variable". Dim tempProdGroup As Variant tempProdGroup = Report_ProdForm.lstProdGroup.ListCount For prodGroupCtr = 0 To...