Search results

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

Both of those appear to go WAY beyond what I need to do. I don't need to re-link them or do anything to them. I just need to find out of the linked table is online. I have no preference between DAO or ADO. Essentially this is a check that runs when the front end is opened to see if the SQL...

I found that one too and frankly it confused the hell out of me.

I need to check (through VBA) if a linked table is online or not. The linked table is attached to a SQL server using an ODBC connection string. If the server is offline or unreachable is what I am using to trigger other code. Anyone have ideas? I have been googling all morning with little...

I have been putting together a way to re-link ODBC linked tables through VBA in Access. At times our server name changes so this code will prompt the user to provide a new server name without requiring the user to get involved with the linked table manager or using a DSN file. Just tie this code...

The first thing that jumps out at me is that you called the file name but not the location. sFile = "email.txt" should include the path not just the name.