Recent content by clarkcovey

Thank you again MajP!! This gave me a big push in the right direction and with a few minor revisions, it is now working like a charm! The two changes I made were regarding the file path/name and the data source for populating the form. When our claim system generates a document from a...

Thank you MajP! I will add this and let you know how it turns out.

The_Doc_Man, Thank you for your suggestion. If the user has just one doc opened at the time, I can see how that might work, especially since there is usually just one grid per letter. I'll explore this.

MajP, Here is a sample letter. There are approximately 12-15 different letters with payment grids and the rows per grid varies between them. Some may have 3-4 rows, whereas others could have up to 11 rows.

Thank you for your response MajP; however, the Word templates are generated from a completely different system and I cannot add code to them to read from Access or any other source. Regarding Access writing to Word, would it matter if the Word document has several paragraphs of other...

Our computer system has a variety of Word templates with prompts for currency values to be entered one at a time to populate a grid within the letter. The users have been using an Excel spreadsheet to calculate the values and then selected the group of cells and pasted them into the Word...

I needed this as well, setting values on checkboxes representing each US state and each US territory. Thanks!

Welcome Donna! You will find a vast amount of help on this board. I use it frequently.

Welcome aboard Penny! I'm sure there are things we can learn from you as well. :)

Welcome! Visiting Scotland is on my bucket list. If my memory serves me correctly, my grandmother researched family history and part of my heritage is from Scotland.

Perhaps one of the issues at stake is much less acceptance of personal responsibility by too many people. When behavior is being excused or justified by pointing blame at one's parents, job, traffic, computer games, media, fast food, alignment of stars, Hollywood, the taste of coffee on Tuesday...

You will need to reference the subform, in your case, "frmNavigationSubform" and specify the source with "SourceObject." Private Sub Command50_Click() [Forms]![Home]!NavigationButton3.NavigationTargetName = "2" DoCmd.close Forms![Home]!frmNavigationSubform.SourceObject = "2" End Sub

During the process of developing another (initially unrelated) application, I was able to extract the users' login from Windows and build accessibility into different form functions. When I complete the new application, I'll revisit this one and add that functionality. Thank you for the...

Tamang, What are the results of your recordset when you run it? Are you receiving any type of error message? You can set a breakpoint at your "Set rs = ..." and step through the code, checking the results as you progress. One thing you may want to add after your "Set rs = ..." command...

Hello Mark, Let me start with my disclaimer: I am no expert. :) Usually, when I start a project, I find it helpful to draw out a bubble chart with the work flow and see if any data is being used in multiple areas and so to avoid redundancy, I may separate that into separate tables. You...