Recent content by HardCode

No matter what code examples I use from this forum, I cannot get a form to stay on top within the Access .MDB (I am not running it from an .MDE). Here is the code that I am using. Does anyone see anything wrong? In a module: Private Declare Function SetWindowPos Lib "user32" (ByVal hWnd As...

I did replace the # with single quotes as I was experimenting. Same problem. I'll need to try CurrentDB.Execute.

I am not using any BLOB data types as stated in that KB article, but since I searched on "Catastrophic Failure, as opposed to Error :eek: this time, I found this article which may be more in line of what I am seeing happen, but it states it was fixed in MDAC 2.5. I am using 2.8 :confused:

I have this code below that I am running in a form's code page: Private Sub UpdateConcept() On Error GoTo ErrorTrap Dim SQL As String SQL = "UPDATE ConceptMaster SET " SQL = SQL & "ConceptName = '" & Trim(Me.txtName) & "', " SQL = SQL & "ConceptDesc = '" &...

Thanks for your response. Seems like I made a critical error ... I assumed *blush* I assumed our network admin upgraded the PCs to WinXP Pro with SP2, which includes ADO 2.8, which my app uses. It turns out that while he pushed out SP2 on MY new machine, the other users only got SP1. So, no SP2...

Deployment: .MDE works with Office Pro not Standard Here at work, we have upgraded from Office 2000 to Office XP (2002). We use Office XP Developer to develop our Access application. Our client PCs use Office XP Standard on WinXP SP2. Certain parts of the code work fine in the development...