Search results

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

I had no idea! Wow. OK - well - I guess my delay loops are merited then. Thanks!

That looks like a very nice resource. If I get in such a bind in the future, I'll be looking at that! thanks!

Wow - your answers are always spot on - and fully complete. Amazing... I've found that, in this particular case, including a delay before one of the instances that writes out to the log was both effective and even necessary. Interestingly - inserting DoEvents in various places did not force it...

I was happy to find this post - as I've run into a bit of a problem with sorting some items in an event log by date/time. It has three items in the table with the exact same date/time. In my estimation, this cannot be possible as the code is running and outputting these things along the way. It...

Funny thing - about all the "plumbing" needed for unbound. It reminds of when I tried to build a web page (years ago) - after only ever having worked in Access. Wow did I take that plumbing for granted! Trying to present a simple form on a web page that walks the user through a series of records...

Indeed... As - I've tried - and I usually end up abandoning all hope... :oops:

Thank you all for your advice and insights! I definitely concur with the general principle that Access offers tons of built-in features with bound forms, and honestly - I can think of only a handful of times over many years that I may have not used a bound form! (Unbound controls, I've had more...

You probably already know this - but - if you also want to have control over exactly how the date appears - you could use the Format() command along with those Date functions to yield very specific results. (If you needed YYYY-MM-DD for example, you could use: Format(Date(),"YYYY-MM-DD"), that...

I've pretty much always used bound forms, and have only rarely needed to do otherwise. But, while looking at one of my very simple forms recently, it occurred to me that I wouldn't have to use a bound form to show this one particular piece of data. I could, instead, use a function (that I wrote...

Just wanted to follow up on this a bit. Upon rebooting, and adding some code to clear recordsets everywhere possible, it did successfully finish - although it only had roughly 550 files to go. When the problem first occurred, I think it had reached somewhere around 1800 files processed. So, I'm...