Recent content by Jdoggers

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