Search results

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.

You could probably use a subform for it or use something like this. https://thedbguy.blogspot.com/2021/08/simplecsv-v20.html?m=1 Sent from phone...

Don't you get a list by simply double clicking on the attachment field? Sent from phone...

Hi. Welcome to AWF!

Try adding a PARAMETERS declaration on top of your SQL statement. Sent from phone...

Hi. Welcome to AWF!

To view a report and not print, I think you could use either acViewPreview or acPreview.

Hi. Welcome to AWF!

If you stick with data macros, I don't think there is a way to do what you're asking. In any case, even if there was a way to do that, I am not sure how it would apply to your situation. It looks like your macro checks if a field is updated and then logs the new value in the audit table. So, if...

Have you tried right-clicking on the column name?

Is that a screenshot from SSMS? Or Access?