Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Dodgey

    Silly question really...XSL Translation

    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...
    • Dodgey
    • Thread
    • Replies: 1
    • Forum: XML
  2. Dodgey

    XMLDocument.DocType returns nothing???

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

    Determine if running within VB3 design environment

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

    Help!! I need to write a query whi

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

    Less than criteria

    < [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.
  6. Dodgey

    Selecting Fields ending in a certain as a query

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

    Autotab while writing

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

    How to insert a wildcard parameter into VBA code

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

    Pull data from one table to form, and save to another?

    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 =...
  10. Dodgey

    Using VBA in Access to get Data From MS Project

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

    How to insert a wildcard parameter into VBA code

    ...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 instances where the field contains '4089'. Alternatively, you...
  12. Dodgey

    Pull data from one table to form, and save to another?

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

    Use last ClaimNum plus 1 in form field

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

    Pop Up Form Error - Chr(34)

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

    Help in translating a criteria from a query!!

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

    Help w/ difficult foreign key query

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

    Help w/ difficult foreign key query

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

    Move selection from one list box to another

    ...a numeric data type the value did not need to be enclosed in quotes. Since your primarykey is a string data type you need to encapsulate the variable within a string DoCmd.RunSQL &quot;DELETE * FROM Bridges WHERE Bridges.IDNumber = '&quot; & sPrimaryKey & &quot;';&quot; Better luck this time.
  19. Dodgey

    Change the order of columns in a table (VBA)

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

    Change the order of columns in a table (VBA)

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

Part and Inventory Search

Back
Top