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

Sorry about that. I did some experimenting and found that the simple "sdate = Selection" does the trick. -- Steve Ikard

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

Thanks for all your suggestions. I think I must have gone brain dead. I simply had to create a field in that last column at the Group Header 1 level which was the SUM of the time. Since it was at the Group level, it was the total of all the time for that Group (Employee). Sorry for bothering...

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

Thanks SO much for the reply, dgillz, whoever you are. You saved the day! It worked like a champ once I fixed the missing parentheses. Thanks, again. This forum is invaluable! -- Steve Ikard

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