Search results

Take a look at this one. https://www.access-programmers.co.uk/forums/threads/scan-muli-page-document-in-access-database.246348/page-2#post-1317909

Hi. Welcome to AWF? What kind of examples are you looking for? Didn't you already get an example from the second post? Are you looking for a tutorial or a link to a video? Or, are you asking for an Access database that does the document scanning? If you don't know how to code, there is a way...

Oops, forgot about that. 😆

If you still need help, consider posting a sample db showing the problem. Do those "valid" fields happen to be lookup fields as well?

On which line?

What is the "scheme?" Do they get a point every time they log in? So, if they log in and then log out and then log in again, they get more points?

Hi. Welcome to AWF! As you may know, an MVF column is not the same as a simple text column, so searching within an MVF would need special handling. I believe what you want to achieve is possible, but if you can avoid using MVFs, then your job would become easier. To help you with your current...

Sorry, No. The Value property is usually updated only once the focus leaves the control. PS. I don't use UserForms in Access. You might give it a try and maybe it behaves differently than regular forms.

Access has UserForms as well.

If you don't want to use a textbox, you could try using TempVars.

Which line is giving you the error?

Hi. Welcome to AWF! You might consider starting a new thread in a more appropriate forum.

Hi. Welcome to AWF!

One thing you could try is add error handlers to your code, if you don't have any. ACCDEs usually just quits silently during an error, if you don't have a handler to let you know it happened. So, you may be missing something when the ACCDE version doesn't work.

Ah okay, like I said earlier, my quick test didn't add any new items to the list, but the dropdown didn't show up, so there's no need to use Esc.

Well, when I said I did a quick test earlier, I didn't actually add to the list and found out that the dropdown doesn't show by using acDataErrAdded (without actually adding data). I didn't understand your requirement, so I made the demo that way, but you should be able to adapt it. If you want...

Easier to show you. Try the attached.

You did say "modal," but I don't see you using the acDialog argument in your code. Perhaps you can review the following info: https://thedbguy.blogspot.com/2016/02/pop-up-modal-or-dialog-forms.html

Hi. I did a quick test, and it seems to me that acDataErrContinue will open the dropdown and acDataErrAdded will keep it closed. Just a thought...

Glad to hear you got it sorted out. Good luck with your project.