Search results for query: *

Thanks Aceman.

Hello All, Does anyone know how to remove a page within an Access Report. For instance, is there code to remove all even pages or all odd pages of an Access Report. Thanks

Thanks, that did the trick

Hello All: Does anyone know how to leave the very last page of a report blank in access? What I need is for the last page of the report to be blank except for the header, footer, and a message in the middle of the page that says "THIS PAGE INTENTIONALLY LEFT BLANK." Thanks

You can always fake the running sum by doing a seperate query on the form's current event. (Assumming you have a textbox that's called txtTotalValue.) Private Sub Form_Current() Dim strSQL as string strSQL = "SELECT Sum(Value) AS MyTotal " _ & " FROM Sometable; " Dim rst as...

The code worked out well. I only had to change: For each para in Paragraphs to For each para in ActiveDocuments.Paragraphs By the way, what is s in the code? Is it a sentence or paragraph??

I'm looking for a method in Word VBA to read a Sentence from Word and then store it into a string. But I do not want to convert the Word Doc to a text file.

Hello all, I am currently using an activeX tree view on one of my forms and I haven't found a way to shut off the 'move over' node functionality. What I mean by the "move over node functionality" is Whenever I hover my cursor over a node, a yellow box appears over that node with the node text...

I appreciate all the feed back. Just to let you know I tried using the footer in Word to solve the customer's problem originally; however, the text in the footer changed so much that it got to be a pain, trying to break the link from the previous footer in one section and not in another...

Thanks

Hello SQL Gurus, I am having trouble writing a SQL Query to find different records between two tables that are exactly the same structure. I have one table called tblRequirements,and another table, I download from another system, called tblTempRequirements. I want to create a query that would...

Nevermind, Sorry...I just found it: selection.Information(wdFirstCharacterLineNumber)

In VBA Word, Is there a function call to find out what line number my selection is at? Thanks.

Another Way: Is to create Module, name it something like Properties. In the module you would write code that would look something like this: '-----------------Module Code--------------- Private mStudentID as Long Public Function SetStudentID(newNum as long) mStudentID = newNum End Function...

Here's the solution that I can up with however; This function only tells me after I am on a new page and not right before, which is what I want. ' member var Private mCurrentPage as long ' Private Sub SetCurrentPage() mCurrentPage =...

Nevermind Gerry, Thanks anyways... I wanted to create code to do something like this: psdedo code: string array(3) MyArray = GoodMorning,GoodAfternoon,Goodevening For i =1 to 3 Do While MySelection is Not OnANewPage() Selection.TypeText array(i) If MySelection is...

Ignore the outline stuff, All I want to know is, with VBA, can I detect the an 'end of a new page' before I go on to the next. Or Even better, Can I tell what current page my selection is on?

Hello All: Just wanted to know if there is some vba code out there that someone might know about that will detect when my Word Selection is about to move to a new page. I'm writing code to generate an outline, and I want to be able to mark the bottom of each page -as the text is generated-...

Hello All: Just wanted to let you all know that I am a very lazy programmer. And a little new to VBA.... I'm used to creating macros in C to save me from typing alot of code, and I was wondering if VBA Macros work the same way. For example, can I set up a macro to output 'Dim userInput as...

Thanks you all for your help and replies. The only solution I have come up with is similiar to Remou's. It looks likes I gonna have to code some vb to programmatically create a word doc -using the word 9.0 object library- and export my data there. This way I can manually code the fomatting...