Recent content by enak

Thanks for the suggestions. I changed the * to % and it worked fine because I am using embedded SQL.

Here is the query: Select (tblAcctMgr.fname & " " & tblAcctMgr.lname) AS Mgr, tblAccount.ID From tblAcctMgr,tblAccount Where tblAccount.ClassificationID = 3 And tblAcctMgr.ClassificationID Like "*3*" AND tblAcctMgr.ID = tblAccount.AccountMgrID Here is the code that I use to get the data...

I have an Access 2000 database that I have put a Windows Form (VB.Net) frontend on. It all works fine until now. I have a report that I am trying to build where I have to retrieve account type data and from there retrieve account managers info. I use a datatable as part of a dataset to...

Doesn't anyone know what is happening here? I really need some help.

Has anyone been successful with working with Excel charts? I create a chart and place it in the existing spreadsheet as an object. I select a cell where I want the top left corner to be and when the chart is created it is in the general area but not in the exact spot. I need to be able to place...

.

I am sure that someone knows something about this. Any help, Please!

I am trying to put some Excel charts into a spreadsheet but am having problems with any type of formatting. Here is my code: Dim oChart As Excel.Chart Dim xlsAxisCategory, xlsAxisValue As Excel.Axes oChart = xlSheet.Application.Charts.Add...

This is the line that it is failing on: Set ctrl = Screen.ActiveControl

Thanks for the reply. I tried both of your suggestions and got the same error: "The expression you entered requires the control to be in the active window." The action will open a new window.

I have inherited an Access 2000 db and was asked to upgrade it to 2003. I did the convert to 2000-2003 format and it seems to be working fine. However, I have a listbox that when it is loaded an OnClick event is added. ctl.OnClick = "=ShowDaysEvents" When I click on the listbox I get the...

Thanks, that worked.

I have a table that I need to be able to delete some of the records. Here is my query: delete * from tblValues where AcctID = 13 and [Date] = #11/4/2005# and NetCashFlow = 297120.74 and MarketValue = 302030.00 The fields, NetCashFlow and MarketValue are currency fields. When I run the query...

That was it, thanks. I just didn't see it.

I have a listbox in a winform. It is set for multiple selections. However, I need to be able to un-select all of the items in the list. Here is what I am doing: For j = 0 To UBound(arClass) For i = 0 To Me.lstMgrClassifications.Items.Count - 1...