Search results

Ah. My apologies for providing an incomplete solution. I have never created macros, and the only thing I have done with the ones I found was to convert them to VBA. If the NotInList event is handled in code, there are two variables that go with it: NewData, which is the input that triggered...

It can happen to us all. I am glad it is working well. :)

We should address your second question first, with a mind toward your first question. :) Set fkUMRNAdmission in tblAdmissions to lookup pkUMRN in tblPatients. Make sure the bound column is pkUMRN, and set Limit to List = Yes. Create an autolookup query by using fkUMRNAdmission from...

Using your description, I created a test sample. In the Edit Relation dialog, the Locale table was on the left (the one side), and the Contacts table was on the right (the many side). It worked as desired. Are you certain of your table structure?

Oh, but Access can be very exciting. Whether it is the process of creation or the challenge of solving a tricky puzzle. Also, helping/teaching other people is good for the teacher as well as the student. Sharing just makes people feel good. :D

There are plenty of things to do wherever you go. The questions are, 'What do you like to do?' and 'When will you have time to do them?'

It's nice to see a listing of lessons I learned the hard way. I wish I had this list when I started working with Access. lol

A Bing search of 'ransomware fake fbi' brings up several links that discuss the Reveton virus and how to address it.

That ransomware showed up on my dad's computer a few weeks ago. I rebooted it in safe mode and rolled it back to a recent restore point. I then rebooted it normally, and all seemed as it should be. As a precaution, I updated virus definitions and ran scans with antivirus and antimalware...

This forum is a good example. I hit F1 to look up some info, and I am routed here instead of looking at a table of prefixes. lol

I'm an Access 2000 developer who has finally moved up to 2010. I am trying very hard to NOT curse Microsoft everytime I cannot find a familiar function in their *ribbon*. :banghead: