Search results

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...

Currently, I have a navigation form with buttons on the top and left. One of the buttons on the top has approximately 15 corresponding buttons on the left. Each of the corresponding forms need to be processed in sequence. I was asked to add a "Next" and "Previous" button to each screen as...

You have a point. I was assuming people would do the right thing... silly me! I've removed that section and will build a separate and different form with access privileges.

(Trying this reply for the 4th time...the submit button on the reply with quote doesn't seem to work properly) If the search results return a number that is perhaps only one digit or character off, the user will open the necessary documents (digital photographs of manufacturer data plates) and...

Hello, I am trying to create a (normally simple) application, but not having a solid grasp on the concepts of recordsets, I find myself floundering. :banghead: The application is serial number tracking for appliances. The functionality needs to be able to: Search for serial numbers...

Good afternoon, Many years ago (80's), I received my BS in Comp Sci and focused on database applications using DB3 & 4 and Foxpro. However, I did not continue developing my knowledge on various packages. I did explore Java for a couple of years. Now, for my current job, I'm an insurance...