Search results for query: *

Hello, I am looking for a Java component that makes it possible to draw charts (pie, bar, gantt, line ... charts) and include them in JSP pages. So far I have found "Cewolf" http://cewolf.sourceforge.net/ Do you know any better component or just any other component? Thanks a lot, Alex

Hello, Could someone help me to optimize a simple function (well, the function's logic is simple, but the optimization might not be simple to find) Suppose you have - a table "tblMyTable", with a field called "field1". - a function to apply to this field. That is, I want to...

Hello, I have a form that contains among other things a label whose caption changes according to what the user does. (ie: when it is necessary, I update the label's caption with the command: me.lblMyLabel.caption = "qwerty") When I close the form and open it again, the label is...

Hello, I have a tab control in a form, with several pages (tabs). Is it possible to make a tab not clickable (and grey)? "pageName.enable = FALSE" still allows the user to click on the tab (but the commands inside are disabled) Thanks Alex

Hello, I have a tab control in a form, with several pages (tabs). Is it possible to make a tab not clickable (and grey)? "pageName.enable = FALSE" still allows the user to click on the tab (but the commands inside are disabled) Thanks Alex

Hello, I have found a thread about using transactions to save data inserted in a form that contains a subform but I could not make the code work. So here is my problem: I have a form "frmTest" bound to the table "tblTests" and a subform "sfrmSteps" bound to the...

Hello ! I have written this query in the SQL view part of Access 2000's query editor: SELECT IDTester, toBeTested FROM tblTests INNER JOIN tblScenariosAndDescriptions ON (tblTests.IDFunction = tblScenariosAndDescriptions.IDFunction) and it perfectly works (IDTester is a field from tblTests and...

Hello ! I have a list box whose rowsource is defined by a query. Something like: Me.lstMyListBox.rowsource = "SELECT ... FROM ... WHERE" Is there a way to know whether my list box is empty (ie: whether the query "SELECT ... FROM ... WHERE" is empty ?) Thanks Alex

Hello, Does anybody know how to merge two reports ? That is: I have two reports and I would like to put them into one, just one after the other. Thanks Alex

Hello ! getParameter(x) is a function that gives a table's name. I want to write a query like: SELECT * FROM getParameter(1) but it does not work. Could anybody help me ? thanks Alex

Hello ! I have two tables, table1 and table2 and want to substract the 2 sets of data. (select table1.field1, table1.field2 from table1) minus (select table2.field1, table2.field2 from table2) does not work. I get a message error: "syntax error in union query" Could anybody help...

Hello ! Does anybody know how to clear a field in a form and set its value to NULL ? " txtFieldName.value = NULL " does not clear the field, but it seems to set its value to null. Thanks Alex

Hello, I have a form whose control source is a table (the form is used to insert data in the table). Suppose I want to oblige the user of the form to insert data in the field "txtName" (that is: the user cannot go to the next record or exit the form if txtName is null). What can I do...

Hello, I have two text fields in a form: txtDate1 and txtDate2, and they are supposed to contain dates (I have put a mask like **/**/**** for dates). But I cannot compare txtDate1 and txtDate2 correctly. The expresion (me.txtDate1 > me.txtDate2) still compares 2 strings an not 2 dates. What can...

Hello ! I have a problem with VBA for Access. Suppose you have a table "tblEmployees" that has two fields: "Name" and "Position". Does anybody know how to get the position of the employee called "smith" and put it in the VBA variable defined as: Dim...