Search results for query: *

Hi all, I've got the following code which performs a find on a worksheet looking for a value held in the variable strCont: Cells.Find(What:=(strCont), After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _...

Hi all, I have the following code which should take the information held in column A and input it into a sql server table: Sub InsertRecords() Dim DB As DAO.Database Dim stList As String Dim R As Range Set DB = DBEngine.OpenDatabase("SQLSvr", _ dbDriverNoPrompt, True, _...

Hi all, I'm looking to use the clean command on a single column rather than a whole worksheet. Can I do this? I've got the following code so far: [Code] Sub cleanup() Dim TheCell As Range For Each TheCell In ActiveSheet.UsedRange With TheCell If .HasFormula = False Then...

Hi all, I'm looking to update a table in SQL Server with information held in an Excel spreadsheet. I want to be able to do this by clicking a button in Excel. I don't want the user to have to go into SQL Server. I know it may be possible by calling a DTS package but do I need SQL installed on...

Hi all, I have a dataset called dsStage. This dataset contains two tables - Stage and StageSub. I have created a relationship between the two... This is called relstage. I used the following code to create the relationship: Dim relStage As New DataRelation("StageRel", _...

Hi all, Can anyone tell me if I can use VS.NET 2003 with the .NET Framework 2.0??? I want to use the datagridviewer that comes with 2.0 with VS.NET 2003..... Can this be done and if so how? Thanks in advance.

Hi all, I've got a column in Excel with the following data in it: 895001A 78390 783429 34224 3345G 435764F Etc... I need to remove the final character if it is a letter. They can be different lengths and some values may not have a letter at all but if a letter is in the string it will always...

Hi all, I've got the following query running in Excel. With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ "ODBC;DSN=SQLSvr;Description=Connection to SQL Server (SQLSVR);UID=sa;PWD=password;APP=Microsoft Office 2003;WSID=SWOODWARD;DATABASE=FMDB;Networ" _ )...

Hi all, I currently use the code below to save an Excel spreadsheet as a csv. ActiveWorkbook.SaveAs Filename:= _ "J:\Projects\Great Plains\POHDR.csv", FileFormat:=xlCSV, _ CreateBackup:=False However, a user now requires the file to be saved with todays date added onto the end of...

Hi all, I'm trying to view a report using ePortfolio Lite over our intranet. The report uses a view that I have created in SQL Server 2000. When I run the report locally using Crystal Reports 9 the report runs fine. However, when running the report using ePortfolio I get as far as the...

Hi all, I have a decimal field that I would like the user to be able to query using a report parameter. I want them to be able to add values such as: >10000 <10000 10000 Can this be done? I want to do this using one parameter rather than setting up 3, one for each possibility (i.e. greater...

Hi all, For the purposes of sorting, I want to change a text field into a number field so that 10000 will come out after 12000 in ascending order. How can I do this? I've tried just changing the field properties but that, obviously, doesn't work.... Any ideas? Thanks in advance, Woody

Hi all, I'm trying to run a query that uses two date parameters from user input. This is my code for the query: With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ "ODBC;DSN=SQLSvr;Description=Connection to SQL Server (SQLSVR1);APP=Microsoft Office...

Hi all, I am looking to fill in the dates in the following query by taking values entered into a text box. My query is: With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ "ODBC;DSN=SQLSvr;Description=Connection to SQL Server (SQLSVR1);APP=Microsoft Office...

Hi all, I'm currently running a simple script which saves the current Excel worksheet as a csv file. Here is the code: ActiveWorkbook.SaveAs Filename:= _ "J:\Projects\Header.csv", FileFormat:=xlCSV, _ CreateBackup:=False I am getting a problem with this in that I require all...

Hi all, How do I do the following in VBA for Excel date formats? I have a cell with the date value 25/11/2005 However, I want this cell to ignore the 25 and simply say Nov2005. Can this be done and if so how? Thanks in advance. Woody.

Hi all, I'm from the UK and therefore want my currencies and dates in UK format. However, at present all currencies are coming out as UZ $ and all dates are also US format. I have changed the Micrsoft Office Language settings to UK and my computers reginal settings are also UK... What else do...

Hi all, Is it possible for me to use one parameter to actually filter two fields? If so how?! Thanks Steve

Hi all, I'm relatively new to Reporting Services so bare with me! I am trying to us a parameter upon my report. This parameter does not have to be filled in by the user. In the field that the parameter is running upon there are both NULLS and values. When the user enters nothing into the...

Hi all, I am pulling some data out of SQL Server and into Excel but I am getting some annoying Carriage Returns and Lin Feeds in some of my fields.... I know that Carriage Return is Chr(13) and that Line Feed is Chr(10) but how can I write some code to get rid of these throughout my...