Search results

Good ideas... I did initially put a breakpoint on the TransferText command, as you might expect, but I did not yet try omitting some of the other steps - (like reading in the data etc.), which I'll try next. The only variation in what happens, though, is whether I skip doing anything with the...

OK - tried this on a non-corporate-managed computer - and it does the same thing. I admit I'm quite surprised. Either the other computer has something similarly configured - or this is an actual bug of some kind (whether my code or Access). If I can find time, I'll try to whip up a simple DB...

Got it.

It is the TransferText command. I can indeed display the spec - in the system table, at any time. It exists before, during, and after the code runs.

I understand the general principle of supplying code - but in this case, I just can't see how that matters much. I did describe what I'm doing - using TransferText, with an import spec, inside a loop, that works three times in a loop and then suddenly doesn't. Interesting point on the file size...

I did look at the MSysIMEXSpecs, and it is there. In fact, if I were to restart the system and run it again - it seems it gets through three iterations - using that spec successfully, and then fails. So, it very likely isn't about the spec existing or being referenced properly etc.

In this case - no - I don't have any Resume Next stuff happening, and also no SetWarnings False either (as far as I know... ;-)

Indeed - I will try that today!

Wow - I had done a search but not within this site yet --- and so I didn't happen up on my old post! Yikes... And it was the EXACT same problem... Ugh... Sorry about that... I'd like to supply code, but I'd have to find time to create that, and I may just give up ---- because ---- One extra...

Hi, I have an import specification, that actually works fine both manually and within a VBA loop (executing a DoCmd.TransferText acLinkDelim command) about 3 times around the loop, but then on the 4th round, it suddenly claims the specification doesn't exist. My first thought was that Access...

Just trying to close the loop on some of the comments... I think I updated my comment after your comment --- as I did not have them open at the same time. Indeed that would be a little bit crazy -- ha. I think the issue I've had is probably changing data on the form that is open - perhaps...

Well - I would say that the form I'm working IS the one where the user chooses whether to perform the maintenance or not. It is true that I could probably just put up a YesNo MsgBox, asking for confirmation - but - I wanted to show them the path to the file they recently imported *while* asking...

I think I'm seeing the pros/cons on this. I've really only ever had occasion to use bound forms. I've had occasions to use unbound controls. This just happened to present itself - due to its simplicity - as a case where I *could* choose to make the form unbound, and was just wondering if there...

Indeed - I was thinking only for display purposes... :)

This is a great tool - but it seems to be aimed at external connections. In this case, I'm interested in internal dependencies - so it doesn't seem to show me how a form is 'connected' to a data table, for example. Amazing tool though @isladogs - wow!

I like the idea of knowing where the connections are... that seems to be the piece I'm missing --- will give this a try!

> So - there is a form, bound to a table, and then its sub-form bound to another table. It is the sub-form's table that I'm trying to reset. > Given that I can't even get this to work from an entirely separate form - after the parent and sub-form have been closed - means it isn't about the...

Hmmm - no - but I suppose only because (until now?) it hasn't mattered. Turns out - this problem isn't actually resolved. Interestingly - the first time I open the Start/Calling form, it CAN operate on that other subform's data table. But once I visit that other form/sub-form, THEN it won't...

Good point. > I think I can see why the 1st thing I tried wouldn't work - as it doesn't really let go until you actually leave the form. > I think the 2nd option not working was due to a dumb mistake on my part (--- this is probably the one that made you figure something is really wrong and in...

Typically, when I need Autonumber, I'll create a template table to reset it, since it will inherently increment forever and I don't want to even consider how long that would take to become a problem. Ha. This has worked without issue for a long time. Today, however, I've run into a situation...