Search results for query: *

Hi, I have this query string at the moment <a class="nav" href="OTIF_YearCharts.asp?aYear=2015" target="cpOTIF_Main" >Charta OTIF 2015</a> I would like to change it so that it would use the current year so that I do not have to change it at the start of each year. I have tried <a class="nav"...

Hi All, I have a link to a page and the url contains a parameter variable to pass to a querystring on another page <a class="nav" href="../OEE/OEE_ChartYear.asp?cYear=2014" target="cpOTIF_Main" >OEE 2014</a> Obviously this will not work after the end of this year as it is passing 2014, I...

I have the following code which if a record exists creates a PDF and sends an e-mail Public Function SendMail() Dim strFilename As String Dim strNewName As String Dim strHead As String Dim strSub As String Dim ddate As String Dim strfrp As String Dim strPlant As String Dim rsCount As...

Hi, I have a form which has three sets of radio button groups all containg either "pass" or "fail" for each group at form load all radios are unchecked so that the user has to select either "pass" or "fail" for each group. the following code checks to make sure each radio group has a...

Hi, I have tried to write some code which will check the value of multiple radio groups and if any of the vales equal "Fail" then it will put "Fail" into a textbox otherwise it will put "Pass", however it does not seem to work. Could someone tell me where I am going wrong please <script...

Hi, I have very little knowledge when it comes to vbscript so I was wondering if someone out there could possibley help me with this issue. Please bear with we as explaining the issue will be quite lengthy When we create a product design in our system is is always 6 numeric digits in length...

I have been using the code below in access 2003 for around 18 months to send an e-mail I am now testing this using 2010 and I am getting an "application defined or object defined error" at the line highlighted in red Public Function cmdPrint_Click(view As Integer) 'On Error GoTo...

HI, On our company intranet we use the following to get the NT user name and display it on the default page <% UserName = (ucase(Request.ServerVariables("LOGON_USER"))) UserName = Replace(UserName, "DOMAINNAME\","") %> please could someone explain to me how I can use this data in a session...

Hi, I needed to be able to have 6 conditional formats and so I found some VBA code on the net to help me achieve this and it works ok, the code is shown below Private Sub Worksheet_Change(ByVal Target As Range) Dim icolor As Integer Dim ifont As Integer If Not Intersect(Target...

Hi People, I am really new to asp.net and I am struggling to get the following to work. I have created a data source <asp:AccessDataSource ID="Enquiries" runat="server" DataFile="~/App_Data/EnquiryApp_BE.mdb" SelectCommand="SELECT companynumber, name, street, city...

Hi Guys, I am not sure if I am posting this in the correct forum but here goes. I am really new to ASP.NET and I am trying very slowly to convert some existing ASP classic pages to .NET. In a particular asp page I check for a value in a particular recordset field and then replace it with an...

Hi Guys, I hope that I can explain this properly I have a worksheet (sheetData) that is populated once a month from an access query and it contains data for a particular customer, this sheet contains data for several delivery locations for this customer. Each row has a unique refernce number...

H, my js knowledge is pretty basic however, I have a page where the user will enter a date into a textfield, once the date has been entered I would like to get the week no month year from that date initially I have tried to write a function to get the month <script language="javascript">...

Hi, If i wanted to populate other forms fields from a combobox in an ms access database form I would use the dlookup function. is there something similar that can be used in asp I have one listbox that contains approx. 30 records these records are made up of 3 fields that contain the...

I wonder if someone can help please, I have a field in a db table that contains a string made up of 5 numbers seperated by spaces a sample of which is shown below 30 363 253 363 250 30 258 98 258 95 30 333 293 333 290 if the spaces were always in the same place I would use Left, Mid etc. What...

Hi people, can anyone see what is wrong with this small piece of code please. When I try to run it I get the message invalid use of Null and it highlights the line. CLdate = Date Private Sub Closed_AfterUpdate() Dim CLdate As String CLdate = Date [ClosedDate] = CLdate End Sub Regards Paul

Hi I wonder if someone can help me please with this issue I have the following code I am working on Dim MinWidth, MaxWidth, MinSWidth3, MaxSWidth3, MinSWidth1, MaxSWidth1, MinSWidth2, MaxSWidth2, MIW, MAW, MIW1, MAW1 As Variant MinWidth = 2165 MaxWidth = 2465 MinSWidth1 = RndUp((MinWidth /...

Hi, I am trying to use the following code in an access form BSize = HSlit & " x " & HalfChop BundleSize = BSize BLayer = (DLookup("Bun_Layer", "tblPalletData", "CaseSize = " & BSize)) However I keep getting a Runtime Error 3075, missing operator in query expression. HSlit = 350 & HalfChop...

Hi Team, Sorry it's me again I have a form that allows us to insert 3 records from one submit, therefore I have three fields for each item (example >>> txtName1,txtName2,txtName3). On this form the user can upload a different file for each of the 3 records and what I would like to achieve is...

Hi I have this code which is working fine <form action="ExSampleAddress.asp" name="frmAdd" target="_blank" class="input" id="frmAdd"> <% If Not rsAddresses.EOF Or Not rsAddresses.BOF Then %> <table width="40%" border="0" align="center"> <tr class="TextCentrePlain10px"> <td><select...