Recent content by TazzMann

Hello All! I have two objects, one that is read only and one that is read-write. I am trying to morph from Readonly to Readwrite. Below is the code I am currently using to morph: private void btnCreate_Click(object sender, System.EventArgs e) { try { m_roAddress = null...

Nevermind, I figured it out. For anyone who is interested, the code is below. Private Sub frmMain_Resize(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Resize If Me.WindowState = FormWindowState.Minimized Then Me.ShowInTaskbar = False End If...

Hi all! I added a NotifyIcon to my Windows application and it works fine with one exception: I need to remove the taskbar idication of the application when the application is minimized. I know I can set the ShowinTaskbar property to true, but what event is fired when the taskbar is...

Thanks donutman, I think that is what I will have to do. I don't care to correct the values from the spreadsheet cause in the final table, they won't be used, just their corresponding id number from the lookup table. But I may have to correct them in the intermediate table so that I an do a...

danceman, without an EXACT match, the join will never work. That is the problem I am struggling with. They way this whole thing works is: 1. A user fills out certain cells in an excel spreadsheet. one of the fields if for a Paid Time Off (PTO) plan type which is either 'Anniversary Based' or...

Oh SQLBill, I tried that, and it still did not find a match. Tazzmann

Well, donutman, the user might enter 'Anniversary' insead of 'Anniversary Based' so I want to match 'Anniversary' from the lookup table. (i.e. 'Anniversary%') Make sense? Tazzmann

No a Lookup cannot result in more than one match. An Example of lookup data would be the following: ID Name 1 Anniversary Based 2 Calendar Based The values entered into the spreadsheet would be either: 'Anniversary' or 'Calendar' Let me know if you need more. I am stumped...

I am trying the following code and not getting any results. The like is looking in a lookup table to see if there is anything similar to what is in the original table. The original Table is populated by a spreadsheet where the user may not enter the value exactly as it appears in the lookup...

Duh! Thanks. Works like a Charm! :-) Tazzmann

When I do this: Me!cboName.RowSource = "SELECT DISTINCT dbo.Table.First_NAME, dbo.Table.Last_NAME FROM dbo.Table Where Branch = " & intBranchNumber & " and Active = 'Y' Order by Last_Name, First_Name" The SQL text is what shows up in the combobox. This is Access 2003 and all the tables are...

Can anyone tell me what this is supposed to mean? "The setting for this property is too long" I get this error when I am populating a combo box using vba. I can post the code if needed, but it is simply pulling out a first and last name from a database, concatenating them and then using that...

Try: Printer.NewPage This tells any printer that you are done with the current page and move to the next page. Tazzmann

ok, well, then I am at a loss. The connection string is correct and I have checked it again for the 10th time today. We are going to try and import the user from the database that works to the one that doesn't and see if that fixes the problem. Maybe it is something that I just can't see...

Nah, the connection string is looking good, I have triple checked everything. They are virtually identical boxes, same make, model, operating systems, etc... All the security settings are identical on both boxes, all the same roles. I am at a loss. And yes I know it is not good security to do...