Search results for query: *

Hi, I know that in order to provide for an XSL translation, the XML document can have the XSL instruction within the document. ie: <?xml version=&quot;1.0&quot;?> <?xml-stylesheet type=&quot;text/xsl&quot; href=&quot;obs_OEIC.xsl&quot;?> ...Your XML Here... However, I would like to perform...

I was wondering if anyone could tell me why the following code returns nothing to the g_RootNode variable when I include the DT declaration within my XML?? If I don't include the DTDeclaration, I do get the documentElement (<DATAROOT>). The best guess I have is that the parser is unable to...

Hello, A few years back I came across a technique that could determine if you were running the code from within the design environment or it was the actual executable. It uses a few API's. Not much more that I can remember about it besides the fact that I knew it would come in handy. If...

SELECT DISTINCT Datediff('y', #31/08/2002#, myTable.Date_Of_Birth) AS AGE_AS_AT, ... P.S I might have the dates to compare around the wrong way. It's been some time. If this is helpful, please please mark this as helpful.

< [number of units ??] Remember, the LIKE operator is best suited for text fields. It would make no sense to apply this to a numeric field, unless it was postcode or phone number or something like that.

It would create so much ambiguity. Where would it all end? It's this work that keeps programmers employed. In short - NO!

txt1 = left$(mySerialNumber, Len(mySerialNumber) - 8) txt2 = right$(mySerialNumber, 8)

the recordcount property is well renown for being flakey at the best of times. Instead replace the line with: &quot;If RS.eof and rs.bof Then&quot; If this doesn't help, take the value of strResult and paste into a queries SQL statement. This should help no end. also,... After the Do loop...

Encompass this code within a new function: a) Select modules at database window. b) Create a new module c) Type in: Public Function myFunctionName () as boolean Dim sSQL as String sSQL = &quot;INSERT INTO TABLE_2(FIELD_1, FIELD_2, FIELD_3) &quot; sSQL = sSQL & &quot;VALUES('&quot; sSQL =...

You have to include the Powerpoint Object library into your database and program for this. If this is new to you, good luck. It takes a bit of work to do first time out.

You are talking about the 'LIKE' operator. Amend the sequel statement below to: strSQL = &quot;SELECT DISTINCT Locations.ID FROM Locations WHERE ID Is Not Null and (&quot; & Me!cboSelectField & &quot; LIKE '*&quot; & Me!txtSearchText & &quot;*'&quot; & &quot;)&quot; This will return all...

When the user commits the save you need to add this code to the &quot;onClick&quot; event handler: Dim sSQL as String sSQL = &quot;INSERT INTO TABLE_2(FIELD_1, FIELD_2, FIELD_3) &quot; sSQL = sSQL & &quot;VALUES('&quot; sSQL = sSQL & ME.txtField_1 & &quot;','&quot; sSQL = sSQL & ME.txtField_2...

Assuming that the form is not bound to the data source (table/query) then the field where the claim number resides would have the control source set to =DMAX([ClAIM_NUMBER], [Your_table_name_here]) + 1 Write the claim number when the user commits the record to the database. WARNING: this...

Within the code window select the TOOLS menu then REFERENCES menu options. Check to see if any dll files are stated as missing. If not then take note of the file location. For example, the &quot;Visual Basic for Applications&quot; file is located in the c:\Program Files\blah blah...

UPDATE tblR1_Data, tblTerm SET tblR1_Data.AUTUMN = [HRWEEK]* IIf(([BEGD] Between [dtmTerm1_Start] And [dtmTerm1_End]), IIf(([EEND]<=[dtmTerm1_End]), DateDiff(&quot;ww&quot;,[BEGD],[EEND]), DateDiff(&quot;ww&quot;,[BEGD],[dtmTerm1_End]) ), 0); If the course's duration is solely...

Actually in answer to your question... YES! it can be done. If you're a great lover of Star Trek, the crew always would ask Spock how to find something in a huge place. Quite logically, he would reply, by finding out where it isn't. To get an acturate account you need to investigate using sub...

I beg your pardon, there are only twelve rules. Codd's rules for referental database design are very calculated (he proved you could design a database with calculus, smart guy!) and some of them seem unreasonable (in a business/financial sense). You'd be hard pressed to find any DBMS on the...

NG, To paraphrase, your delete statement doesn't work your insert statemnet does your lprimarykey variable is obtaining the correct unique identifier and you your primarykey was a string and therefore lPrimaryKey should now be called sPrimaryKey. If you have given me your SQL statement...

Nice one Terry. Sorry if I didn't make that clear in the previous message cyork.

What are you trying to do? The column positions in a table a just logical ordinal positions. Does it really matter where they sit? I'd imagine it is for display purposes, so In SQL statements, it depends on which order the fields are selected in. For the actual table, open it in design view...