Search results for query: *

Thanks for the tip. It works. There is another page dd.aspx which links to cc.aspx. Is there any way to know which way it comes down since there are 2 paths: aa -> cc -> dd bb -> cc -> dd The data shown on aa and bb pages are from 2 different db tables. The only data I can seen from dd...

I have 2 pages aa.aspx and bb.aspx and both link to the 3rd page cc.aspx. There is a return button on the cc.aspx. How to control which page to be returned after the Return button is clicked I have defined invisible lables lblCalledFrom.Text = 1 on page aa.aspx and calledFrom.Text = 2 on...

I am new on UNIX script programming. Here is my question, please help. 1) check if a file exists, if not, create a new file if [ ! -f "$MINENV_RUN/work/$I" ] - it works then touch $MINENV_RUN/work/$I 2) add a string into the file string entered: "aaa, bbb, ccc, ddd" How can I add the...

Please anyone help me on creating a new output file using xsl:document. I found the following example from book "XSLT 2nd Edition Programmer's Reference" poem.xml ======== <poem> <author>Rupert Brooke</author> <date>1912</date> <title>Song</title> <stanza> <line>And suddenly the wind comes...

Thanks for the big help. It works well. chrislx

There are several schema files, one schema file includes several other schema files. For example, <xs:include schemaLocation="C:\myCodes.xsd"/>. I would like to transform the schema files into a xml file. Question: How can I use xslt to get the nodes and attributes which are in the included...

I need to convert a .xsd file to .xml file using xslt. Thanks for any suggestion. I have trouble on finding the right xpath. I used the following for loop: ... <xsl:for-each select="xs:simpleType"> ... </xsl:for-each> ... It does not work. Here is thexsd file: <?xml version="1.0"...

Please help on the following: There is a field on a table. The data type of the field was defined as Yes/No (It is shown on form as check box). Then converted to .xml file using Ms access (export the table and saved with .xml). The values of the field is either 1 or 0 in xml file. If the...

Thanks. It helps! chrislx

Please help me on the followings: What is the difference from 1). Dim rs as Object And 2). Dim rs as DAO.Recordset ? When either one should be used? rs = Me.Recordset.Clone rs = Me.RecordsetClone What is the difference from the followings and when one should be used? 1)...

I have trouble to find out a solution on the following, Please help. 1. Form-1 includes Combo box, Text fields, subforms and buttons (Create, Delete) 2. After selecting a key code from the combo box ([Form-1].[Input-Name]), display the details in TextFields (table-1) and subforms (other...

I need to change the string, such as "it is an access form" , into "ItIsAnAccessForm". Remove the space and display upper cass for the first char of each word. The following code remove the space, but cannot change from lower case to upper case. does anyone has good idea for the case change...

Good catch! Thanks a lot. chrislx

I try to update one of field of a record in a table. It does not conplain anything after running the following Sub. But the problem is that the record is not updated. Can you please help me on this? Table: TBL-1 Fields: Class-Name (Key), Attribute-Name(key), Code-List-Name (non-key) Here is...

Thanks. It works well.

Please help me on the following: The value shown in a field of a subform is bounded with a table column (not primary key). After the value is changed, for example, from "AAA" to "BBB", I need to give a warning message for the difference of the two strings. Which event should be used here to...

I am trying to create a Query. The followings are the code. I have got an error "Type mismatch" on "Set rs = qdf.OpenRecordset(dbOpenDynaset) I am not sure what is wrong? Appreciate any hints. ========== Code =============== Dim db As Database Dim rs As Recordset Dim qdf As...

Thank you for your replys. The tbl-2 is the subset of tbl-1 and both including field-1 which is the primary key of tbl-1. I want to select all of the records which is in tbl-1 and not in tbl-2 and insert them to tbl-3. I have trouble to read the data in recordset by using Do Until loop. for...

Hi, I want to retrieve data from two tables, tbl-1 and tbl-2. I wonder how to make it work using recordset. Should I have 2 recordsets opened? How to set the sqlCriteria? Here is the sql selection: SELECT tbl-1.field-1 FROM tbl-1 WHERE tbl-1.field-1 Not In (Select tbl-2.field-1 from tbl-2)...

Thanks. It works. chrislx