Replies

Both suggestions worked. For my purposes, Hans’ solution is probably the best route.

I’ve also been working in FrameMaker, and they have a first number style that makes numbered lists a lot easier to manage. Apparently, this style disrupts the continuous numbering that goes from list to list and restarts the numbering. I wonder why Word hasn’t come up with a similar style (maybe they have; I’m still using Word 2000).

Thanks for both of your suggestions,
Bob

I’m sorry, I meant the List Number 2 style.

The section is set up to use different headers and footers for odd and even pages. I only use one kind of orientation in each section, but I wonder if Word is seeing multiple values because of the odd/even specification?

I’ve played around with different combinations of the ActiveDocument, Sections, PageSetUp, Headers, Footers, and Orientation objects and properties, but I still keep getting the 999999 result.

I’ve been testing the following code with the attached document:

Sub ChangeHdrFtrTabs()

Dim PgOr As Variant
Dim SecNum As Integer
Dim SecTotal As Integer

SecTotal = ActiveDocument.Sections.Count

For SecNum = 1 To SecTotal

PgOr = ActiveDocument.Sections(SecNum).PageSetup.Orientation

Next SecNum

End Sub

Sections 1 and 3 return good values (0 or 1), but sections 2 and 4 return 9999999

Thanks,
Bob

Thanks for the tips. They will help me adjust to FrameMaker.

I think you addressed this a little in an earlier post, but have you gotten into many cost-of-ownership debates with Word and Frame? We also work a lot with the other Microsoft Office tools (PowerPoint, Excel, Access). Since we’re already buying Word as part of the Office package, I’ve been asking management why we need Frame.

Also, one area where Frame seems to have an advantage is with the kinds of PDFs it produces. My understanding is that it can hook in chapter links with master TOCs and indexes, something we can’t do with Word. Do you know of any tools that would enable Word to do this same thing? Right now, we build Word master TOCs and indexes in separate files from the chapter, appendix and other files.

Thanks,
Bob

I’ve been teaching myself FrameMaker, and I’ve found it interesting. I can understand people’s enthusiasm–the information-rich dialog boxes, the organization of elements, etc.

Still, I’m not finding a lot of features that I’ve gotten used to with Word:

— Macros
— More than one undo
— Multiple items on the clipboard
— Detailed change tracking
— Customizable buttons and toolbars
— Visible doc path (so I know exactly what I’m working on)
— Style and font dropdown boxes that show what styles and fonts look like
— Ability to open in HTML

Is there anything in the basic FrameMaker (that is, without add-ins like FrameScript) that does any of this? The above items (particularly the macros) have saved me a lot of time.

Thanks,
Bob

That is what I needed.

Thanks,
Bob

That is what I needed.

Thanks,
Bob

Here you go. Worksheet 1 is an example of the Excel layout, and worksheet 2 shows how I’d like the Access table laid out.

Thanks,
Bob

Here you go. Worksheet 1 is an example of the Excel layout, and worksheet 2 shows how I’d like the Access table laid out.

Thanks,
Bob

That was it–thanks.

Bob

That was it–thanks.

Bob

After a little more experimentation, I realized I had to adjust a date header too. I set the Date Header New Row or Col setting to Before Section and the Detail New Row or Col setting to None and it came out fine.

Thanks,
Bob

After a little more experimentation, I realized I had to adjust a date header too. I set the Date Header New Row or Col setting to Before Section and the Detail New Row or Col setting to None and it came out fine.

Thanks,
Bob

I’ve tried another angle on this issue. I’m starting from a popup form that has a lookup field for the employee name. When I press the OK button, the value from this lookup field is used as a criterion in the report query.

However, the form field value isn’t getting passed to the query. I’ve put a message box in the query Visual Basic code and it shows a value being captured on the form. I’ve also run the query by itself with a sample value and there’s no problem there. The SQL also looks good.

The query result is just a blank table. Does anyone know what could be happening?

Thanks,
Bob

I’ve tried another angle on this issue. I’m starting from a popup form that has a lookup field for the employee name. When I press the OK button, the value from this lookup field is used as a criterion in the report query.

However, the form field value isn’t getting passed to the query. I’ve put a message box in the query Visual Basic code and it shows a value being captured on the form. I’ve also run the query by itself with a sample value and there’s no problem there. The SQL also looks good.

The query result is just a blank table. Does anyone know what could be happening?

Thanks,
Bob