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 Chriss Miller 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: Skie
  • Content: Threads
  • Order by date
  1. Skie

    Passing HTMLEncoded data to an IE window

    I know this is a clunky way to do this. But, I have a client-side application. The user types notes in it. Then there's a button to send those notes to a specific field in existing IE windows. Private Sub tsmiSendData_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...
  2. Skie

    Business', Business's, Businesses

    For a single business, not multiple businesses what is the correct way to make it possessive? I have a directive to change business' to businesses which looks wrong to me. "The business' income was ..." "The business's income was ..." "The businesses income was ...
  3. Skie

    Regex Parsing Question

    I'm separating lines of data it into key/value pairs. I have a regex to do this, but I'd like to expand it to be able to parse values with spaces. Shared Sub ByDelimiter(ByVal input As String, ByRef dict As Dictionary(Of String, String)) If String.IsNullOrEmpty(input) Then Throw New...
  4. Skie

    Money Regex

    I have the following regular expression (fairly simple) that is a good start, but I want to improve it and haven't found a good site to explain how to improve it. ^(0|[1-9]\d{0,2}(,?\d{3})*)(\.\d{1,2})?$ I'd like it so that if the comma separator is used, then it has to continue to be used...
  5. Skie

    Trapping user.config errors

    Say this file gets cleared or someone manually edits it and breaks it. Is there a way to trap the error? I've tried try-catch blocks on the properties, but it throws the error within the try-catch block. I figure I could try to read the file as XML first. If it fails, simply remove it. But...
  6. Skie

    RecordSet.Index and .Seek for multiple indexes?

    Is it possible to create and .Index for more than one column? With oRS .Index = Array("Column1", "Column2", "Column3") .Seek "=", Array("Value1", "Value2", "value3") If .NoMatch Then .AddNew .Fields("Column1") = "Value1" .Fields("Column2") = "Value2"...
  7. Skie

    Get code from corrupt DB

    Well, I have an Access database that corrupted after a compact and repair. I get the following error: I should've backed up the DB more often. I was able to import the tables and queries with no problems. Which is great, but I'd really like to be able to get the VBA code out of it. Is...
  8. Skie

    HTA talking to HTA

    I have two HTAs and I want them to be able to talk to each other. If they were IE, this would be pretty simple. Grab the object and then call scripts, populate fields, etc. from there. What I don't know is the code to get an HTA object.
  9. Skie

    Writing Page w/ASP

    How should I be formating my data (HTML? XML?) for pages built w/ASP? I'm using a query on a database to pull data, then writing 90% of the page. About the only thing I don't use a response.write for is informatino in the head tag. I'm currently using HTML, and it works for me. It's a bit...
  10. Skie

    Building page from ASP

    How should I be formating my data (HTML? XML?) for pages built w/ASP? I'm using a query on a database to pull data, then writing 90% of the page. About the only thing I don't use a response.write for is informatino in the head tag. I'm currently using HTML, and it works for me. It's a bit...
  11. Skie

    Class w/Class

    There's probably something simple that I'm missing, but I was to make a class with a class(es). I'd like to be able to use my class so that I can dot (.) into subsequent classes. But, I want the subsequent classes to still be able to use the functions, subs, and variables from the original...
  12. Skie

    Dictionary to Array

    I could've swore I've seen this posted before, but I can't find it. I know I can enumerate a dictionary to pull it into an array, but I was pretty sure you could also use the Array function to pull it into an array. Dim aArray() oDictionary = CreateObject("Scripting.Dictionary")...
  13. Skie

    Finding Best Penalty

    This is similar to the Finding small amounts from a larger total thread, but a little more complicated. Basically I have the following pieces of data: Due Amount Due Date Payment Amount Payment Date Penalty % (This is based on how different the Due Date is from the Payment Date.) Penalty...
  14. Skie

    Case When Where

    I'm using an Access database and I'd like to have a query use different WHERE statements based on the area. I'm fairly new to SQL, so I don't know if a case statement can do this or if I'm using it correctly. I could make two queries and join them in the third, but that seems like poor...
  15. Skie

    Query? Report?

    Let me start off by saying I'm new to Access. I'm able to do everything in an Excel workbook, but I'd like to be able to quickly and easily generate a report. I tried a search, but "query" and "report" bring up a lot of topics. I have no idea what words to combine to get the result I'm...
  16. Skie

    List of Quotes

    This is a stupid example but... People greet others by saying, "Hi," "Hello," and, "Hey." Is that the correct way to punctuate that sentance?
  17. Skie

    Open File (Windows Server 2003)

    The following code works great for WinXP, and it's been what I was using to present the user an Open File dialog window. Set oDialog = CreateObject("UserAccounts.CommonDialog") oDialog.Filter = "Sessions|*.edp|508 Sessions|*508.edp" oDialog.InitialDir = "C:\Sessions\" iResult = oDialog.ShowOpen...
  18. Skie

    Excel & IE Bug

    http://support.microsoft.com/default.aspx/kb/831200 I need Excel to close if the IE window is closed. Is there a way around this bug? Thanks
  19. Skie

    Int/Fix Bug

    Ok, I'm writing a script that deals with money amounts. But, I want it to simply drop fractions of a cent. So, I wrote the following code: Amt = 8.95 WScript.Echo "Amt = " & Amt Amt = Amt * 100 WScript.Echo "Amt * 100 = " & Amt Amt = Fix(Amt) WScript.Echo "Fix(Amt) = " & Amt Amt = Amt / 100...
  20. Skie

    Frame Element Events

    I'm trying to setup an HTA with frames. What I want to happen is when an item is checked in the first frame it moves to the second frame. The easy solution would be to use a list box, but the actual data I'll be using will be longer than a single row of a list box. Anyhow, here's my HTA...

Part and Inventory Search

Back
Top