Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cthaxter
  • Content: Threads
  • Order by date
  1. cthaxter

    All permissions revoked. Recover?

    In setting permissions and accounts, I assumed the Admins group had all the administrative permissions. It didn't; the Users group had those. Instead of setting up all the users first and then revoking permissions from Users, I first revoked permissions from Users. I only did this for tables...
  2. cthaxter

    XML and XSL to HTML: Problems with well formed structure

    I'm trying to transform XML via XSL to HTML using xslt_process(), but I'm getting an error saying the XML or XSL is not well formed, but I don't get any further information than that. Does anyone do this successfully? It's likely that my headers need to be set up a certain way, but I have no...
  3. cthaxter

    Printing Book Lists

    It seems that book lists always print as separate print jobs, rather than as one. Is that true, or can they be sent as one print job? In other words, if you set up a book list with ten different component files, and then you go to File/Print to print the whole thing and you choose "print...
  4. cthaxter

    Reference Excel fields over ADODB

    I'm trying to connect to an Excel file through ADODB and manipulate it like any other database. The following code from http://support.microsoft.com/default.aspx?scid=kb;en-us;Q195951 works just fine: Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open...
  5. cthaxter

    Parameters without stored procedure

    I've tried in vain to search for examples using the parameter object of ADODB without using a stored procedure. How do you use a SQL statement in one's code, using parameters? See this Microsoft Support topic to see what I mean: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q200190...
  6. cthaxter

    Use an Excel add-in in a VB application?

    I'm trying to utilize the Solver add-in from Excel, within a standard EXE. I can't get the Solver code to compile. If I were in VBA in Excel, I might have solverreset solverok SetCell:="$C$6", MaxMinVal:=3, ValueOf:="180", _ ByChange:="$C$4:$C$5&quot...
  7. cthaxter

    Highlight your Inbox when subfolders have unread messages (Outlook)

    If you have (or want to have) rules set up in Outlook such that you have new messages automatically filtered into various subfolders within your mailbox, you would have to always have your folders fully expanded in order to see which folders have new messages (causing those folders to be...
  8. cthaxter

    Compile error: Automation error

    The problem: On my machine and two others, there is a "compile error: automation error" when attempting to run code in an Excel 2000 workbook. This doesn't occur on a dozen other machines. The situation: I am part of a three-person development team on an Excel workbook that launches...
  9. cthaxter

    Generate or modify VBA on the fly?

    Is it possible to generate or modify VBA code on the fly, i.e., at runtime? I'm using Outlook 2000, and I want to run a certain procedure at Startup, but only once a day at Startup, not every time Outlook is opened throughout the day. I thought the best way to do this would be to modify the...
  10. cthaxter

    Where is the insertion point in Word?

    I am trying to execute a Selection.Find in MS Word and then return the exact location relative to the beginning of the document. Let's say I have two instances of the word "computer" in my text, and two instances of the term "computing". I want to find the first instance of...
  11. cthaxter

    Finding a record in Access through VBA

    I'm having trouble getting the Find or FindFirst methods to work in Access 2000. Here's what I'm doing. I'm comparing the items in my Outlook calendar with a table in Access, where both of them have similar fields, and I'm using the EntryID field to compare them. However, when I run the code...
  12. cthaxter

    Resolve All Recipients in Outlook

    In Outlook, when you create a meeting item, you invite people to the meeting. You hit CTRL-K or the Check Names button, and Outlook will find that person in the Address Book or not--in which case it will give you a dialog box with names from which to choose. But I'm doing that in VBA. How can...
  13. cthaxter

    From Address/Send on Behalf Of in Outlook

    I am using Outlook 2000, as an individual only, not connected to a network. I therefore have an Accounts option under the Tools menu, but no Services option. With that in mind, here's my question. I have several accounts set up, and I want to be able to send from one account or from another...
  14. cthaxter

    Security issues with .js file

    I'm wondering what experience people have with .js files and security issues. Is using .js files as opposed to leaving the script in the html files a good way to hide one's script? I tried downloading someone else's .js file by looking at the source of the webpage, looking at the <script> tag...
  15. cthaxter

    Return a string with a frame's source

    I need to perform certain actions based on which page is loaded in frame &quot;main&quot;. These actions (such as document.write) will be performed in frame &quot;leftnavbar&quot;, where &quot;leftnavbar.html&quot; will always be loaded. &quot;main&quot; might have &quot;aboutus.html&quot...
  16. cthaxter

    Load two frames from one link

    This seems to be a very basic problem, but I haven't yet found the answer. I'm using Internet Explorer 6.0, but obviously it would be nice for the script to be useful in as many browsers and versions as possible. I have a frameset with a navigation header across the top, then a left navigation...
  17. cthaxter

    Can mailto code include subject and body?

    I am trying to compose a message by typing directly into a browser's address bar, or by using HTML code. Is that possible? I know that you can add the subject: mailto:someone@greatdomain.com?subject=How%20are%20you but what would the syntax be to tag on the body? Or, if anyone has a...
  18. cthaxter

    Interesting: Fill out form on webpage using VBA in Outlook

    Has anyone done this before? Any pointers? Here's what I'm trying to do. Based on certain information housed within my mailbox in Outlook 2000, I want to go to a website and fill out a form there using the information that I have in Outlook. How do I reference each form control on the...
  19. cthaxter

    Loading an Access db and running reports on a different machine

    I'm having trouble running reports on a different computer in the network at my company. Other computers have no problem running my database, except for one--and it is running Access 2002. I'm running Access 2000, although some of its tables happen to link to an Access 97 database. I've been...
  20. cthaxter

    What record is active in an Access form?

    How can I return the record number that I'm in if I'm in a simple Access form? I want to use the docmd.gotorecord statement to navigate throughout a form, but first I need to know on the fly what record I'm in. In other words, if I'm in record number 6 and I run the code, I want to be able...

Part and Inventory Search

Back
Top