Hi, Let's keep the problem simple. I have one cell that uses an exchange rate from the internet. That cell changes every minute. What I want to do: In an other cell, I want to keep the highest exchange rate ever. So for example: 6:00 exchange rate = 5.00 -- highest exchange rate is 5.00 6:01 exchange rate = 4.98 -- highest exchange rate is 5.00 6:02 exchange rate = 5.02 -- highest exchange rate is 5.02 6:03 exchange rate = 5.01 -- highest exchange rate is 5.02 6:04 exchange rate = 5.03 -- highest exchange rate is 5.03 Of course nor for any minute I use a new cell, it just change the n...
In a legal document, it's rare for every paragraph in the document to be numbered. Usually, you change between numbered paragraphs and non-numbered (plain) paragraphs of text. When Word sees you switching between these types of formats, it usually tries to help by restarting your numbered list back at "1" (or the first value of your list, such as "A"). There are a few different ways to make the number follow the last number of your paragraphs. In Word, this is called Continue from Previous List.
To use mail merge to create a batch of gift certificates or coupons with tracking numbers, you need to set up a data source that contains a column listing the tracking numbers. If you plan to add only the tracking numbers to your publications, create a data source for the tracking numbers. If you also plan to use mail merge to insert additional information into your publications, such as customer names or addresses, you can add the column of tracking numbers to a data source that also lists the name and address data that you want to use.
Thanks very much for your prompt reply, which reassured me that I was on the right path. From having read various Help topics, I suspected that I'd have to use an Excel data source for the numbers. Fortunately, my knowledge of Excel was good enough to know about the drag and drop facility to create automatic sequential numbering, so the data source creation was easy. In the end, it was the mail merge (no surprises?) which proved a tad tricky, but I got there in the end. I've used MM many times and quite happily in Word documents, but for Publisher label format, it was of course a bit different. The important bit that I had to discover for myself was the significance of, after getting to the Print stage, going into Print options, to Publication & Paper Settings, and selecting Multiple Pages per Sheet (& in my case, also "Single-sided" cos my default of duplex printing had come up). But TA-DA!  All is fine now. Thanks very much again.
A best practice that we recommend to our clients is to create a base/folio master –with styled and positioned footers and current page number special characters– on which all other masters are based. This allows a footer that may contain date or issue information to be updated once and the changes are reflected in all of the master pages. If your masters only have current page number special characters then you can just add them to each master and the page numbers will be reflected when each master is applied to your document pages.
If the list you want is as simple as "1", "2", "3", you'll appreciate how easy it is to apply this type of numbering in legal documents. Simple numbered lists are different in Word 2000 than they were in Word 97. In Word 2000, the default for even the most basic list is multi-level. For example, if you number an item and press Enter and then press the TAB key, Word automatically formats this number as the second level in an outline numbered list format. Single and multi-level numbering are explained later in this chapter.
You can define a section prefix to label section pages automatically. For example, if you specify A– for Section Prefix on page 16 of a document and include the section prefix, the page will appear in the table of contents or index as A–16. Text you type for a section marker appears when you choose Type > Insert Special Character > Markers > Section Marker.
No matter how light the file might be, if you need 1000 units, that means you send a 1000-page file to the printer if you use Data Merge, that is not as efficient as sending one page and 1000 numbers to insert in the print stream, but to do that you need a plugin, which is what that page Bob directed you is leading up to. I've never used the program Harbs has mentioned, but he's a pretty smart guy and if he says it works well, I'd take a look.

