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!

Recent content by skw8966

  1. skw8966

    retrieve data based on data range

    I'm also using Visual Web Developer not Visual Studio
  2. skw8966

    retrieve data based on data range

    According to the microsoft site, one of the requirements for using data access is a database server running SQL Server 7.0 or later. I'm using MS Access 2003. Do I have any other options?
  3. skw8966

    retrieve data based on data range

    Could you please explain what you mean by not using datasource controls?
  4. 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...
  5. 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...
  6. skw8966

    SQL Statement in VBA

    I got it working. here's the code. frmPOD!MonSht = DSum("Shts", "qryPODEntry", "[qryPODEntry]![Category]='POD' AND [qryPODEntry]![DayofWeek]=2") Thanks for all the help. I really appreciate it.
  7. skw8966

    SQL Statement in VBA

    I moved the code from the OnLoad procedure to an OnClick button procedure within the form. Now I get this error. You entered an invalid argument in a domain aggregrate function.
  8. skw8966

    SQL Statement in VBA

    I tried the code you provided. It tells me "Object Required" and refers to that code.
  9. skw8966

    SQL Statement in VBA

    Now when I open the form, I get an this error. Runtime error '2001' You canceled the previous operation.
  10. skw8966

    SQL Statement in VBA

    This is what I have using the directions from the Access Help. frmPOD!MonSht = DSum(Shts, qryPODEntry, "fkID=[frmMain]![pkID] and [Category]='POD' and Dayoftheweek=2") I'm getting a type mismatch. I've verified the spellings of all the objects.
  11. skw8966

    SQL Statement in VBA

    How do I list multiple criteria with the DSum?
  12. 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...
  13. 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...
  14. skw8966

    Password Change

    I've created a Password Change page. How would I tie this into the login page? All passwords are "password" by default until changed so I could probably use that criteria to redirect to the password change page. Here's the code for Login.asp and PassChange.asp. <%@LANGUAGE="VBSCRIPT"...
  15. skw8966

    Password Change

    Thanks. I'll give it a try!
See more

Part and Inventory Search

Back
Top