Well, Paul, I guess you didn't read my posts very well. I did refresh the index by clicking in it and then pressing F9. The reason it didn't delete the "hosed" reference is because it was a legitimate reference. For some reason, the index entry didn't recognize the leading dots before the...
I figured it out. It was a legitimate index entry (the Spanish word "lo" as an object). For some reason the field got hosed. I deleted the entry, recreated it, and voila! It's all good now.
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...
You are spot on! I was pasting stuff from a website into my "formatted" spreadsheet. Thanks for teaching me something new. I never heard about structured tables but I'm going to look into it.
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.
Hi AceMan. Yes, I'm familiar with the wild cards. It's those darned quotation marks that get me every time. I just cannot seem to grasp how to properly place them and when to use single versus double quotes. I really appreciate your help. Of course, your code works perfectly! Please enjoy...
Thanks but using the word Like alone doesn't help. I would use it with an asterisk wild card before and after the value in the text field but I can't figure out the correct placement of the quotation marks. That's what get me every time!
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 shouldn't have asked everyone to ignore this post. I just spent hours trying to work with the earlier thread I mentioned but couldn't figure it out. It seems like Greg didn't explain how he developed qUniqueNSNXref. So, I'm still without a solution. I'm hopeful that someone will come to my...
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.