I would like to create a custom application that has the ability to maintain the items that are on certain Task Pads within POS 2009. These items would all be regular menu items (ex: hamburger, hot dog, french fries, etc) and not functions. For example, if a task pad was supposed to allow the cashier quick access to daily specials, then this custom application would need to be able to clear the task pad each day and add the items for that day. Is this going to be possible? Please provide some guidance. Thank you, Sean This is a multi-part message in MIME format. ------=_NextPart_00...
Hi, In the disaster recovery plan we want to create a leg site and put a DC in it. Here are some questions on how to achieve this smoothly. 1. Should I create the new site/subnet first and then promote a server in that subnet/site to DC, or should I promote a server in existing site/subnet and then move this DC to the new site/subnet? 2. When promoting a server to DC, should the server be a member server (already joined the domain) or just a workgroup member (no domain membership)? 3. The DC will be an AD-integrated DNS server. Should I install the DNS component (but not confi...
A3 is the result of A1/21 I want to bracket the number in A4 In MSWorks I would type the statement ="["&string(A3,0)&"]" In excel I get in some cells [1.436871259834] I'd like it to read [1] Help please. -- rodney@touch88gum.com.au (Remove gum to reply) Rodney, ="["&ROUND(A3,0)&"]" -- HTH, Bernie MS Excel MVP "Rodney" wrote in message news:OkME4oGVEHA.2564@TK2MSFTNGP11.phx.gbl... > A3 is the result of A1/21 > I want to bracket the number in A4 > In MSWorks I would type th...

Hi, As a new user to excel I am thinking of setting up a data base of my music. The total number of tracks is in excess of 70,000. I have seen a simple solution using excel which would be ok but I'm not sure if I can have 70,000 rows in one work sheet. A friend has suggested access which I am not familiar with and don't know if this will allow 70,000 entries. Can anyone please tell me what the maximum numbers are in both access and excel 2003. Cheers Glinty Max in Excel 2003 is 65536 (in one sheet) whereas Access only limit is your memory -- Regards, Peo Sjoblom ...
For example, in our law practice, we submit briefs with hundreds of attachments. Those attachments are constantly being reorganized (thus renumbered) and we had to develop a scheme to keep each attachment (and reference to each attachment) organized and accurate. We created a master list of attachments, and captured the dynamic field code in a bookmark. We can then cross-reference to that bookmark (which will return a number) through our documents. Example Public Attachment 68 (where 68 represents a field sequence code, is captured in a bookmark we will call SR_112). The bookmark name is a code name supplied by the drafting lawyer. That way, when the lawyer refers throughout the document to Public Attachment ___, we insert a cross reference to bookmark SR_112, and it always returns an accurate number, even if we reorganize the order of our attachments.
That’s it! From now on, all you have to do to add SEQ field numbering is either type in your AutoCorrect text (1] and n]) or select the options from your Quick Parts list. If you find your numbering gets out of whack (remember, the numbers don’t update when you insert a new number between two existing numbers, or delete a number), select the sequence and press F9 (Hint: To update all fields for the entire document, press Ctrl+A then F9).

A subsequence of a given sequence is a sequence formed from the given sequence by deleting some of the elements without disturbing the relative positions of the remaining elements. For instance, the sequence of positive even integers (2, 4, 6, ...) is a subsequence of the positive integers (1, 2, 3, ...). The positions of some elements change when other elements are deleted. However, the relative positions are preserved.
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...
One other thought. It may not hurt to make option 1 a logical expresssion where it will update the number IF a number other than 0 already exists for it. This will prevent it from giving a new number if you go back, edit it and save it. I accomplished this by adding the following (roughly): If PONo=0 Then My.PONo…. (Expression and save command) Else (Save Command)
Microsoft Publisher, the desktop publishing component of the Professional version of the Office Suite, can perform many time-saving tasks for busy business owners, including layout and design work. It can even help you avoid a shopping run to try to find tickets for your next employee picnic, holiday giveaway or executive board meeting. Create your own tickets, including the vital sequential ordering needed for raffles or attendance tracking, using Publisher’s page numbering. With a few tricky manipulations of the page number process, you can start running the numbers in an entirely new fashion.
The second thing you need to do is make sure that Word is configured so that it updates fields when it prints. Now, when you run the macro, you are asked how many copies to print and what starting number to use. The document variable is updated and a single copy of the document is printed. These steps are repeated for the number of times that you chose to print.
This requires no pre-knowledge of a primary key and only assumes that when you load the form initially, it is already sorted. Any records newly inserted will get the next bigger number. However, if you requery and it causes the newly inserted rows to be re-sorted, they will be now given a new number that relates to their actual position within the set, which can be either good or bad, depending on your specific requirements.

