Recent content by Tango

Oddly enough it worked under 2010 and 2007 until eventually I started getting "unrecognized database type" when trying to open it under 2007. I *noticed* the error in question roughly about that time. Unfortunetly I can't say for sure when it started. I keep a backup of every version of my...

Could it be something odd from the Access 2007 - Access 2010 conversion?

For the record, I am still having this problem. Anyone have ideas?

I use the code below. Dim suser As String Dim sSQL As String Dim CurUser As String suser = Environ("username") 'Name of real person 'MsgBox "sUser = " & sUser 'MsgBox "curUser = " & CurrentUser() I should point out that our network pulls the username from a physical...

Had to edit the script to make it reflect the office 2010 folder location but otherwise it worked great. Unfortunetly it did not fix the problem though. Any other ideas?

No VBA, on this form. I will try the decompile route.

I have a simple form based on a one-to-one query on two tables. For some odd reason it suddenly started acting "strangely" and I have not been able to nail down why. The first field on the form is automatically selected (normal). When the form is open. The problem is that if you attempt to...

That matches what I am seeing from the compiler. Makes sense too.

but when I did that it gave me a syntax error "expected=" and wouldn't compile. I think it was looking at it like I was setting a variables value.

Just tried Call and it compiles. now to see if it works.

It gives an "expected =" syntax error if I remove the word "Run".

Evening guys, I have a user getting a runtime error on the below code (near the bottom "RUN LINKDB()" is where the debugger highlights. It works great on my computer but for some reason not on his. I checked all his reference libraries and they match mine. Any thoughts? The on load code for my...

Ok, I solved it myself. I had to keep the data type for both fields as a "Fixed" data type. I converted it to a percentage in a 2nd query after the filter operation was complete.

I have a query that returns a percentage in one column. I have an open form with a text box that has a format set to percent and for some reason when I set the query criteria to point to the open form field using a >= it just ignores it. The criteria I am trying to use is as follows...

Jackpot, I cracked it and without adding or editing tables! curtbl = CurrentDb.TableDefs("help table").Connect On Error GoTo con_error Dim cnn As ADODB.Connection Set cnn = New ADODB.Connection 'Set the provider property to the OLE DB Provider for ODBC. cnn.Provider =...