Search results for query: *

Hi I am having problems with outlook's virus prevention tool that brings up a virus warning when you automate outlook. A previous developer setup an .adm file to replace the user settings using gpedit.msc, User Configuration > Admin Templates.... This fix has worked fine for ages.. This...

Hi Is there a method of changing the font colour of the whole worksheet to black using VBA? Thanks Si

Hi I am currently upgrading our exchange server from 5.5 to 2000 on our windows 2k server. I have changed the LDAP port but continue to get this error on installation: The compeonent "microsoft exchange messanging and collaboration services" cannot be assigned the action upgrade...

Hi I am currently writing a program to update an access database when emails that are sent bounce. I have this code which i have developed to get the To Address from the bounced email which has been forwarded to a nominated folder by our exchange server. On the code "strSubject =...

Hi We have just upgraded our NT4 server to Win2k Server. Upon first boot we have been presented with the Active Directory Installation Wizard. We are now faced with two options: Create a new domain tree & Create a new child domain in an existing domain tree. The NT4 domain is called...

Hi I am setting up a Backup Domain Server to mirror our current NT4 server and replace it whilst we upgrade the server to Server and exchange server 2000. I am inexperienced in exchange and am wondering if there is a way of setting up our BDS to mirror the exchange on our primary server and...

Hi Guys, I have a richtext control that is linked to a memo field in an access database. If i copy data from Word into this control and then view it in an textbox or in the table view it shows data like this on each line...

Hi, I have setup a website on our server which i am currently haveing problems with. I can access all pages from the inside of our network (but still using http:\\www....) When accessed from a connection: some sections are available and others are not. When they are not available i get the...

Hi Guys, Can anyone point me to a bit of code that changes all characters of a word to lowercase and the inital character to upper case. Thanks Si

Hi Guys I am using this code to check a file extension of a file path listed in a textbox. I have tried changing it to upper case which does not solve it. Any ideas Cheers Si var iLen = String(frmDetails.txtFile.value).length; if (String(frmDetails.txtFile.value).substring(iLen, iLen - 3)...

Hi I am trying to delete some duplicate rows, i have searched some of the previous posts on this and have developed this, but it does not quite work. Basically, i have CandSkillID is the PK for this table, i need to delete records that have duplicate SkillID, and where the CandID = 89431...

Hi I am saving data from ASP to an access database which has linked tables, i keep getting this errror: Microsoft JET Database Engine (0x80004005) The Microsoft Jet database engine cannot open the file 'I:\Access Database\980211be.mdb'. It is already opened exclusively by another user, or you...

Hi guys, I have this code that i have recieved from someone to move data between two select boxes. I am having problems retrieving the data when it is posted to an ASP page. If i dont move any data using the code i can access it. If i do click one of the buttons that executes the function...

Hi I installed a ssl certificate on my computer, and now i cannot access my database from my website, i get this error: The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\clogin\data\webjobs.mdb'. It is already opened exclusively by another user, or you need permission...

Hi Guys, I am planning on converting a site that i have developed to SSL. I was wondering what basic changes would be needed to the code. Also I have tried to find some guidelines for this but i have had no success. Any pointers or links would be great. Cheers Si

Hi Guys, I am executing this SQL statement from ASP, when i copy it into MS Access it runs fine, but when i use ADO i get the error "Error in insert statement". I thought it was the Yes/No fields so i tried 0/1 for them with no success. Has anyone got any ideas, Thanks Si INSERT...

Hi Guys, I am developing a website and need to use a sort of date time picker/calender control. I was wondering if there is a free control available, and i was also wondering if there are any browser compatibility issues that i should be aware of? I like the look of the Microsoft Date/Time...

Hi Guys, I have been looking at this code for ages and cant see the problem. The Box on the page returns the results from a database query, i have tested the Query and it is fine. It creates 26 rows in the select box, but they are blank. I have checked the CSS and that isnt the problem...

Hi I want to execute some VBA code from an ASP Page, i am using this line of code to execute it: Set objAccess = Server.CreateObject("Access.Application") objAccess.Visible = False objAccess.OpenCurrentDatabaseServer.MapPath(strDbName) Set objDB = objAccess.CurrentDb() objDB.Run...

Hi Guys I have just opened a previously developed project in VBA and when i run this line of code: If UCase(strFileExtention) = ".DOC" Then and if i use the left function i get the error "Can't find project or Library" and intellisense does not pick it up. I thought you...