Search results for query: *

Hi, I used a variant to copy a whole range of cells and store them. I was wondering if there was any way to redimension or convert it into an array of doubles. Example: dim myvariant as variant dim convertedarray() as double myvariant = range("A1:D10").value 'this is where i would like to...

Hi, I am wondering what a hash table is. Is it similar to a database but in memory?? can anyone explain this? thanks

Hi, I am working on some legacy code and i encountered a strange call. Anyone know what this means? Mean_Cell(1).Dark_diode.dbl_T = 0# ' These are set later. in this code i am specifically wondering what the '0#' means. Is it some kind of a call or something, or maybe a variable? thanks

Hi, Is there any way to copy an array to another array of the same size as long as they are both defined the same. Oh, I would not like to use loops or using a variant type array for the second one recieving the data. Any way to do this? thanks

Hey, I just wanted to know how many fields can i put into a recordset type variable. Is there a limit on how many fields or can i just use the same recordset for all the fields in the program(there will be several hundred)?

Hi, I was just wondering how to delete a specific record out of only one table in a database that has multiple tables. Is there any way to do that? Ive tried it but the only thing that i figured out how to do is delete a record out of an entire recordset...recordsetname.delete . This, however...

Hi, I have a Access database that im using ADO connections to communicate with. I am having a problem with deletion of a single record in a table. There is a dropdown combo box that i use to choose which file to delete. This combobox, called "combo1" is filled with the "name" field of each...

Hi, I just wanted to know what is the difference between the two styles of database code: Style 1: Dim adoConnect As ADODB.Connection Dim adoRecordset As ADODB.Recordset Private Sub Form_Load() Dim sql As String Set adoConnect = New ADODB.Connection adoConnect.Open...

Hi, I have a program that i want to access two different tables in an Access database using ado connections. These tables in the database have a relationship. The first table (setuptab) has just 3 fields right now: setupID (primary key), setupname (name of the setup), and cellid (foreign key to...

Hi, I am trying to take a set of values from a spreadsheet and go from memory to the spreadsheet and spreadsheet to memory. Suppose we take an already made array of values...lets start with a one dimensional array of like 20 elements. We'll call it myarray(1 to 20). Is there any way to put the...

hi, i created an addin in excel using vba. it works fine on one computer, but when it is transferred to other computers, this strange error pops up. Any ideas on how to fix it? thanks

hi, i have a combo box that has about 500 items in it. These items have some duplicate entries in them. I was wondering if any of you know maybe an algorithm that would loop through the combo box, find the duplicates, and for each duplicate found that name would be added to another listbox. Oh...

Hi, I have a combo box filled with about 500 items in it. I wanted to loop through my combo box and if there is a duplicate entry in the list, i want to put that name into a listbox. My listbox will be sort of a list of duplicate entries for use later in the program. Is there any way of doing...

Hi, I would like to search through a specific folder on the hard drive (which i already know the path) and use code to search through every file in that directory and populate a dropdown combo box with the names of every file in the folder. Is there any way to do this with vba? thanks for the...

Hi, I have made a statusbar in my excel macro to tell the progress so far. I was wondering if there was any way to change the color of the statusbar font to another color...say red for example. Can anyone help me? code used for statusbar application.statusbar = "Please wait..." I would like...

Hi, I was wondering if there was any way for vba code to automatically minimize all the open workbooks when i press a button on a form. Example: lets say that i have 2 open workbooks and i run my macro and part of that macro i want to minimize all open workbooks at the time. The only thing is...

Hi, Im using the ahtCommonFileOpenSave dialog box but it keeps popping up in the upper left postion on the screen. Is there a property that i can use like centerowner in a form that will make it only pop up in the center of the screen? thanks

Hi, I have a field in an access database that i would like to search through and find a match for some text. I know that the match exists, which i checked before this part. I would like to search through the database and find this specific name in a field called 'setup'. How do i direct vb6 to...

Hi, I have a small problem. I would like to create a delete routine in visualbasic 6.0 that takes an access database that has the primary key as 'ID' which is an autoindex integer that becomes disorganized as records are taken out of the list. I would like to take the index number, and press a...

Hi, I have a question about sorting some data and taking some values from my spreadsheet into variables in a program. Here is my problem: Suppose that i have three rows (it could be more, but for this example, that's all i need). These rows are filled with numbers. A B C D...