Search results for query: *

Morning all, I am having difficulty opening a Word document from within a VB6 Project. The error I receive is: Run-time error '-2147417851 (80010105)' Automation error. The server threw an exception. I am relatively new to VB and have searched and tried suggestions with no success. I...

Relative newbie here with a problem. I have tried searching for a similar problem but seem to have had no luck. My problem is I have an Excel Worksheet with a macro that cycles through a colum and assigns the value of a cell that matches a value from elsewhere in the worksheet and stores it in...

Relative newbie here with a problem. I have tried searching for a similar problem but seem to have had no luck. My problem is I have an Excel Worksheet with a macro that cycles through a colum and assigns the value of a cell that matches a value from elsewhere in the worksheet and stores it in...

Hi guys, Newbie here again. I have a problem with being able to use a table I just created via code (visual basic, SQL statement and ado). When I try to open this table to use the records that were just inserted, I get an error message that the table is not found. When I look at the database...

Hi guys, Newbie back again with a question. We have a form which contains a combo box and a list box. Our objective is to populate the list box based on the selection from the combo box. One of the selections of the combo box is "(All)". We get the desired results if we select any single...

Hi everyone, Another newbie question. Is there a way to open a list of excel files, copy some data, close the excel file and loop to the next without having to close the excel application? The data is located in cells that are in various locations on the spreadsheet. Please, excuse me, I am...

Hi All, Newbie back with another problem. This is rather urgent, so any help would be greatly appreciated. The problem is we have a form with a command button that when clicked will search a table to see if a record exists, if not it displays additional text boxes for input. We tried using a...

Good morning all, Newbie back with another request for help. I am trying to link to a table in a second database to obtain data for populating a table in the current db. I am getting an error -2147217911 when I run that tells me "Could not create; no modify design permission for table or query...

Good morning all, I am brand new to ADO and am having a problem with understanding how to open a table (MS Access) using ADO in VB6 where the table being opened is for output and contains no current records. Is this done with a connection string? If so could you provide an example? If there are...

Hi everyone, Newbie back with another problem. This one is rather urgent. The problem is we have an Append Query that selects the proper number of records from the source table but does not append all of them to the destination table. We have no constraints of any kind on the destination table...

Hi All, Newbie is back with another question. We have a sub routine (code below) which we would like to assign visible and value (null) properties to the controls on a form. We need to be able to make some visible while others need to remain visible. <i> determines which ones will be visible...

Hi all, Another newbie question. We are designing a form which will have several text boxes displayed in a grid (e.g. txtSN1, txtSN2, txtSN3, txtSte1, txtSte2, txtSte3, etc.). Question: Is it possible to hide the boxes that will not be used at a given time by changing the control property to...

Hi everyone, Another newbie question. Is there a way to define a memo field, such as found in an ms access table, in SQL? We are developing a series of tables which will draw data from access. Some of the fields are memo type in access. Being new haven't found a way to get around this. Thank...

Hi guys, Another newbie question. We are trying to use ADO to link to an ODBC database. We are new to both VB and ADO and just can't seem to get this to work. This is the code we have created. When we run it we get the following error at the conn.Open... line: Run-time error '91': Object...

Good Day, Newbie question. Is there a way to design a form that would allow the user to select a record from form displaying records selected from a database and then have that selection open a second form where further details of the record selected can be displayed? If so can you provide an...

Hi, I am a relative newbie to MS ACESSS and I am having a terrible time trying to use DSUM in a SQL Statement to update a table. No matter what I do my answer gives me 0's for result. I am sure it is my newness and the answer is probably quite simple. But I am struggling. This is the code...

Hi, I am a relative newbie to MS ACESSS and I am having a terrible time trying to use DSUM in a SQL Statement to update a table. No matter what I do my answer gives me 0's for result. I am sure it is my newness and the answer is probably quite simple. But I am struggling. This is the code...

Hi All, We have an urgent need to resolve a problem. We are changing from Windows 2000 to XP and have an ACCESS database that is failing to work in XP. The database works fine in 2000 but in XP we get the error message &quot;Object invalid or no longer set.&quot; The error occurs on a subform...

I posted this question earlier today but forgot to note it as urgent. Sorry for the re-post, but we could really use some help quickly. If what we are asking can not be done, please tell us. Is it possible to select a value from an option group and have that value determine which query to use...

Is it possible to select a value from an option group and have that value determine which query to use for a subform? If so, can you provide an example of the code? The objective is to select 1 of 3 values in a selction group which determine different finacial data to display. I cannot be very...