Search results

YohoJones, You may have a form property set to only display the current record or have not allowed updates or some such. Without knowing what you have directed to wizard to do and what version of Access you are using it is hard to give you better answer. Could you possibly post a zip copy of...

Thanks for the feed back. I'll let you know how it turns out.

Pat and Jon have the right idea. Each of your three queries must contain a unique value. It appears that the Event ID is unique to each of these instances. So if you have the Event ID displayed in each of the three queries, you can then join them based on that value. Donna

Hello, Thnks in advance for your assistance. I have attached a sample database with a table containing a sample of the data I want to manipulate. I have data in a table that reports details for each line of a claim as a seperate line. I need to bring the Diagnosis code for each claim line in...

This is the code that was used in one of our databases here at work. Don't know if it will help or make things worse. _______________________________________________ Option Compare Database Option Explicit '********Code Start************** 'This code was originally written by Terry Kreft '...

Thanks for the feedback. One of the things I was taught when I was first learning Access was to do the repair and then the compact. This may have been a habit or whatever of the person who taught me, but I've always been curious as to why. I am interested in learning exactly what is done by...

I have read in a few journals about not using the Repair Function in Access 97 unless prompted to do so. What I cannot find is the rational. Can anyone tell me why it is not a good idea to run the Repair on a reqular basis?