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 bkrike 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: *

  • Users: SetBuilder
  • Content: Threads
  • Order by date
  1. SetBuilder

    Showing unmatched records using a query

    How do I write a query in Access that will show what records are on table "A" and not on table "B"? For example: Table A Table B 1 2 2 3 3 4 4 5...
  2. SetBuilder

    Strip trailing blanks in a field

    I have 2 tables (Bill of Materials) in Access. Field1 in TableA is 50 characters long, Field1 in TableB is 25 characters long. I am trying to match field1 in tableA to field1 in tableB. If I use the ADOX command .find, I can't get a match. They do match if I use a query, but I am trying to...
  3. SetBuilder

    Access 97 to Access 2k and querydefs

    Is there some issue I should be aware of when converting Access 97 databases to Access 2k or XP that have querydefs? I am getting an error in the conversion that says "user defined type not defined" Thanks
  4. SetBuilder

    select words between two points

    In, VB, how can I select a variable number of words between two points. What I want to do is select the parenthesis and everything in between in order to italizize it. So, (the quick brown fox) becomes (the quick brown fox) italized. I know how to search for the the first "(" and...
  5. SetBuilder

    Updating status bar text from underlying table

    I have a form that has a bunch of fields on it. When it was originally created, there was no value in the underlying table's "Field description" property. Now there is. Is there a way to programatically update each field on the form without looping through the field collection on...
  6. SetBuilder

    How can I name a field using a string in ADOX Table Create

    I want to create a table with, say 99 fields. I don't know how many fields, but it will vary with the table I am creating. Field names are not important in this instance, so I want to name them "Field01" "Field02" ... "Field99" etc. (ADOX format:) I tried this...
  7. SetBuilder

    Text Import from Excel comes in as scientific notation

    When I use the transferspreadsheet command to import an Excel spreadsheet, one of the text fields (Course-ID) comes in as a scientific notated field. For example, 20012911 comes in as 2.001291+07. when I convert that back to a string, as: strCourseID = str(vFieldIn1) I get: 20012900, loosing...

Part and Inventory Search

Back
Top