Search results

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

Thanks for that idea too. There have only been a couple times in the past where I ended up changing that maxlocksperfile thing. I don’t even remember why. Yes, the GDAL I’m referring to is indeed for processing graphics files (Geotif files - in this case, with topographic/terrain data.) Among...

OK - Thanks all for the info! I will try a reboot tomorrow. And I will try some alternate methods as well. I don't think it can be a syntax issue since the exact same syntax worked - and then didn't work. As far as the distinction between import specs and the so-called "saved" thing - I've...

I've been running some import code successfully for a long while - like hours. This import step/process is being repeated many hundreds of times. (I'm looping through hundreds of files in a folder, pulling data in from them basically.) Suddenly, I see this error 3625, with a misleading message...

Just to follow up in general on this - just in case anyone is trying to achieve this same kind of control over focus - with a split form. I was never able to use the LostFocus with the control of interest - to try to pull focus back to it. Strangely, I WAS able to put the very same logic on the...

I understand the event model sufficiently to get done what I've needed to get done - up to this point. My only criticism of MS is when things that *seem* like they should be easy - they are not. Having said that, I've found the flipside to be true as well - things that we might consider quite...

Interesting. Sounds great. I just can't figure out why it won't fire at all. Seems simple enough - Form, BeforeUpdate, event. How can it not fire when I've created a new row in a table/form? We'll see. Thanks!

It's just a bit frustrating is all. It seems the MS motto should be: "We make the impossible easy, and the easy impossible." I run into this a lot. I've done MUCH more complicated and difficult things in much less time. I've spent WAY more time than should be needed to simply create a new...

Hmmm ---- I need to breathe some of your air apparently...

Well - I've certainly used the GoToRecord successfully before - but today - it is not working. It simply would not work. I didn't type actual code/syntax in there - I was just referring to it in general. My guess is that it may have to do with me using a Split form. I didn't want to mention...

So - for some reason - it doesn't trigger. I have: Private Sub Form_BeforeUpdate(Cancel As Integer) Cancel = (Me.txtDB_Schema = "<Enter Schema Name>") If Cancel <> 0 Then MsgBox "Please enter a name for the new schema.", vbOKOnly, "Input Required" End If End Sub I put...