Recent content by Doroth

Hello. Trying to figure out if there is a solution or whether we need to buy another front of house screen (for second cash drawer). The power light appears to show power, but the screen remains black. Upon powering up there are four short beeps. Any ideas?

FYI - This one worked Option Explicit 'Main Function Function SpellNumber(ByVal MyNumber) Dim Dollars, Cents, Temp Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion "...

I believe that I understand your question. Try right clicking on the TOC, go to the button that is under the text "click button to set" advanced field options. This should bring up the formatting box, under web preview, click "use hyperlinks.

I've seen this happen when there is an empty space before the number. Perhaps this is the issue? Click in one of the cells that is problematic to see if there is a space that is creating the problem.

Once again, thank everybody for the help, but I still get a result of 0 rather than text. I believe this is because the words 'dollars' and 'cents' appear a couple other times in the code as well. Is there any quick place that I can learn what the code says? Like what does dim mean, etc? I am...

Thank you for your replies. As, I really don't know what the bits of script mean, I don't know what needs to be deleted or replaced, thus the conundrum with deleting the dollars and cents bits since they seem to be intertwined. This is the code on the Microsoft...

Greetings, I am totally unfamiliar with visual basic so please forgive my ignorance. I have found a script on the Microsoft site that allows me to convert a number into text... ie '3,879' to 'three thousand eight hundred and seventy nine'. Unfortunately, that script also adds 'dollars' and...

Thanks. I knew there had to be an easy fix - just didn't know how to do it. Kudos.

Greetings - I am working on a spreadsheet wherein the "A" cells automatically increase by 3%. That number is than multiplied by another number. The problem I am running into is that the result is inaccurate, although it looks as if it should work. I have column "A" showing up as currency with...

I don't think this is possible in the way you are trying to do it. Reason being, protected documents can't be emailed directly from Word. Since forms need to be protected to work correctly, the form would have to be attached to an email rather than emailed directly.

Try this: Select the table or click within the table then ->Go to Table Properties, on the Row tab, select "allow row to break across pages." Please let me know if this works as there is another possibility. Good Luck.

I realize who uses tek-tips since I've been a member since early 2002. When I posted this on Friday morning, I was really needing the help and just re-iterating a previous question because the documents will be out of my hands within a week and any problematic issues would recur. So, I thought I...

Yeah, I posted it in another place on the site: http://www.tek-tips.com/viewthread.cfm?qid=1202938&page=1

I found the solution to this so nobody need to respond with suggestions.

Well, it always seems that when I've finally given up hope and ask for help, I find the solution. I found the solution to this and as always it was incredibly predictable, but a little obscure. While poking around in the TOC formatting, I noticed that the paragraph for the TOC 2 items had the...