Search results for query: *

Hello, I'm new to using reporting in VB2005, so wonder if anyone can help?? In my application I've created a dataset at run time (therefore have no datasource set up). I want to report on the results of this dataset and produce a couple of graphs. I was wondering what would be the best way to...

I've just ordered an Arctic Freezer 7 Pro cooler to replace the Intel heatsink that came with my new socket 775 processor. I've always previously used the stock heatsink that came with the processor however this time I've been experiencing some very high cpu temps (around 90 deg when loading...

Hi This is probably dead easy, but in powerpoint vba how do I find out the name of the current slide? Is there not something similar to Excel's acitvesheet.name property? I've tried ActivePresentation.Slides.Name, but this requires the slide index, I probably need determine the slide index...

Hi there I have a user form in Excel 2000 which has a list box, the data source of which is a selection of data in an excel worksheet. I also have a chart on this worksheet. I would like to display the chart on the user form alongside the list box. I've looked at the controls available and...

Is it possible to create an array of user forms in excel vba, like you can do in Viusal Basic? I have a spreadsheet which contains 175 questions, these are to be split onto approx 20 user forms. I'm fine with creating 20 forms up front, but if the end user chooses to add, say, another 10...

Hi there Using the vlookup function I need to lookup values in a different workbook, the problem I have is that the workbook which contains the values has sheet names which are enclosed in square brackets (eg "[Sheet1]". This is because the data in the sheets is loaded into a...

Hi there Can anyone help me out the the code needed for when the user clicks a command button within a form on database1, it opens up a form on database2. Both databases are held within the same path/directory. I have managed to open database2 using: Dim wsp As Workspace Dim dbs2 As...

Hi there Bit of a difficult one to explain, but here goes.... I have 5 sheets in my workbook, the first sheet is a summary sheet which contains data held on any one of the the other 4 sheets. The user selects which sheet they want to see data for via a combo box. I then populate a cell...

Can anyone help me out with the code needed to write data (3 fields) contained in a DAO recordset in Access to a .txt file. After each line I need to put a carriage return. I guess I need to loop through the recordset writing each line to the text file, but I am not sure of the code needed...

If I choose to use the Microsoft Common Dialog Control 6 in an Access 2000 project, will the end user have any problems running the database, on a different pc. The reason I ask is that I recently created an Excel project and used the dialog control. The project was then sent to the client, and...

Hi there Does anyone know if it is possible to package an Access database/VBA application as a .exe file or something that enables the end user to run the project without having Access installed on their machine. I know this sounds a little strange, but I'm sure I have heard about this before...

Hi there I have created 2 list boxes on a form in Access. When the user clicks a command button I want the item they have selected in list box 1 to be moved accross to list box 2. I would also like the item selected to be removed from list box 1. List box 1 is populated by values in a table...

Forgive me if I'm missing something obvious...... I have an icon and an excel spreadsheet which I want to install on a client's computer. The icon contains our logo, so when the icon is clicked I want to it to open the spreadsheet. Is there a way of doing this without creating a shortcut to the...

Hi there I have just installed Windows XP Pro (a clean installation). I have updated all my drivers, my system is Athlon 1gig 512mb ram Hercules 3d Propher 4500 Kyro 2 graphics. Gigabyte 7ZXR M/B (updated with latest drivers) Everything is fine with Win XP until I run certain games, I have...

Our company uses 4 custom colour's for our corporate colour's, none of these are contained in the colour palette in Excel. Whenever we create chart's in Excel, we have to manually modify 4 existing colour's in the Colour's tab in Tools/Options. As we do this quite often, it is becoming a pain...

I have recorded a macro in Excel 2000 which creates a pivot table, this runs fine in Excel 2000, but when I run it in Excel 97 I receive the error message "Object doesn't support this method" on the following line: ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _...

I have recorded a macro in Excel 2000 which creates a pivot table, this runs fine in Excel 2000, but when I run it in Excel 97 I receive the error message "Object doesn't support this method" on the following line: ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _...

I need to import a large text file into SQLServer 7 (approx 400 fields), it is a fixed length file. Can anyone tell me how to specify the field positions when importing the data via DTS (eg. in Access I use an import spec). The only way I can see to do it in SQLServer is to manually drag the...

I'm pretty new to sqlserver....Does anyone know how to include the field headers when I export a view using bcp, I have managed to export the view (as a text file), but need to include the headers! Can anyone help? cheers

Does anyone have any idea of the performance I should be getting out of my Maxtor +60 30gb hard drive, my system specs are Gigabyte 7zxr M/Board, Athlon 1gig processor and 256 mb ram. I have run a benchmark test and the results I got were around 11000kb p/sec write and 20000kb p/sec read. I...