Search results for query: *

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...

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...

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

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...

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...

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

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...

Hi, I am looking for some general information on integrating MS Access and MS Project. My version of Office is 2000 but any info is good. Any info or links would be appreciated. Regards, Henry

Hi, I installed a second HD, a Seagate 120 gb, on my Dell 4550. Both drives have XP Pro installed. Is there any way I can choose which disk to boot from other than changing the jumpers? I cannot select it or see it in boot setup. FYI, my reason is to keep my professional files and system off...

Hi, I installed a second HD, a Seagate 120 gb, on my Dell 4550. Both drives have XP Pro installed. Is there any way I can choose which disk to boot from other than changing the jumpers? FYI, my reason is to keep my professional files and system off the Internet. Rest of family can use the...

Hi, I have a mail merge document with the merge data coming from Access. Based on conditions of the data, I want certain pages of the document to not print. Is this possible. If so, any help is appreciated. Best regards, Henry

Hi, How many subforms can be heirarchically linked in a one-to-many relationship using Access 2000? I found it once upon a time and searched help but can find no answer. Best regards, Henry

Hi, We have many PDFs stored on a network. I would like to develop an application that makes it possible to select a PDF and then print it - preferably in a particular order - from within Access. Does anyone have any experience or ideas on how this could be accomplished. Best regards, Henry

Hi, I have a Word/Access mail merge document where a field in the database contains about 600 characters. When I merge this into Word, the text stops at 255 characters but then continues on with question marks like this: The field starts like this and ends ???? ???? ????? ? ???? The Access...

Hi, I am looking for a FAQ or some general direction on the following: I have a query from which I need to export many spreadsheets of data based on criteria stored in another table. Currently, I am using a combo box on a form as criteria but this is labor intensive. Also, I am familiar with...

Hi, Just wondering if anyone has experienced this in Access 2000 Visual Basic Help. After typing "QueryDef" (and other key words) a long list of topics appears but very few, mainly at the bottom of the list, actually link to anything. I assume this is the result of some error or conflict local...

Hi, I am trying to format carraige returns in a mail merge document using data from Access. I found some information that recommended using '^p' but this does not work for me. Any suggestions. Access and Word 2000. Best regards, Henry

Hi, I have a report based on a query that uses a combo box on a form as a criteria parameter. The parameter is: Like nz([forms]![frmRptCatDate]![combo],"*") I learned about Nz doing a search on this great forum, thanks everyone. If no selection from the combo box is made, all records print...

Hi, If all the required fields in a parent form do not have values and I try to enter a value in the subform, I get the following message: The field tbl.field cannot contain a Null value because the Required property for this field is set to true. Enter a value in this field. I understand why...

Hi, Upon opening a Quark document, a missing font was reported. I checked to see of the font was loaded and it was. In Quark, I used the font utility to replace all instances of the font with the same font. Quark crashed. So, I figured I would reinstall the font but I cannot delete the existing...