Recent content by elpico

Hmmm, I feel stupid now - Thanks for that!

Hi all, I haven't been able to find out how to improve this, but basically I've got my if statement, of which there are over 100 types, but I want to access a condition for everything but 2 or 3 things... ie if queueid <> 57 or queueid <> 83 or queueid <> 84 then do stuff else do other stuff...

Thanks - I just figured it out too - It helps to read the help files a bit - To be honest the answer is nearly always there - The hard part is finding it! Cheers, e.

Hi all, I have a continuous form, but I am having problems applying filters to it - I have a checkbox in the header of the form, which, when I tick it I want only values that match a condition to be displayed - I've tried the applyfilter command without any luck... DoCmd.ApplyFilter...

Thanks - works perfectly!

Hi all, Some of the data in my db table can be blank, but when that is the case I am having problems loading them in as values using the varRecords option. varRecords = rst.getRows(rst.RecordCount) For intJ = 0 to UBound(varRecords, 2) site = varRecords(0, intj) env = varRecords(1, intj) next...

I've got this piece of sql SELECT [My Query].* INTO ConfigFileAllSites FROM [My Query]; that runs this query SELECT [site].[sitename], configfile.*, [site].[envid] FROM site, configfile ORDER BY [site].[sitename], [ConfigFile].[Module], [ConfigFile].[ConfigFileName]; - which runs fine from...

Nice one - works a treat - was silly of me to try and build a relationship when I already have it in the JOIN! Thanks, e.

I'm struggling with this piece of sql - Basically I want to update a column called output in table A (fileid, output) based on what is set to true on a similar column in Table b.(fileid, outname, sitename) I've tried to do it with joins but no luck - any ideas on where I should be going with...

Hi all, I've set up a couple of scripts to update various password files on my windows 2000 server. These files are updated using new files from my unix box, and I've been trying to use secure putty (pscp.exe) to automate the transfer. The problem I've been having is that my script is supposed...

Greetings all, I'm trying to create a trigger to update a seperate table from multiple schemas. The trigger will loaded into my schema called 'global'. the problem I'm getting in my script is that I haven't been able to pass in the schema name of the table I want to update - Isn't this...

Greetings all, I'm trying to create a trigger to update a seperate table from multiple schemas. The trigger will loaded into my schema called 'global'. the problem I'm getting in my script is that I haven't been able to pass in the schema name of the table I want to update - Isn't this...

Hi all, I've two web servers, both with Apache 2.0.43, Mod_jk2.so for connecting with tomcat 4.1.24, and configured for SSL. It starts up fine on one web server, but on the other one, with exactly the same settings, returns the following error when I run apachectl sslstart.... [Tue Aug 05...

i have a problem connecting to a server using jproxy through apache and modjk/tomcat apache serves pages fine on port 443, when I run apachectl sslstart, and i can connect to the tomcat servlets examples page, so i know there is connectivity there. the problem appears when the machine is place...

Thanks for that - If you can find the link, then please let me know! Cheers, elpico.