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!!
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"...
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...
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
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
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.