Search results for query: *

Guys, I have been asked to automate some data in a spreadsheet concerning dates. Basically what they want is to be able to select a date from a calendar which populates a cell and the other cells are populated with other dates based on varying spans i.e stage 1 = 3 days after selected date...

Is it possible to get an ActiveX Calendar that only shows week days ?? Regards Paul

HI, I have inherited a workbook that imports data from a text file via a macro and the problem i have is that although the text in the columns reads OK it appears that empty spaces are imported. i.e the first column contains customer names and despite the length of the name the column is always...

I have this code so that I can validate whether two input fields have values entered. <script language="JavaScript"> <!-- function validateform ( ) { valid = true; if ( document.frmPlanOrder.txtDate.value == "" ) { alert ( "Please Select a Date." )...

I am usin g the following code to get the username when users load the home page on our intranet. <% '***Start Function ValImage ValImage = (ucase(Request.ServerVariables("LOGON_USER"))) ValImage = Replace(ValImage, "SOMEWHERE-UK\","") '***End Function ValImage %> I then have a hidden field...

I have an access db that is linked to a legacy system, one of the fields in the table has a string of 24 numers such as 008902920089019703650197 every four numbers represent a measure in millimetres i.e. the above string would be 0089 0292 0089 0197 0365 0197 I have managed to split the...

I have the following code which determines the username login I then use this to restrict users to certain pages however, at the moment i have to place the code on every page that i need to use it on. Could someone tell me if it is possible to change it so that i could use it in an include page...

Hi, I have a asp page that updates multiple records to my DB I the want to redirect to another page to view the records with the updated data, I want to create one view page that will be accessed by 10 others depending on a Due Date and also a machine name however I cannot get the syntax of the...

I am using the follwoing code to try and insert data into 2 text fields if a checkbox is "checked" otherwise the fields are blank, but i do not seem to be able to find the correct syntax to make it work ? <script language="JavaScript"> function showVal(){ if...

I posted this in the asp forum but I was told this would be better posted here I am trying to have a listbox either visible or invisible based on wether another listbox value contains the letter "d", I have tried to write the following function without success and wondered if someone would take...

I am trying to have a listbox either visible or invisible based on wether another listbox value contains the letter "d", I have tried to write the following function without success and wondered if someone would take a look and perhaps steer me in the right direction <script...

Is it possible to filter a dropdown by using a where statement I have the following code for my dropdown [code] <option value="<%=(RSdetails.Fields.Item("RepID").Value)%>"><%=(RSdetails.Fields.Item("Name").Value)%></option> Couls someone explain the correct syntax to add in the code in...

HI, I have a asp page with a form that submits data to an access DB in the form i have a date field which is foramtted as dd/mm/yy using the following 2 functions <% Function Pad(strText, nLen, strChar, bFront) Dim nStartLen If strChar = "" Then strChar = "0" End If...