Recent content by ths

Thanks, Paul. I knew I'd been staring at this too long. That was it, of course. I grabbed what I had tested in the query, and I think when I pasted it might have inserted those spaces? who knows... in any case, huge thanks for spotting that. Tim

Hi, I have a feeling I'm missing something very basic here... grateful for a steer. I have a series of IDs in an 'articles' table stored as text, e.g. hb-123456789-e-068 hb-123456789-e-0069 hb-123456789-e-70 hb-123456789-e-00027 and I'm trying to pull the max value of the number after the...

happened again, but I figured out the problem: there was a record that had an ID but nothing else, and once I removed that record, export numbers matched the db numbers. just in case others search for this issue....

Got it working by combining it with some VBA on the after update event property of another field on the form where records are created. Thanks again! here are the two bits, in case it's useful to others or if it could be improved: modified version of your function: Public Function...

Thanks a lot. glad to know about DCount. I'll give it a shot. I actually only need the integer value, not the concatenated string, but I can modify what you provided. Thanks again.

Hi, I have two tables, Articles and Versions, related 1 to many. In my Versions table I want to set up a field that will start at 0 for the first version record related to an article record, and as version records are added in relation to that same article record I want it to increment by 1...

Thanks, Pat. Appreciate the response, the clarification on the compound key, and the tips. I made the two unmatched queries and unioned them, but I think I might not have explained the situation clearly. There's no issue with the data needing to be cleaned up--from my perspective at least. I...

Hi, I have a table with two fields, articleID and relatedArticleID. They are both primary keys to prevent duplicate combinations of the pair. This is linked, one-to-many, to the articles table. I want to find where a relationship only exists in one direction but not the other. For example...

update: the trusty compact and repair utility appears to have fixed it. It's off now by only 4 records, which I'm attributing to users modifying records. Still unclear why it happened in the first place, which I find unsettling. -Tim

Hi, I have a database with 8 tables, and I need to export each as an XML file. 7 out of 8 XML files export ok. With one table, the XML file only includes 2,613 records, while the table in the database has 27,561 records. Any idea what's causing this? I've exported this table successfully in...