Search results

I once wrote a hack for this, as have others, requiring the use of three or four events...to make the prompt appear...then disappear when the Control is entered, etc...then checking, in the Form_Before Event to see if the prompt was still populating the Textbox...if so, setting the Control's...

Glad we could help! Linq ;0)>

It's always been my understanding that input via scanner is treated the same as input via the keyboard...and I'm pretty sure that I seen this used successfully in that manner...but have no scanner to check it with. Linq ;0)>

Under Properties - Other Tab for the Textbox...set the AutoTab Property to Yes. When the last character permitted by the Textbox Control's Input Mask is entered...Focus will move to the next Control in the Form's Tab Order. Linq ;0)>

Does any code execute when the Form is opened by simply clicking on it, in the Nav Pane? In version 2007 and later, when no VBA code executes, the problem is usually that the folder holding the database hasn’t been designated as a "Trusted" location. I assume that this is a new installation of...

That's correct. Linq ;0)>

Hey, guys...you realize that this thread is almost 6 months old?:D Linq ;0)>

I suspect that the reason over 50 members have read your post without answering is that it appears to be a straight EXCEL problem...and this is an ACCESS forum! If it is strictly Excel you need to post it in an Excel forum. If it is an Access problem, you need to post all of your code for this...

Glad we could help! Linq ;0)>

Well, you call the errant Control ReceivedDateTime in one piece of code and ReceivedDateandTime when you're assigning a value to it. ReceivedDateandTime.Text = Now will only work if the control has Focus when you try to assign the Value. Normally you'd only use ReceivedDateandTime.Value...

At a minimum you probably need to post all the pertenent code...at best, sanitize (remove confidential data from a copy of the file) Compact, Zip and attach the file to a post. Linq ;0)>

Doesn't matter...AfterUpdate will not execute using the original code the OP posted. Linq ;0)>

Or you can simply add .Text like this FldRetireDate.Text = DateSerial(Switch(Month(Date) > 4, Year(Date) + 1, True, Year(Date)), 4, 30) and the AfterUpdate will fire! Learned that yeas ago...but don't remember where! Linq ;0)>

Cross-posted and answered extensively at https://www.utteraccess.com/forum/index.php?showtopic=2052951 Linq ;0)>

You have to force the save, as said, but you have to do it before the assignment: If Me.Dirty Then Me.Dirty = False Me.Parent!HeaderTotal=Me.Text22 Linq ;0)>

Glad we could help! Also glad you searched, here, first...before posting a problem! So many people don't bother to! Linq ;0)>

How are you making it Read-Only? Are you talking about clicking the Command Button, once, editing multiple Records, then clicking it again to make it Read-Only once more? Or...going to a Record...clicking the Button to make that Record editable...clicking it again to make it Read-Only...moving...

Aside from your other problem...this statement is kind of troublesome. Is it being used over a WAN? Linq ;0)>

In reviewing his other posts...that's what he always wants! The first half of his user name is most appropriate! Linq ;0)>

Kind of unusual...did you ZIP the file before attempting to attach it? That would depend, would it not, on whether or not the Tabbed Control simply held Controls from the same RecordSource as the Main Form...or whether it held Controls from a Subform on the Tabbed Control. Linq ;0)>