Recent content by ECEstudent

But doesn't that mean it'll take longer for my program to compile bc it'll be importing/exporting even more data (data that I may never even use in that code)? Wouldn't it be easier to focus on just a few columns and just export the related values out to them? By a simple query you mean just...

Here's the source I found: http://www.vbforums.com/showthread.php?376693-Export-from-ACCESS-to-Excel-using-VBA

Hi guys, I am really stuck on this and I would appreciate any help. What I have been doing in my code so far is importing an Excel sheet's data into an Access table in order to use the values imported for calculations. The end result of this code and all of the calculations in it, is a value...

I had posted a long time ago about this problem here but with no luck... http://www.access-programmers.co.uk/forums/showthread.php?t=252704

Resume next jumps to the next line after the line of code it got stuck on. What is basically happening (to result in error 3146) is just a connection fail because the ODBC runtime is low or the server is busy. I still want that line of code to COMPLETE what it's doing but according to what i'm...

Does anyone know what is wrong with this line of code: If Err.Number = 3146 Then 'For an odbc timeout SendKeys ["{F5}", True] 'pressing F5 so the code would go on End If I keep getting this error: Run-time error 2465, Microsoft Access can't find field 'l1' referred to in your expression.

The reason I'm doing this is because I want to get the error code from the error message so I can use it in my code to tell my program what to do in that case.

Ok. I've been trying to test this out for a while now and my DB is behaving awfully well lately! Which is great! Except I'm worried it won't be like this once I submit my code in to my supervisor...Does anyone know how to TEMPORARILY change the connection timeout value? I found this source (...

Hi, I'm trying to get values from an Excel file by its row and column. The row and column column names don't change throughout different files, but their locations do, thus I cannot really search for them through their numbered/alphabetized location (D:8)...I can only search the values through...

Sure. The connection time out happens randomly throught the day since it depends on how busy the company server is. So......I'm not completely sure how I would test that but I'll try. Thanks you guys. I'll give it a shot and let you know!

TJPoorman it was a connection time out! Would my suggested code still work though or would I just say 'Resume'?

Dim intCounter as Integer On Error GoTo errHandler 'Code here Exit Function errHandler: If err.Number = 1234 Then 'Change to error code .SendKeys({F5}, Wait) Else msgbox "Error whatever" End If

Oh ok. Like this then: .SendKeys({F5}, Wait) Right?

Also, where would I include the ' On Error Goto ErrHandler ' ? The whole need of pressing button 'F5' can happen anywhere where my code is referring to a SQL linked table. Would I just include it everywhere there's a reference?

Ok. So far I understand what to do when there's a specific type of error... On Error Goto ErrHandler: N = 1 / 0 ' cause an error ' ' more code ' Exit Sub ErrHandler: ' error handling code Resume Next End Sub But I still don't understand...