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

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

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

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

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

Dear reader(s), I have generally a problem with comboboxes: the comboboxes must be non-editable, but there has to be a possibility to select a value and add it into the database. I have already searched for special variables which might could do this, but nothing found. Is there a solution for...

Dear reader(s), I have (again) a problem with a DLookup value. I would like to paste the retrieved value into another table. My question is: can this be done with a normal insert query or has this to be done with a special command? Thanks in advance, Jochen...

Dear reader(s), I have a problem with 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 made a module in...

Dear reader(s), I have a problem with a DLookup value. I would like to use the value of a DLookup value to create a new record into another table. Is it true that if there is no control source for a DLookup value it cannot be given to another variable and if yes, how can this problem be solved...

Dear reader(s), I have a problem with a DLookup value. I would like to use the value of a DLookup value to create a new record into another table. Is it true that if there is no control source for a DLookup value it cannot be given to another variable and if yes, how can this problem be solved...

Dear reader(s), I have a problem with inserting values / records from one table to another table. The situation: --- PRODUCTNR -- ¦ ____________ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ProdNr ¦_¦___ N ¦ ¦____________¦ ¦ | ¦ ------------ ¦ | ¦ ¦ ProdNr1 ¦ ¦ | ¦ ------------ ¦ | ¦ ¦...

Dear reader(s), It looks like a very simple thing to solve, but I haven't seen a lightbulb yet :) I have a SQL / database problem in MS Access 2000: I don't know how to select data from 2 columns which are in the same table and put them into a combobox which shows data of these two columns...

Dear reader(s), I have a problem with my Microsoft Access database: I cannot use data from a subform which has to be used for another query. I will try to explain my situation as clear as possible. Tables I have two tables: "ecprod" and "product". "ecprod&quot...

Dear reader(s), I have a problem with my Microsoft Access database: I cannot use data from a subform which has to be used for another query. I will try to explain my situation as clear as possible. Tables: I have two tables: "ecprod" and "product". "ecprod&quot...

Dear reader(s), I have a problem with my Microsoft Access database: I cannot use data from a subform which has to be used for another query. I will try to explain my situation as clear as possible. TABLES: I have two tables: "ecprod" and "product". "ecprod&quot...