Recent content by ThatNewGuy

I've resolved this issue I was having. For anyone that might come across a similar problem in the future here's what I would suggest. Go to msconfig in Windows 7. Select the Startup tab. In my case there was an item titled FullScreen. The command was labeled as follows...

Hello everyone, I've run into a strange problem that I can't seem to resolve. I recently purchased a Compaq Presario with Windows 7 Home, then I upgraded to Professional to use it here at work. Thirty days after purchase the hard drive failed. HP recently sent me a new hard drive and the...

Haha...what happened Duane? My very specific problem of "giant boxes" couldn't be identified from my total lack of information. Let me try this again. I think it's related to the grouping headers/footers or lack thereof. My desired result is to have the subreport on the top half of the...

Ok ok...i got it now! I wasn't grouping the report headers and the subreport in the right location. Now, I'm getting the data I need. Only problem is I'm getting giant boxes that over lap the detail sections of the master report even after I've scaled down the subreport. Hmmm...it's never...

To clarify even if the field is previously grouped in my query do I still have to group the subreport in the link master group header or footer section? This link master biz is kind of confusing. Still no luck after checking some of your suggested settings. I must be missing something here.

I'm currently working on a report that's pulling all of my data from a query that's main function is using the "group by" command. For example, if I have 5 purchase order numbers of the same value I only need to see that value once. Due to the desired report format I have to use a...

Gerry, here is the update. [CODE] Sub CommandButton1_Click() Dim Filter As String, Title As String Dim FilterIndex As Integer Dim Filename As Variant Dim point1 As Long Dim point2 As Long Dim r As Word.Range Dim xlWB As Excel.Workbook 'File filters Filter = "Word Documents (*.doc),*.doc,"...

Gerry, I've run into a new set of problems after updating to your suggestions. It all slowly started coming back to me why I wasn't using parameters like you suggested vs the clunky activedocument and selection commands. When defining Dim r As Word.Range I went ahead and updated the...

Hello Gerry, These are some really good suggestions! When I have a chance I'm going to convert over to your revisions. I love the idea of dropping the ActiveDocument and Selection commands because it will help things run much much faster. Good thinking. As for the wrdApp being visible...

Skip, I have no idea what your talking about. Little stars? I'll be the first guy to thank someone or pat someone on the back, but I'm not a forum "expert". I never knew about these special stars let alone how in the world to use them.

Great job to everyone! Much thanks all around. It's ALWAYS the little things when it comes down to it. I knew I was close, but close doesn't cut it. Once again, thank you!

I'm currently working on code so the end user will have an open form in Excel then upon execution of a command button the user will be able to browse their pc for Word files needed to update the current Excel document/form. Once the Word document is opened I want to automate the process of...

Well, I'm back again. Once I started building the rest of the form I ran into a problem. I now have four fields. Upon execution of the command button if field1 is empty it fills in. Then if field1 contains data it bumps the next entry to field2. The problem is when I go to enter the data in...

PHV you da man! Thanks! Working great...plus it's simple and clean.

It's not pretty but I was using cut and paste at the time bcuz it was working...haha enough said. I tried your suggestion and it doesn't seem to change anything. Still not sending data to the second field if the first one contains data. It just overwrites the first field upon execution...