Search results for query: *

I will check that out. I won't be able to work on this any further until next week. I'll respond then and let you know how it's going. Thanks!

Seems to be a problem with: myNewFolder Save

Hi lameid, Thanks for your post but I cannot get this to work with public folders. I am using the Add method to create the folder. This method does not support public folders as far as I know. I appreciate your help!!! Henry

Hi, I am looking for a way in Access to create a personal folder in Outlook. I can create folders in the Outlook default folders but can't find any information on how to refer to the personal folders in code. Here is what I am using to create folders in default Outlook folders: Private Sub...

Remou, Quite a difference indeed. I had not completely thought through my problem and must admit posted my question prematurely. I think the "better" solution is through using the query as you suggest. However, my solution just needs to generate over 60 pages of HTML with varying prices for...

Hey Remou! Thanks for your response. While I appreciate the merit of your answer, I have, however, answered my own question. It is so simple I don't know how I missed it other than I have not been using Access for much in the last two years. I am using a report to export the HTML. All I...

Hi, I have an application that uses a query to create HTML for alphabetically ordered lists of items. I would like to find a way to identify the first instance of the letters A-Z in the list so I can add a named anchor at that point with the end result being able to provide an A-Z navigational...

Why not just set up security and add users to groups that have appropriate permissions.

Hi, I have been trying to get the design view of a chart in Access to reflect the actual data. Why does it continue to reflect North, South West for 1st, 2nd, 3rd and 4th quarter When my data is completely different? How can I format the chart if I can only see another one? Thanks, Henry

Dan, Not yet but, the lookup table seems like one way to fix it. I've been looking into it. While this problem is high on my list, right now I'm getting hit from all sides. I'll probably work on it this weekend. Thanks for keeping in touch. I really appreciate it. Henry

Dan, I cannot remove label attributes as they are used in the script to dynamically swap dollar amounts in the first row of the table. Again, this worked fine in IE6. I also tried to validate. Thanks for the tip on that. FYI, I have recently inherited this site and am not a whiz at...

Hi, Can anyone tell me what is causing the problem with the select menu on this page: http://www.mibcn.com/home/medicare_advantage/premiumCopay.shtml It should be showing the name of a county. In IE7, it is showing the label and not the value. It works fine in IE6. Thanks in advance for any...

captainPlus, Wow! I was hoping to get some general direction and you provided the code. Thank you so much! It will take me a day or so to try this before I post back. Regards, Henry

Hi, When someone clicks a link that links to a page outside of our site, I need a popup window that warns that the link is outside of our site. Is it possible to develop a script that, when the link is clicked: 1. "Grabs" the URL of the link. 2. Opens a popup that includes a link to the...

Skip, Joe is my cube neighbor. I suggested he try tek-tips and decided to post the question for him. Thanks for your reply, Henry

Hi, Excel labels in reports are breaking strangely. For instance, the word "Threshold" breaks like this (without the hyphen) "Thresho-ld" with "ld" moving to the next line. Is there any way I can adjust things to keep it on the same line or hyphenate it properly? Thank you, Henry

OK, folks. Forget it. For some reason, all functions in this database returned the same compile error. I imported the tables into a new database and everything works just fine. Now I am wondering how this happens. Regards, Henry

Forgot to mention: Access 2000. Regards, Henry

Hi, I am trying to follow steps found in other threads to randomly order a query of 2009 records. I get an error: Compile error in query expression 'rnd([MyTable].NumField)' Here is my SQL: SELECT TOP 2009 [MyTable].NumField FROM MyTable ORDER BY rnd([MyTable].NumField); I got my example from...

OK Michael, thanks. I appreciate your advice. The interaction between the two programs that I seek are, without going into detail, relatively minor - at least from the perspective of someone who has no idea of how to go about achieving it. I will post if I make any progress.