Search results

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

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

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?

hi we have an Access db with a lot of users ~100 in Bristol (note to non UK folks Bristol to London is 120 miles = 190 km) due to an IT policy, they have no LAN...they log into a virtual machine that is on a SAN and the database is sitting on a server in London unfortunately due to (we...

hi am i right in thinking that i need to open my "hello world" asp page on a folder on the webserver and i can't just open it from a bog-standard network drive? tried opening it...but no "hello world" :( edit: aaah, you can view the results in Visual Studio Web Developer without deploying to...

does anyone know the function(s) to do what REPLACE does in ss2005? :confused:

i have a little piece of code Sub publish_data() Const UNC As String = "\\opssvr01\dmi\" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "tbl_COMMODITY", UNC & "TEST.xls", True End Sub which crashes Access EVERY time it runs :mad::mad: in 2000 or 2003 format...

all i work in a team that supports ~100 Access databases (~90 of which are Access 97, ~10 are 2000) which are used thoughtout the day by 100s of people. several are business critical IT are telling us that the migration to Office 2007 is imminent and they are going to switch off all office...

:mad: am i right in thinking that if i have two parallel data flows into the same table then the first one to hit deadlocks the table and i have to do them in series? :confused: aaaah found the "lock table" option on the OLE destination component

hi i've declared a vairable varMinDate and now, in an OLE source component, i'm trying to use it like this:- SELECT Field1 FROM Table1 WHERE BusDay= @User::varMinDate but i haven't got the syntax right :( any ideas?

hi i can connect an Access db to Oracle via ODBC and see a table fine... but when i try and do this in a query in SS 2005, it doesn't like it giving me now i'm pretty sure one of two things is happening here:- 1) the database is set not to allow connections from SS? this seems possible but...

hi if i have a filter that says IIf([forms]![frm_Reports]![optBusDay],#19/08/08#,"*") what's the syntax to ge the * to work?

hi if i have a query that has an outer join in it and then a Dynaset (Inconsistent Updates) form on top... then you add a new bit of data on the (unpopulated) outer side of the data and it looks fine in the form but what it actuallly does is create a new record with a blank field (instead of...

anyone know the MSDOS to see the nested groups within a usergroup? using get group abcgroupname /dom gives me the usernames, but not nested groups :(

aaah error 2335 in this code:- Sub FormatGrid(strType As String) Dim strHeaders(1) As String Dim strSourceObjects(1) As String Dim strChildLink As String Dim strMasterLink As String Const GUITABLE As String =...

is it me, or is there rarely a need for class modules in VBA? or arrays for that matter... if i need an array or an object, i represent it in a table and work with that perhaps i'm sticking to what i know, but can anyone tell me where they used a class module because it was by far the best...

hi if i set up a batch file to open every hour and it copied a back end to a directory somewhere would the copying have any chance of corrupting the back end..? i'm thinking no...but i have suspicions

hi is it possible to convert all macros into VBA in VBA? i thought maybe the CurrentProject.Allmacros but can't find a convert method then i thought maybe Docmd.something, but no luck... :(

hi is there any way to search through macros? i know i could convert them all the VBA and then search that, but that's a pain thanks in advance

hi does anyone have any links to Stored Procedure Beginner Guide stuff? thanks in advance