Recent content by SadOldGoth

Hi Folks, We're planning on migrating Active Directory from 2000 to 2003 - are there any known issues or problems that we should be aware of? Thanks for any help. Later, Jes

Hi Sucoyant, Here is the code that I use that tells you if a specific form is open, with a little modification (I'm not doing it all for you ;0) ) it'll give what you need. Public Function IsFormOpen(frm_name As String) As Boolean On Error GoTo Err_Function Dim line As Integer Dim dbs As...

Hi Folks, It's ok, I've solved the problem - you must add a primary key to each table that you want to edit. Later, Jes

Hi Folks, Apologies if this is the wrong forum, but I think it relates to the import through DTS. I've imported a set of tables from an access database and set up all permission to edit, etc, yet when I link to these tables through access, I'm unable to edit the contents of the tables...

Hi ordendelfai, Excellent, thanks. With a little modification it worked fine - just had to add a brace of [] around the table name when dropping and woohoo, off it went ;0) Have a star for that. Later, Jes

Hi Folks, I think the question sums up what I need to do. I've got my back-end tables in an SQL Server 2000 database and a front-end which links via ODBC. It works fine on my machine because I've set up the ODBC connection. However, I want to distribute the front-end to my users so they can...

Hi Folks, Sorry, I'm talking nonsense and you probably know it ;0) I've taken a look back at the tables and linking them with a primary key gives me unique values, linking them without a primary key gives me non-unique values - the end result is still the same though, I can't update the table...

Hi Folks, I'm linking to an oracle database through ODBC and want to update the table. I'm getting the message 'Query must use updateable recordset' when I run an update query on it. I think - and am fairly positive - that the cause is that looking at the index definition on the oracle side...

Hi Folks, Ok, I'll word it correctly this time. I've got an SQL-2000 database with stored procedures inside. I want to call thses from an Access 2000 database using pass through queries. Where there are no parameters, or where the parameters are discreet values, a 'docmd.openquery...

Hi Ben, Thanks. For both ;-) Later, Jes

Hi Folks, Can anyone give me an example of how to use the values of a control on a form as a parameter in an SQL pass-through query? I'm using access 2k and SQL-2000. Thanks, Jes

Hi Folks, I'm trying to use the AppActivate command and it's coming back with Error 5 with any app that I try except 'Application.Name'. I'm working under Citrix and wonder if that's what is causing the problems. Can anyone shed any light on this for me. Thanks. Jes

Hi Folks, Just as an amendment, if I put in xcl.application.displayfullscreen = False then it behaves properly everytime, it's just that seems a bit of a kludge to me. Later, Jes

Hi folks, I'n using Access XP and Excel XP in a citrix environment. I'm using automation to open a template in excel and then outputting the results of a query to that spreadsheet. The first time I run it, everything is fine. However, the next time, and everytime thereafter, the excel window...

Hi Folks, I've recently been experiencing a strange problem with an access 2000 app I've written. Everything will be working fine then someone else will try to start the app and be told it's corrupt, not recognised, all sorts of weird stuff. The only way to resolve it is for everyone else to...