Hello! I would like to chart varying salaries against specific Low, middle and high numbers. Any suggestions on how to show this? Example: Salary 1 10000 Salary 2 12000 Salary 3 16000 Low 9000 Mid 15000 High 19000 THANK YOU! Do you want the Low-Mid-High values to be like a benchmark to measure salaries against? You could put horizontal lines across your chart, and use markers for the salary data. Here' a few ways to get your lines: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials...

Note  If TAB and SHIFT+TAB do not work for changing the indents for outline numbering, you probably have the option Tabs and Backspace set left Indent turned off. To change this setting, from the Tools menu, choose Options. Select the Edit tab and check the option Tabs and backspace set left indent. As an alternative to turning this option on, you can instead use ALT+SHIFT+LEFT ARROW or RIGHT ARROW to increase or decrease outline numbering.
By omitting the dbFailOnError parameter only for the DROP TABLE statement, we won’t get a runtime error about a table not existing but get runtime errors if we can’t create the table or insert data for some reasons. I’m also not a big fan of creating multiple saved queries that are meant to be logically grouped together – it gets quite cluttered when there are several saved queries in a navigation pane like that. Keeping it all in VBA makes it clearer that the intention is to execute those statements together.
Become a Microsoft Word power user in just a few minutes a week. This tips-based series helps you deepen your proficiency with Word, covering a variety of tools and techniques you can use. Learn how to work with templates, format documents, customize built-in styles and themes, master Track Changes, and more. Check back each week for a new pro tip from expert David Rivers.
You can add many of these items by using text variables. InDesign includes several preset variables, such as Creation Date and File Name. You can modify these variables, and you can create your own. For example, you can create a variable that displays the first use of a Heading paragraph style in the header or footer. Once you create or edit the variables you need, you assemble them on the master page to create your header and footer, and then you apply the master page to the appropriate document pages.

If you use the Form Wizard, controls will be named with the field name the control is bound to. But that name can be changed. This trips up a lot of people because my code samples use a naming convention that is not what is automatically generated. So you just need to make sure you use the correct name for the object. The name is shown in the Name property on the Other tab (Not the Caption property). To determine what field in your table the control is bound to check the ControlSource property. It should be bound to the PONum field.
All I want to know is, how do you link fields, like {SEQ}, to a style – so that if I select/apply style “Figure Caption” (my style, I also have “Table Caption”), I get not just the attributes of the style (what it looks like, where it is on the page etc.) but I get a chapter (or section) number + a sequence number added, (e.g. “2-3”). I know about STYLEREF and SEQ Figure # and/or calling a section number (if required) – but I can’t find out how to take the simple and to me obvious step to have sequential numbering (prefixed with either “Figure” or “Table”) attached to my Figure Caption style. It all seems to be a two-step process: (i) select the style, (ii) select the numbering. I want to do both at style level. I want to see/get (e.g.) “Figure 2-3: Linking figure numbering to styles” just by applying my “Figure Caption” style to my figure caption text “Linking figure numbering to styles”. Please, only tell me how to do that, how to link chapter/sequence numbering via a style – i.e. in just one step – applying the style.
I want to a sequential number to fill in automatically each time the form is filled out. Malissa, A simple way would be to use something like this, you could assign it to a button, an open or before print event. Sheets("Sheet1").Range("A1").Value = _ Sheets("Sheet1").Range("A1").Value + 1 For other ways to do this or if this is going to be used in a temple have a look here http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others...
A sequence can be thought of as a list of elements with a particular order. Sequences are useful in a number of mathematical disciplines for studying functions, spaces, and other mathematical structures using the convergence properties of sequences. In particular, sequences are the basis for series, which are important in differential equations and analysis. Sequences are also of interest in their own right and can be studied as patterns or puzzles, such as in the study of prime numbers.
In mathematics, a sequence is an enumerated collection of objects in which repetitions are allowed. Like a set, it contains members (also called elements, or terms). The number of elements (possibly infinite) is called the length of the sequence. Unlike a set, the same elements can appear multiple times at different positions in a sequence, and order matters. Formally, a sequence can be defined as a function whose domain is either the set of the natural numbers (for infinite sequences) or the set of the first n natural numbers (for a sequence of finite length n). The position of an element in a sequence is its rank or index; it is the natural number from which the element is the image. It depends on the context or a specific convention, if the first element has index 0 or 1. When a symbol has been chosen for denoting a sequence, the nth element of the sequence is denoted by this symbol with n as subscript; for example, the nth element of the Fibonacci sequence is generally denoted Fn.
This one is EASY. In InDesign, with a one-sided NCR form, cut the all elements from the first page. Go to your Master page and place. Where you are going to number the forms, draw a text box and insert a page number marker there. Format it to your liking, then insert as many pages as SETS are going to be made. When you go to print, enter 2 or 3 in the copies box, depending if it's 2-part or 3-part and under the properties button, select GROUPED or UNCOLLATED, turn off OFFSET. Violá!
Now, what’s the deal with the UniqueKeyVariant parameter for the RowNumber() function? We are not even using it all! True, but if we didn’t, Access will call RowNumber() only once for an entire query and thus we get “1” for the entire dataset. That is a good way to save on CPU processing – why call Now() for each row? In this case, we want to go against this CPU-saving measure and ensure that the RowNumber() is in fact called once per row to generate a new number for that row. Thus, we pass in a parameter — a primary key of a table is a good choice for this purpose. So we get a nice sequential number generated all in the query with VBA function.
Budget is our income and sometimes this is positive. I need to make this column in a query all negitive values. I am using the IIf function but it is not working. Budget: [budget_amount] IIf ([budget_amount] >=0, [budget_amount]*-1, [budget_amount]) or is there another function I could use? On Mon, 29 Oct 2007 19:18:00 -0700, Tamm Fox wrote: > Budget is our income and sometimes this is positive. I need to make this > column in a query all negitive values. > > I am using the IIf function but it is not working. > > Budget: [budget_amount] IIf ([budget_amount] &g...
This chapter (web page) takes you through how numbering is supposed to work in Word and the various controls. It is useful, but primarily on SEQ fields and simple numbered lists and also as reference showing the menus, dialogs and controls and going through the concepts for outline numbering. To actually set up outline numbering that works, refer to the Kelly and McGhie articles.

I have a problem with Outlook 2007 and the add-in Access Outlook Add-in for Data Collection and Publishing. This add-in worked when I first installed Outlook 2007 when installing Office 2007 Enterprise. The add-in created a sub-folder in my Inbox named Data Collection Replies and worked well until about 6 weeks ago. Now I can’t get the add-in to work at all even though it appears in the list of COM.adds in Outlook 2007. More perplexing is the error message I now receive EVERY time I click on any email message to read it. The message is titled ‘Custom UI Runtime Error in... sequential numbering
×