Search results for query: *

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

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

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

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

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

Is there a way to select the data from the current quarter if all I have is today's date? Thanks, enak

I have been given the task of creating a rather large report. It contains tables and graphs of stock portfolios for each account. All of the data is contained in an Access db. I have never done CR before. I do not have to use CR but I thought that it would be the best way to do the report. I...

I have a large report that needs to be created from a database. The sample report is 94 pages. The report consists of graphs, tables, footers, headers, and at the end some lengthy text that is a summary of the data on the tables. My first thought is to use Crystal Reports that comes with VS.NET...

I am pulling some data from an Access database. There are two columns that are of the type currency. If I query the table through Access these two fields are formatted correctly as currency. However, when I execute the same query through a .net winform application the data is formatted as...

I am having problems with the listbox. I need to get multiple selections from the listbox. This is the code that I am using: Dim itm As ListBox.SelectedIndexCollection Dim i As Integer = 0 'Figure out which classifications have been selected. For Each itm In...

What is the best way to populate a combobox and a listbox? I need to populate them from a database. I can do it with the following code: While dr.Read Me.lstClassifications.Items.Add(dr.GetValue(1)) End While but I am not sure that I am getting id's along with the display value. I am...

Why can't I get the ExecuteReader to work? I keep getting the error: No value given for one or more of required parameters. What does this mean? I can connect to the database. Here is my code: Public Function getDataReader(ByRef sSQL As String) As OleDb.OleDbDataReader Dim myCMD...

I need to connect to a secure or password protected Access 2000 database. I am new to Access. I am using VB.Net as the frontend but I need to connect to an Access database. Please help Thanks, enak

I have an image that I have cut and pasted on a different background. I need to make it look like it wasn't cut and pasted. I think that I need to soften the edges of the pasted image. How can I do this? Thanks, enak

My home network is completely wireless. I have 4 machines on the network. Suddenly, my server can not access the network. I have checked the device through device manager and it is ok. I have uninstalled and reinstalled the drivers. Nothing works. I don't get any error message. I am using...

I am trying to create a text logo for myself. I am using Times New Roman, Bold Italic, 48 pt, Smooth. When I print it the edges are jagged and don't look good. I am using Photoshop 7.0. How can I fix this? Thanks, enak

My home network is completely wireless. I have 4 machines on the network. Suddenly, my server can not access the network. I have checked the device through device manager and it is ok. I have uninstalled and reinstalled the drivers. Nothing works. I don't get any error message. I am using...

I need to update a DTS package. One of the processes that it uses is deleting all of the data from a table. I have copied this from the production server onto a test server. I can not get the process of deleting the data to work. The DTS uses the following statement: truncate table...

I have an application that I use WebDAV to create calendar appointments and then send them out to the invitees. This works but when the invitee receives the invitation they must drag the appointment to their calendar in order for it to get set. I want to be able to set the appointment for them...