Search results for query: *

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

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

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