Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: skw8966
  • Content: Threads
  • Order by date
  1. skw8966

    retrieve data based on data range

    I have two textboxes (txtStartDate and txtEndDate). I would like to pull all data between those dates in a gridview. I can't seem to get the procedure to trigger. <%@ Page Language="vb" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>Variable Weekly...
  2. skw8966

    Pull data with calendar control

    I'm using Visual Web Developer 2008. I'd like to pull a week of data by using a calendar control. I have a calendar control and a gridview with a datasource tied to the calendar. When I select last week, it just shows Monday's data. When I select another week, it shows nothing. Every day...
  3. skw8966

    SQL Statement in VBA

    I have the following SQL statement in VBA with a Form_On Load procedure. frmPOD!MonSht = "SELECT Sum(qryPODEntry.Shts) AS SumOfShts from qryPODEntry HAVING (((qryPODEntry.fkID)=1) AND ((DatePart('w',[PODDate]))=2) AND ((qryPODEntry.Category)='POD'))" frmPOD relates to a subform on my main form...
  4. skw8966

    Calculate Percentage from two Recordsets

    I’m trying to get a calculation from two columns each with its own recordset. Calculation needed in first cell of Mc Percentage: (76-108)/108 = -29.63% 76 is from the Recordset (Wk) and 108 is from the recordset (PvsWk). Both recordsets pull from Crosstab queries in MS Access. I haven’t had...
  5. skw8966

    Password Change

    I have Active Server Pages which connect to an MS Access database. Within the DB is stored user information including usernames and password as the default password. I'd like to create a page that asks them to change their password the first time logging in. Any tips?
  6. skw8966

    User Authenication Problem

    I have three active server pages accessed by a login based on user security levels. They all work fine except people with the "Administrator" level cannot access EditPrint.asp. Here's the security section of the code for each page. AddReq.asp <%@LANGUAGE="VBSCRIPT"%> <!--#include...
  7. skw8966

    Pull data by week

    I have a search page with a date field. I'm using Dreamweaver MX to create a page which pulls data from an Access query. I would like to pull data for the whole week corresponding to the date entered on the search page. Can someone tell me how this is written in the SQL for the recordset.
  8. skw8966

    Apache Problem

    I have a machine with Mandrake 10 and Apache installed. I've been using this machine as a web server for six months now without issue. Suddenly, at 1:30 p.m. today our Intranet site went down. I get a page not displayed error. I've restarted the Linux machine and also restarted httpd. There...
  9. skw8966

    Average Minutes

    I have two fields on my ASP pulling data from a database. A chats (Long Integer) field and a dtTime (Date/Time data type, hh:nn:ss format) field. I'd like to create a 3rd field on the ASP to get my average time. How can I create this?
  10. skw8966

    Error in SQL statement

    I have an update page in ASP tied to an MS Access database. When submitting the update, I receive this error: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression '$4'. /CatReq/EditReq.asp, line 111 which refers to...
  11. skw8966

    Input Master/Detail data

    I have an MS Access DB with a main table that contains a quote number, name, address, etc. and a sub table that contains a quote number, Item number, qty, price. These tables are related through the tblMain PK and tblSubMain FK(which is the field quote number). I need to create an input form...
  12. skw8966

    Total in Repeating Region

    I have an asp connected to an MS Access database. The purpose is displaying quote information. The top section from Recordset1 contains the main quote data (Quote #, Name, Address, etc). The bottom section from Recordset2 contains the quote details (Item #, Description, Qty, Price). The bottom...
  13. skw8966

    Problem accessing index.html

    I have a Linux web server running Apache web server on RedHat 9. My web directory is /home/httpd/html. I have an index.html there and am able to view it under http://172.25.205.110. I have a folder under that directory called WebCall (a helpdesk tracking application). It contains the folders...
  14. skw8966

    Start and Stop time in ASP

    I have an Active Server Page connected to an MS Access database. I use this page to submit information to the database. Among the form fields is a start time and stop time field. By setting the value of start time to <%=Time()%>, I'm able to collect the start time automatically when the new...
  15. skw8966

    Samba connection problem

    I've been through the samba troubleshooting section and this forum but cannot find an answer to my problem. I have Samba 2.2.7a installed on my Red Hat 9.0 machine. I need to connect to it through my Win98 machine. It seems to be installed fine. smbd and nmbd are running properly. When I...
  16. skw8966

    Connection error

    When accessing my main page, I receive this error: Microsoft VBScript runtime error '800a01ad' ActiveX component can't create object /Intranet/Fast/tblReprintProdlist.asp, line 435 The error appears to relate to the line: Set conn=Server.CreateObject(&quot;ADODB.Connection&quot;) Here's...
  17. skw8966

    All fields not saved

    I have several active server pages to input and display data from my MS Access database. The view pages display the database information perfectly. The input pages only save certain fields. My first three fields are saved to the database and last three aren't. I can send the code from my...
  18. skw8966

    Unspecified Error

    I have an ASP form for inserting records into an MS Access database. I have a system DSN setup and connecting successfully. I also have a recordset established. My problem is when I submit the form, I receive an unspecified error on line 113. Here is line 113: MM_editCmd.ActiveConnection =...
  19. skw8966

    Display problem

    I have input fields connected to an Access database table through a system DSN. When I save the page then view it in IE the form fields display the asp code. For example, my account number fields says <%=(Additional.Fields.Item(&quot;Acct&quot;).Value)%> I have another asp connected to another...
  20. skw8966

    Linux Backup Problem

    I'm trying to backup my Red Hat 6.2 Linux server and receive an error. Here's the log: Performing backup of / to /dev/nst0 .. DUMP: Date of this level 0 dump: Wed Dec 3 10:18:10 2003 DUMP: Date of last level 0 dump: the epoch DUMP: Dumping /dev/ida/c0d0p6 (/) to /dev/nst0 DUMP: Label...

Part and Inventory Search

Back
Top