I have a strange entry (Lo3) in my index and can't figure out how to get rid of it. There's no associated page number. I've searched my document for Lo3 but found nothing. I can delete it from the index but as soon as I update/refresh (F9) the index the entry reappears! I've attached a copy...
I selected the entire worksheet and formatted it so that data in all cells will be at the top left and wrapped. But, as soon as I type something new, the format isn't working. The data goes to the bottom of the cell and does not wrap. It's making me crazy!
I'm using the following expression in an Excel spreadsheet:
=IF(E3+F3>N3,"Good Stock Level","Order "& INT(N3-E3-F3)& " "& D3)
False results return the number without a comma which I would like to have:
"Order 1868 BK" instead of "Order 1,868 BK"
Can anyone tell me how to force the 1000...
Has anybody used Total Access Analyzer 2010 yet? I tested it a couple months ago and had diffulties. FMS swears they have the bugs worked out but I'd like to hear from you before I spend $300.
I'm still having a lot of trouble inserting SQL statements in VBA. Here's what I have:
Me.Filter = "[Word]='" & Me![SearchForThisWord] & "'"
The problem is I don't want the user to have to search for the Exact word. If I were building a query, I'd use *.* but I don't know how to get that...
I often have several requisitions on backorder against the same vendor contract and want to group them together so I only have to type my follow up notes one time. In other words, instead of having several TrackingNumber records, I just want one. I want to design a report that alerts me when a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.