Search results for query: *

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

Michael, I have already used a comparable function of this FAQ in MS Access which is called dhCountWorkdaysA. I have renamed the function to Networkdays to see if Excel would get it, but Excel didn't. You mentioned a port to Excel: Is there a possibility to port this function in Excel...

I'll try that later, thanks for your respond! Jochen. -------------------------------------------------------------------------------- It never hurts to help and it never helps to hurt.

Michael, I have done the following: at first I have created a module within Access to calculate the workdays (without holidays and weekends) because there isn't any function which can calculate this (Excel has a function called Networkdays, but it cannot be used in Access). When I want to...

Mp9, thank you for your fast respond! It is not exactly what I wanted, but it is the best property for locking the combobox. This is not your fault of not understanding me correctly (which you did) , but the limit of property adjustments in VB itself. I actually would like that the combobox...

Dear reader(s), I have a problem with Access 2000 / Excel 2000. When I create a PivotTable for a database (which is created in Access 2000), it gives the following error when I select my tables to put into the PivotTable: "Undefined function 'nameOfFunction' in expression". I have...