Search results for query: *

I'm also using Visual Web Developer not Visual Studio

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?

Could you please explain what you mean by not using datasource controls?

...</asp:GridView> <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/OrderCount.mdb" SelectCommand="SELECT * FROM [qry3McWkCountRevised] WHERE (([RecDate] >= ?) AND ([RecDate] <= ?))"> <SelectParameters> <asp:QueryStringParameter Name="RecDate"...

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...

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.

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.

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

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

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.

How do I list multiple criteria with the DSum?

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...

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...

...Here's the code for Login.asp and PassChange.asp. <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!--#include file="Connections/CatReq.asp" --> <% ' *** Validate request to log in to this site. MM_LoginAction = Request.ServerVariables("URL") If Request.QueryString<>"" Then MM_LoginAction =...

Thanks. I'll give it a try!

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?

...Here's the security section of the code for each page. AddReq.asp <%@LANGUAGE="VBSCRIPT"%> <!--#include file="Connections/CatReq.asp" --> <% ' *** Restrict Access To Page: Grant or deny access to this page MM_authorizedUsers="Guest" MM_authFailedURL="Denied.asp" MM_grantAccess=false If...

Thanks.

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.

Thanks. I'll try that.