Author, trainer, and learning and development expert David Rivers has over 20 years experience helping government, hi-tech, and healthcare businesses increase their efficiency and productivity by integrating technology tools. With deep experience in Microsoft Office, elearning tools, and assorted productivity tools such as FrameMaker and RoboHelp, David is passionate about helping people improve their workflows to recover time in their schedules. His clients include Microsoft, Corel Corporation, Halogen Software, and the City of Ottawa. David is also a published book author on topics ranging from Photoshop to Acrobat and the Microsoft Digital Image Suite.
I make the design with as many up as I need on the master page, linking the frames where the numbers will go. Then I make the list using Excel, copy paste to ID and apply a paragraph style with "start in next frame" option. Click the outbox on the pasted text to get a loaded cursor and delete the frame. Then just shift-click over the first textframe on a live page to have as many "tickets" added as needed automatically.

I have two fields that should match, but one includes special characters while the other does not. Example: Field1 00ABCD123456123 Filed2 00/ABCD/123456/123/SBZ I need to find records where these two fields don't match, either by changing the display of one of them, or a query to compare Field1 character 7-15 with Field2 characters 9-14, 16-18. Hope this makes sense. Can anyone help? Thanks! Take a look at the following from the Access Help file it might be what you're looking for... Extract a part of a text value The following table lists examples of expressions that ...
An easier way is to setup the table in Excel and use the Excel features to create sequential numbering. The cells making up the whole table can then be selected and copied into a Word document using CTRL/C and CTRL/V which will create a table in Word. Column widths and borders can be set up in Excel and cells can be filled in before copying to the Word document.
I haven’t tried this… But according to the Microsoft instructions about field switches (http://office.microsoft.com/en-us/word-help/insert-and-format-field-codes-HA010338798.aspx), you can add text to a field code. The text must be in single quote marks, and displays as a constant for the field. The examples on that web page show the text at the end of the field, but you could try it earlier in the field by testing putting ‘120/’ in front of where the SEQ number will go.
Is there a way to code the special interrogatory numbers wherein the identify of documents is requested such that those specific special interrogatories (and only those specific special interrogatories) are automatically generated in a separate demand for production of documents? In other words if Special Interrogatory numbers 3, 6, 9, 12 request identification of documents, is there a way to code those special interrogatories so that within the demand for production of documents, those specific but individual special interrogatory numbers can be referenced?
There is very simple solution that we use and that is to lay out the sheet say 6 up on a A4 sheet as a master page and in document setup set the number of pages to 1,000 if that is the amount you require. Put a page number on each ticket on the page and although they will all have the same number on each page, we put the the first two letters of the customers business name before each number followed by the letters of the alphabet so it then reads for example BT1A, BT2A, BT3A, BT1B, BT2B, BT2C and so on as each page is printed.
In the example I explained, I was using a list, but did it with un-linked text boxes using “continue from previous number” and “continue numbers across stories.” I’m guessing that there is no way to tell InDesign that even though there are 4 text boxes on the page, that there are two different lists? I’d probably have to just create two threaded stories for that scenario to work.
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á!
To use mail merge to create a batch of gift certificates or coupons with tracking numbers, you need to set up a data source that contains a column listing the tracking numbers. If you plan to add only the tracking numbers to your publications, create a data source for the tracking numbers. If you also plan to use mail merge to insert additional information into your publications, such as customer names or addresses, you can add the column of tracking numbers to a data source that also lists the name and address data that you want to use.
This may be a toughie, I use Word to print out order forms for my shop, right now I use a stamp to give each one a unique number just for reference (you know the ones with the dials that updates whenever use). Anyways was wanting to somehow make a macro or something in Word that will automatically increment a order number on the form as I print them.
If you know in advance that you need outline numbering for your paragraphs, you will want to choose the correct format from the Bullets and Numbering dialog box. Applying one of the preset formats to a paragraph or paragraphs that are already bulleted or numbered applies it to the entire list. There is a specific tab for outline numbers — the Outlined Numbered tab.

I also use InDesign. An Excel file for numbering is easy to create. Then find DataMerge under Automate to link the data file. When you are ready to export, use the create PDF right on the Datamerge window. You can print as cut / stack on the Fiery (or CREO). REMEMBER - if your customer wants them stapled into books of 6 (for example) each stack has to be divisible by 6 if you are going to staple then cut into individual books.


That’s it! From now on, all you have to do to add SEQ field numbering is either type in your AutoCorrect text (1] and n]) or select the options from your Quick Parts list. If you find your numbering gets out of whack (remember, the numbers don’t update when you insert a new number between two existing numbers, or delete a number), select the sequence and press F9 (Hint: To update all fields for the entire document, press Ctrl+A then F9).
Normally, the term infinite sequence refers to a sequence that is infinite in one direction, and finite in the other—the sequence has a first element, but no final element. Such a sequence is called a singly infinite sequence or a one-sided infinite sequence when disambiguation is necessary. In contrast, a sequence that is infinite in both directions—i.e. that has neither a first nor a final element—is called a bi-infinite sequence, two-way infinite sequence, or doubly infinite sequence. A function from the set Z of all integers into a set, such as for instance the sequence of all even integers ( …, −4, −2, 0, 2, 4, 6, 8… ), is bi-infinite. This sequence could be denoted {\displaystyle (2n)_{n=-\infty }^{\infty }} .
Any code can read the serial number of a mother board? any example? Thanks! Crystal On Fri, 10 Jun 2005 00:07:16 +0800, "Crystal Lin" wrote: >Any code can read the serial number of a mother board? any example? Thanks! > Do all computers have "mother boards" and do all mother boards have serial numbers? > Any code can read the serial number of a mother board? any example? Thanks! You can read the Serial Number of the hard drive using DiskId32 at http://www.winsim.com/diskid32/diskid32.html . Lynn Let me guess: another mis...
For years, I've applied an autonumbered style to the first cell I want to be sequentially numbered. When I add rows, the cells immediately below continue that same numbered style whether I add them by tabbing from the end of the last row or by using the commands to inserts rows above or below. Because the numbering is part of a style, it can continue from one table to another, but it can always be restarted. I can even skip a row by changing the style for the particular cell or by just toggling off the numbering. I also use it to show two levels of numbering in a single cell by creating two autonumbered styles in a hierarchy that works just like Heading 1 and Heading 2.
Normally, the term infinite sequence refers to a sequence that is infinite in one direction, and finite in the other—the sequence has a first element, but no final element. Such a sequence is called a singly infinite sequence or a one-sided infinite sequence when disambiguation is necessary. In contrast, a sequence that is infinite in both directions—i.e. that has neither a first nor a final element—is called a bi-infinite sequence, two-way infinite sequence, or doubly infinite sequence. A function from the set Z of all integers into a set, such as for instance the sequence of all even integers ( …, −4, −2, 0, 2, 4, 6, 8… ), is bi-infinite. This sequence could be denoted {\displaystyle (2n)_{n=-\infty }^{\infty }} .
For example, in our law practice, we submit briefs with hundreds of attachments. Those attachments are constantly being reorganized (thus renumbered) and we had to develop a scheme to keep each attachment (and reference to each attachment) organized and accurate. We created a master list of attachments, and captured the dynamic field code in a bookmark. We can then cross-reference to that bookmark (which will return a number) through our documents. Example Public Attachment 68 (where 68 represents a field sequence code, is captured in a bookmark we will call SR_112). The bookmark name is a code name supplied by the drafting lawyer. That way, when the lawyer refers throughout the document to Public Attachment ___, we insert a cross reference to bookmark SR_112, and it always returns an accurate number, even if we reorganize the order of our attachments.
Add specific codes to coupons to track customer responses     Use different codes for your different marketing messages, advertisements, or promotions. These codes will enable you to keep track of how customers learned about your offer. The more you learn about who is drawn to your business and what attracts customers' attention, the better you can focus future marketing efforts.

Your raffle might be subject to gaming commission or tax laws. Check with your municipality, state or province, and federal governments to make sure your raffle is legal. These government departments aren’t just enforcers. They are often great resources on how to run a successful fund raising raffle. Raffles are fun! Getting in trouble with the law or tax man is not.


For whatever reason, AllExperts did not let me post a direct reply to your response re: “Ok, what is the ControlSource of the Fixture Number control? It should be: =cboZone & “-” & Format(Me.FNumber,”000″)” and adding “Me.Refresh” to my code (within the last 10 minutes). It just had the “rate this reply”. I added the Me.Refresh and corrected my location of the =cboZone code and it works correctly now.
×