Search results for query: *

Hi Everyone, I would like to filter a column based on more than 1 citeria. When the criteria is meant I would like the filtered data to be copied to a new spreadsheet. For example: If I wanted to filter the data where the age is 20 and 30, then copy these rows to a new spreadsheet. A...

Hello, I am trying to make changes to some very old VB code. I made the changes and tried to set up an installation package. I received an error message that no "setup" existed. Is there a way to create a new setup ... not the project's exe? Thanks a lot, New Programmer

Hello, I am trying to make changes to some very old code. i am opening the program using VB6. I tried to run the code and receive the following error message. I don't see anything wrong. Any suggestions would be appreciated. Dim dbStat as Database Compile error: User-defined type not defined...

Hello Everyone, I have a flat file, which is comma deliminted. Each field has double quotes around it. Except for the last field in the file. The last field of the file has no double quotes weather there is text there or not. This causing a Run time error '62' input past end of file. So, I went...

Hello Everyone, Does anyone know how to print a user form in landscape? Below is the code that I am using. Private Sub cmdPrintGeneral_Click() Me.PrintForm End Sub Thanks, NewProgrammer

Hello, I have added an ADO data control and a datagrid to my form by adding them to the toolbox and draging them to the form. This allows me to get data from a table and display it in the datagrid. The problem is that I have tried to run this program on two other Windows XP computers and the...

Hello Everyone, I am having two problems (that I am aware of) when closing my program. First, I have created an exit command button on a VB form. When the exit button is clicked, I need to close the VB form, Excel, and the Excel workbook. The code below leaves Excel open; however, it closes...

Hello, I would like to open an excelworkbook (named strfile). The code will eventually open the workbook. But, before it opens the workbook it will display the error message that "MS Excel is waiing on another application to complete an OLE action". Does anyone know what is wrong with my code...

Hello, I have created a form in VBA. I am using Windows XP and Word 2003 and some of the other users are using Word 97 with WIndows XP. I have set a reference MS Word 11.0 Object Library and MS ExceI 11.0 Object Library. I am able to run the program without any errors. If the users with a...

Hello, How do I clear a datagrid. It gets the data from an access database using a recordset, then displays it in the datagrid. Any ideas?

I am getting the data from an access database. How do I write a select statement that will return any values (like) that starts with the same letters the user enters into a combo box. This is the code I am using. But, it only returns the exact match. Please help! If cboModel.Value <> "" Then...

Hello, Does anyone know how to clear the data from a datagrid? Thanks, so much!

Hello Everyone, I have written code to open an excel file or either a word file depending on the option button the user selects. This code will open the word file. But, the excel file will not open. The objExcelfile always equals nothing. Any help would be appreciated. '************** Private...

Hello, How do I open MS Word and MS Excel from VBA? I have the path and name of an excel file and a Word file saved in an access database. I have used a data grid to display the file names from the access database. When the user clicks on the row in the datagrid. I would like to open excel or...

Does any one know what irow does? 'open the record set and search for contents in the combo box Set Rs = db.OpenRecordset("SELECT * FROM tblFileName WHERE Manufacturer = " & cboManufacturer.Text) Rs.MoveFirst irow = 3 Do While Not Rs.EOF Cells(irow, 1) =...

I am receiving an error. Error number 3061. Too few parameters. I don't quite understand the irow or if this is the best way to retrieve data from access and display the results for the user. But I'm trying it. I would like the user to be able to search for the Manufacturer, model, or Quoters'...

Hello, I have created an access database that receives the fields below from excel. What is the best way to retrieve and display this data to the user? For instance, if the user wants to search for all files with the same Quoter and Manufacturer. Thanks very much! ***************************...

Hello, I have the following code writing to an access database. I would like the users to be able to search on different criteria (for example model number , maufacturer,etc.) to retrieve the data. Does anyone know the best way to retrieve the data. Any help would be appreciated...

Hello Everyone, I am using VBA. I have created several excel spreadsheets. I would like to write the data from cells in excel to access database. I am using the code below. I keep getting a compile error. The program stops executing at the "Dim db as Database" statement. The error is...

Hello Everyone, I have created a VBA user form that has a command button. When this command button is clicked, it should open a form in Word that will be a summary sheet for the data entered on the form. The data on the form has been linked to cells in excel. How do I open the Word document...