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