My issue is trying to create small dot labels or equivalent to make up sequential alpha numeric labels to identify each individual item that I have in my shop, retrospectively. I have possibly 6-8thousand individual items that need coding for stock take purposes yet I can find no outlet that supply such thing. Do you have any suggestions. My line is antiques/collectables, predominantly china with items ranging in size from 2-3cm to 5/600cm. I would be most grateful for any solutions or suggestions. Best regards. Pete.
Klaus Nordby, one of our good-natured Norwegian hecklers, has produced a ray of sunshine in the midst of a deep, dark Scandanavian winter by coming up with a wonderful little trick involving adding sequential numbers inside a paragraph. For example, 1. this is the first clause of this sentence; 2. this is the second; and 3. this is the third. That’s not a big deal to type, of course, but if you had dozens of them and you needed to insert or remove numbering frequently, doing it manually would be a hassle.
As I indicated, because you want to only generate this number just before saving, I would put this code behind a Save button or another event that runs just before you save the record. So if you want to prevent duplications, you don’t use the expression as a control source, but put the code behind a button or event. Since you have a Save button, put it there.
Hi All, I am trying to add the 'File" menu and "Window" menu of the Standard Toolbar to a custom toolbar but failing miserably! I think it should look something like: Sub AddMenuTitles() Application.CommandBars("MyCustomMenu").Controls.Add("File) Application.CommandBars("MyCustomMenu").Controls.Add("Window") End Sub Can anybody help please Regards Michael Sub test() AddMenuTitles True ' or false to delete End Sub Sub AddMenuTitles(bAdd As Boolean) Dim cbr As CommandBar Dim cbP As CommandBarPopup ...
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. sequential numbering printing