Search results for query: *

hey, well there are some reasons. First, im trying to get around the fact that it takes lots of time to access each cell one cell at a time. That is why i copied the range to a variant. The reason that i want to convert them to doubles is so that i can perform operations on them like a normal...

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 All, There is not referencial integrity between the primary table and one of the others, however the ones that are getting uncalled for deletions are just simply related but dont have any referencial integrity. I think they are getting deleted because they are part of the recordset and im...

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 dont know if the default properties are bad or good, but i definately am going to try to use the code that you guys recommended. Is there a website or maybe a good book that i can buy to learn how to use ado better? I would like to learn about that alot more, thanks

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...

hey man, thanks, that worked perfectly. This whole database thing is like trying to learn chinese or something. If I wanted to add more text boxes and have those records associated with the setup...lets say i wanted to add some other catagories besides cellname, lets say like fruitname and...

marksweetland, heres the code im using: Dim adoconnect As Connection Set adoconnect = New Connection adoconnect.Open "PROVIDER=Microsoft.jet.OLEDB.4.0;" _ & "Data Source=C:\mydb.mdb;" Set adoRecordset1 = New Recordset Set adoRecordset2 = New Recordset adoRecordset1.Open "select...

Hey, Marksweetland, that solution that you posted worked pretty good. The only thing is that instead of leaving the recordset the way it looks in the table, it sorted the data by name so that the setup name doesnt correspond with the actual cell associated with it...here is what i mean: Table...

Hi, I have some code here and i was wondering if anyone knows what the heck im doing wrong?? adoRecordset2.Open "select celltab.Cellname from celltab where setuptab.cellid = celltab.CellID", _ adoconnect, adOpenStatic, adLockOptimistic in this piece of code, im trying to open a new...

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 tony, I was wondering if there was a way to pick out a value that is in a variant type variable...similar to taking a specific value in an array, and performing an operation only on that specific place in the array, or variant. By the way, what is a variant...is it similar to an array, or is...

hey guys, i figured out that if you wanted to copy a range of cells from one range to another, it is much faster to use a variant. Suppose i want to copy a1 to c1000 and put it in d1 to f1000 in the code below: dim myvar as variant dim bottom as long bottom = 1000 myvar = Range("A1:C" &...

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...

thanks, that worked...seems as i accidentally checked a library that i didnt even need in the project.