If you want to use a bullet found in a specific font (such as the pointing hand from Dingbats), be sure to set the bullet to remember that font. If you use a basic bullet character, it’s probably best not to remember the font, because most fonts have their own version of that bullet character. Depending on whether you select the Remember Font With Bullet option, a bullet you add can reference either a Unicode value and a specific font family and style, or just a Unicode value.

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.


we have printed AP checks using the check number from 0000000001 to 0000000006, but we havent posted those batches. we have only one checbook. Now can we restart the check number from 000001. Then do we need to delete the previous batches for checks printed. What is the best approach in this regard. Thanks in Advance, Arun. In the Post Payables Checks batch window (Transactions > Purchasing > Post Checks), choose the batch in question, then select Reprint Checks from the drop-down list. Enter 000001 for your starting check number. You will also need to go ...
I have a word document with a table of 6 exact cells on a full page table. In those cell areas I have been printing tickets with a list and a mail merge and updating labels. I call to an excel list of 1-2000 and then I generate all the pages through the Finish and Merge option. This all works perfect. I get 2000 individually numbered tickets to print...however...I then have six tickets printed on a page of paper with ticket numbers 1, 2, 3, 4, 5 ,6 then the next page has 7,8,9,10,11,12. This is fine but I then have to cut and stack these tickets in groups of six and at that point none of the numbering is sequential. The tickets are basically random.
I have done this twice now, getting flustered. The ticket part the person keeps has the correct sequential number on it, but the side that we keep has the same number on it for the whole page. What part am I missing, at first I did not uncheck the box, but this time I did but have the same number on the stub side that we keep with the person’s name, etc

In bulleted lists, each paragraph begins with a bullet character. In numbered lists, each paragraph begins with an expression that includes a number or letter and a separator such as a period or parenthesis. The numbers in a numbered list are updated automatically when you add or remove paragraphs in the list. You can change the type of bullet or numbering style, the separator, the font attributes and character styles, and the type and amount of indent spacing.


I want to have textbox with 2 columns with footnotes running across the bottom of those columns in one column. ID CS3 footnotes can’t handle this. So I have added fake footnote refs in the doc. using this idea. Now the footnotes themselves I can create in another text frame and use this idea again to create them and then manually place them at the bottom of the page. The only problem however with this is the FN options carrry across the whole doc. right? So even if I create a second doc for the footnotes themselves with different options and then later paste it into the main doc it’ll get messed up right?
Note that the list name remains the same for all of these tags. Table titles have a level 4 designation, and Figure titles have a level 5. The numbering style calls out the level 4 numbers (^4) on the Table titles, and the level 5 numbers (^5) for the Figure titles. It’s important to note that for this style, both of these restart after the level 3s (Subhead 2s).
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.
Select the Text Tool (T) and start dragging a text box that will wrap around the whole ticket including the crop marks. This is very important since the Data Merge will automatically calculate the duplication. Then open up the Text Frame Option (Command + B) and set the Inset spacing to 1p4 for the top and 1p8 for the left. Of course, you can place the text for the numbers anywhere you like. I set the numbers to a small text.

One of the easiest ways to begin applying numbers is by starting to type a numbered list. Word recognizes that you are creating a list and responds accordingly by converting text that you type into numbered items. The number scheme, delimiter characters that mark the beginning or end of a unit of data and formatting are all based on what you have typed.
Hi All, I am working on a YTD Sales report. I would like to know if I can create a cell in a query that will be a squential number. Starting with 1 on up. If so how would I do this? Report would look something like: Num Customer YTD Sales 1 Bobs Sales 495,000 2 Denny's 395,000 3 Biffs Supply 390,000 4.... -- Matt Campbell mattc (at) saunatec [dot] com Message posted via http://www.accessmonster.com You can use a text box in the report: Control Source: =1 Running Sum: Over All -- Duane Hookom Microsoft Access MVP "mattc66 via AccessMo...
This will work OK for a small set of data, but the more data there is, the more intensive the subquery becomes, and it must be called repeatedly for each row. This is one of those rare cases where doing it in VBA is faster than doing it in SQL — after all, row numbering is fundamentally iterative, not set-based which just goes against the grain of what SQL was designed to do – solve a problem in a set-based fashion, non-iterative fashion.
2. Yes, The code should be entered using CodeBuilder. Where you enter it depends on how and when you want to trigger the generation of the next number. If you want to use a button, that works. And no, you don’t use 000 in the NZ() function. If you want to DISPLAY at least 3 digits with leading zeros, then you do that in the Format function. Note, though, you will need to change that when you hit 1000 POs. sequentially numbering in publisher
×