Recent content by WES9659

Thank for all your help

Hi Cheryl, Thank you so much for your response, however, I feel really ignorant can you tell me where or how I would get to the Docmd.OpenReport function so I can put in the Where statement. Do I do it as a Macro? Thank you so much for your help. Bill

This may seem like a silly question and I may not have all the technical names down so please bear with me. I have created an access 2010 database. From which my main data is store in the table named Primary_Data_Table my main table key is an auto key named ClientId. I than created 4 reports...

Thank you for trying to help me. Ok let me see if I can explain my dilemma. I have attached a zip file of data base so hopefully someone can see what I am doing wrong. Under my forms tab I have created a Navigation Form which allows me to tab thru my other forms. The first tabbed form you...

Does anyone know how to write a macro or queries that I can add to a button to simultaneously add new record to all tabbed forms in my navigation panel? I have 6 forms. I just want one button on first form that would accomplish this task.

Thank you for all your time in explaining this to me :)

Thanks Pat, How would you create it if you did decide to go that route?

Does anyone know if it is possible to place a Button on First Tab of a multi tabbed Navigation form in Access 2010 that can create a new record in each of the tabs simultaneously?

thanks for reply I only number tables to make them easier to find. However, I will remove spaces as far as spelling not sure what you mean there. I will review your link many thanks

thank you for your post I watched video and am more confused. I understand the concept of relationships but am confused more on what I need to name keys so they interact. I am also attaching a .mdb that someone said would be helpful. Once again thanks everyone for all your kindness and help...

Thank you for your reply i will watch video and once again Season greetings

Once again I am calling out for help. I have attached a copy of entire data base I am creating. When you open database the first four tables 1 Basic Demographics 2-Cemetery 3 Veteran Information 4- Personalized Choices are listed. I cannot for the life of me figure out how to connect...

Thanks John, Can I design the reports to look like a printed form?

Thank you for the reply I really appreciate the help have a wonderful holiday season. :)

I am creating a database here at a funeral home I work for. I need to figure out how I can place a birth date in once column than have it calculate the person’s age in another part of the form. Would be ideal if each time the form is open that this relationship between birthday and age would...