Search results

Hi, I'm slowly being driven insane by dll's. I have included a number of references in my app that i am trying to distribute to another test machine. A few of these are SQLServer dll's that allow access to use DTS packages stored on the server. These are found in C:\Program Files\Microsoft SQL...

Hi, I've got a DTS in SS2000 that is a package of packages, 34 in all, that are importing data from an ERM. The idea being i can run 1 package individually if needs be and automate the main package for transfer at night and only have 1 chron job to worry about. The question is how many...

Not a suggestion more a question. I posted a reply to a thread on Friday from a user i believe was named msaccessgirl. Subsequently i can't find the thread or the user. I've searched my posts and on key words i knew were in my reply. Nothing. Has this user been banned? Can users delete...

Enjoy :) The House Cat The HipHop Cat The Metal Cats The Stevie Wonder Cat The Stoner Rock Cat The Techno Cat The iCat

Hi, Is it possible to use a temp querydef in a sql string? for e.g If i save a query and use it as a recordsource for a report i can do this. Dim Rpt as obj Dim StrSQL as string Set rpt = somereport Strsql = "Select TBL_VALUES.VALUEID from " & rpt.recordsource 'create recordset set rpt...

Hi, I am at the start of a project to re-develop a complex reporting system - currently 20+ access databases. The main issue is that Access has been used to hold the data from a third party database [that deals with all the business transactions] for reporting purposes. There is an ODBC...

Access 2003: Purpose: Allows you to use the windows login information User Name Password and domain to control access to a db via a form. I've hacked this together from various sources. If you set the form up as your display form Tools>Startup>displayform then it will be the first form your...

Hi, I'm trying to find the tag property of all the reports in a database. This may be hundreds so it's not really feasible to open them and at the moment that seems to be the only way to access this property. I want to try something like this but i can't seem to find the right syntax Dim Rpt...

Hi, I hope this is in the right section, it is form related but is i think more about design principles than an out right question of "how do i ..." I wondered if anyone has any thoughts on the best way of populating treeview controls? I'm about to embark on a re-development of a reporting...