Recent content by Darth Vodka

use debug.print to stick your sql in the immediate window, then copy the sql into a query

hi i know how to check the connections on an Access db in VBA Dim rs As ADODB.Recordset Set rs = cn.OpenSchema(adSchemaProviderSpecific, _ , "{947bb102-5d43-11d1-bdbf-00c04fb92675}") then rattle off the recordset what i want is this in vb.net... and i'm struggling, can anyone...

i have this if you want it (or use the "dir" bit) Public Function FileExists(strFile As String) As Boolean If Dir(strFile) <> "" Then FileExists = True Else FileExists = False End If End Function

we have similar issues here. but with 97 & 2003 we tend to make users use shortcuts and explicitly name the file to open it with e.g. "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "\\servername\share\somedatabase.mdb" is a 97 one and "C:\Program Files\Microsoft...

hi for a lot of our Access 97 databases, the end users send a report by clicking the "send as attachment" from the usual toolbar when in a report for some reason, this has now started going wrong with "can't send a message for the reason stated in the preceding alert" googling seems to...

Bruges? They're filming midgets! :)

that's what i thought, but i've actually got an issue of not setting to nothing (and maybe an issue with variable scope) actually losing me records from an append, which is harmful... i can't post the db in totality i'm afraid agreed, i didn't write it, i was only looking at it for the team...

yes...first thing i looked for. i shortened the code, there's tonnes of it

:) it's never set to nothing after being used and it's declared many many times and for some reason, setting it to nothing within every procedure works...and when it doesn't work, it still runs but append less queries...or maybe it's deleting more there's two lines when the function is called...

there's a database at work and it sets the variable db to CurrentDB about 100 times... db is declared in every module and the code is one big rant db is never set to nothing... at one point there is a db.execute "qry_someappendthing" and if it runs it totality, it appends 400 records. if the...

hi all just wondering... i know everyone always says to set the object variables to nothing at the end... but what sort of error could this cause? or is it just good house keeping?

or define C as nz(tbl_Whatever.C,tbl_Whatever.B)

in the visual basic editor> debug>compile Accessdb

does it compile?

if you want ADODB, use 2000 and point it at a 97 database in the code when you set up the connection object...(got code if you want) i cant think of a way of definitely tracking the back end (possible in SQL server though!) all i can think of is logging access to the front ends and recording...