Search results for query: *

I am trying to create a CR 9 report that looks just like an existing accounts payable claim form (boxes, lines, etc.). My client wants it to always have 8 Detail Line rows -- no matter how many actual data detail lines there are. Sometime there is only one record, sometimes 2, etc. He still...

I am replacing a name and date in the second-page header ("Primary Header" per Word) of a letter with the following code: Set PriHdr = ActiveDocument.Sections(1). _ Headers(wdHeaderFooterPrimary).Range With PriHdr.Find .Text = "Name" .Replacement.Text = sName...

Word VBA newbie. I have "found" a date in a Word doc via "With Selection.Find". I used "Selection.Expand wdSentence" to narrow it down to just the date. Now here's where I feel really stupid. How do I "assign" the selected date to a variable? I want...

CR8. I am trying to create a daily time analysis for a one month period. I am using Header 1 to show Group Name (name of the Employee) and then a SUM of each Detail line for each of the 31 days of the month. I hide the Detail line and show the Header 1. Everything works great except I want...

I have a date field in my SQL db that is a number - not a date/time. I assumed that I could simply use the Date(number) function (number of days starting from Dec. 30, 1899), but my dates were reported as all in 2101! I contacted the db vendor and they informed me that their number date was...

I have a parameter that is a date range: {?Rpt Date Range}. I want to use the Year function to isolate just the year, so I set up a formula for variable "Year1": Minimum(?Rpt Date Range). I want to then substiture the "Year1" variable in the Date Function in place of the...