Recent content by bkkbkk83

As I went through the code line-by-line, I figured it out: I wasn't returning the "simprot" recordset to the first record after looping through it, so when the second protein went through it reached the EOF marker in the recordset and just kept hitting that marker--which returned a 440...

You're right...there is another error hidden behind the 440: the message box traps a "No Current Record.DAO.Recordset" number 3021 error. Sometimes it catches an "Item not Found in this Collection" error. With error trapping turned on, though, I'm not sure which line is...

I just tried turning Option Explicit on and making sure that all of my variables were defined in a Dim statement...but that still doesn't seem to make any difference; I'm still getting the same 440 error.

Yes, similarproteins is a local table--it's part of the local Access database I'm working with. You're right; the code crashes right after I deal with the firstsim and nosim variables. It hangs on "CurrSearch = "libview.cgi?id=" + rstsim!proteincode", which comes right...

Hi-- I just finished coding an Access sub. Every time I run it, it will go through the first iteration of the "For a = firstsim To nosim" loop and save all of the data correctly. But on the second iteration, it inexplicably stops and returns a 440 runtime error "Automation...

Hi-- I currently have a For loop in my VB program that uses records from a table to create search strings. The program then parses a HTML document to find this search string and pulls out some data. I'd then like to save this data in a field by the same name as the search string in another...

Hi-- I have two laptops, one a Dell running XP Pro and the other a Mac PowerBook running OS 10.2. At college, I only have one Ethernet port. I must register this ethernet port every year...after a registration period, the ethernet port is locked to the computer's MAC address and an IP address...