Search results for query: *

Exactly right! I built two queries, both swampboogies way, and my way. My way took about 3 minutes comparing 11,000 records on table A with about 10,000 records on table B. Swampboogie's way took about 2 seconds, if that. I was going to send an email stating that, but got busy fixing my...

Thanks. That got it. After looking at your solution, I was directed to another solution that also gave me the same number of rows using a subquery, using the Access "Not Exist" predicate: SELECT c1 FROM a WHERE Not Exists (select * from b where a.c1 = b.c1); Thanks again. It is...

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

Exactly! Thanks.

Thank you. That worked. Now I have a related problem, going the other way. One field is 25 characters and the other is 50. How do I pad a field to be a total of 25 characters. (I don't know how long the field actually is, but I want to make it exactly 25 characters). I could determine the...

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

Thanks. I remember now. It has been so long since I did a conversion from 97.

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

Thank you so much. It does exactly what I want. The code should find the next incidence of "(", highlight the words between that and the next ")" and italicize them. Works like a charm. Gold star for you. Thanks for taking the time. Matt

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

I never got an answer until your, (7 months later) so I also figured out a "work around" by putting an apostrophy in front of the serial number. I wrote a quick macro for the user to fix the fields after the data is inputted, and before it is exported to Access: For x = 2 To intLimit...

No, this is not really practical. There are 1300 fields in 8 different tables, and about 10 different forms, so there are lots of fields on a form. I guess the best way is to loop through the field collection on the form and look up the field name on the table and pick off the description...

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

Thanks for the try, but neither worked. My guess is that the "field", surounded by the quotes, ends that portion of the statement, and it does not know what to do with the 2nd portion that follows the & sign. I also tried 3, and 4 double quotes, none of which worked. However, here...

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

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

The way I do this, is first do it using a query, and the query builder. Then click on view, and then SQL. That will give you the sql code to create the relationship.

I don't know if you have this solved, but when I open a new instance of Excel from Access, I close it using the following command: objXL.Application.Quit Here is some code that opens a template, runs an Access query (rs), creates a worksheet in the template, populates the worksheet and...

Access 97 and Access 2000 don't co-exist ver well, even when installed in different directories. I have found lots of problems with code not working if I am running 97 and 2000. They're not specific either. Sometimes it is a runtime error, other times it is a query that doesn't get all of the...

Why do you want to &quot;import&quot; it? Perhaps you should just link it. That way, it will stay refreshed and not violate a fundamental principal of data: &quot;Data should not exist in two places at the same time. If they do, they are <guaranteed> to be different.&quot;