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

    XML Schema help

    hey thanks...I finally got back to this and worked it out...i removed one of each: </xs:element> & </xs:sequence> ...after the "Service" bit and it worked great...thanks!!
  2. sirrahhc

    XML Schema help

    i guess I cannot attach...here is the schema... <?xml version="3.0" standalone="no"?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema"> <xs:annotation> <xs:appinfo> <sql:relationship name="VenPlace" parent="Vendor"...
  3. sirrahhc

    XML Schema help

    Hey guys whats up??...I am working on a schema to map in xml files to SQL tables. I have a VB script that loads the files into a DB based off of the schema. The tables loaded are Vendor, Placement, Patient, Facility, Summary and Comment. I had the schema working and loading nicely but I missed 1...
  4. sirrahhc

    Select From multiple comoboxes

    ok, that must be the problem then because i am using vb code within access. sorry bout the confusion, i'll post it in an access forum. thx guys
  5. sirrahhc

    Select From multiple comoboxes

    i changed glasgow's code to cbZip(cbZip.ListIndex) i just took out the List that it did not like and now i'm getting the same Setfocus error on line: If Len(cbZip.Text) + Len(cbSic.Text) + Len(cbRegion.Text) + Len(cbType.Text) + Len(cbDay.Text) > 0 Then
  6. sirrahhc

    Select From multiple comoboxes

    i tried sticking in the spaces for the WHERE clause and am still getting the same error. i also tried the snippet glasgow submitted and now am getting another error it is saying that the data member for cbZip.List(cbZip.ListIndex) cannot be found, with the emphasis on the cbZip.List
  7. sirrahhc

    Select From multiple comoboxes

    i'm getting the error on: If Len(cbZip.Text) + Len(cbSic.Text) + Len(cbRegion.Text) + Len(cbType.Text) + Len(cbDay.Text) > 0 Then i'm about to try the code glasgow suggested, thx, i'll let u know what happens.
  8. sirrahhc

    Select From multiple comoboxes

    hey guys thanks for all ur help. i wanted to ask if i posted this in the wrong forum. i read the FAQ222-2244 but couldn't figure what i did wrong. i put the code in my program but am getting an error: "Cant reference a property or method for a control unless the control has the focus" i...
  9. sirrahhc

    Select From multiple comoboxes

    hey everybody, i'm developing a database and on several forms I have multiple combo boxes. i want a user to choose from the 5 combo boxes and then pull a report based on those combo boxes. The 5 combo boxes are: cbZip, cbDay, cbSic, cbRegion, & cbType. If a user just wants to see a report by...

Part and Inventory Search

Back
Top