Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

FrontPage DRW and searching by date....

Posted on 2006-03-24
4
Medium Priority
?
259 Views
Last Modified: 2013-12-24
Ok I have an MS Access DB with a field called "DATE" marked as data type "Date/Time"

Now lets say I want to setup a search with Front Page to search for specific months, or specific years. Like for example return results only in March, or only in April etc?

 
0
Comment
Question by:jfs9900
  • 2
3 Comments
 
LVL 14

Expert Comment

by:hhammash
ID: 16292654
Hi,

First of all you can't name the field as Date, it is a reserved word,  it will create problems later.

It depends how are you entering the month or the year?  are you using the Date/Time field to type today's date like:

03/26/2006
mm/dd/yyyy

Lets say you want to view results by March?  only results during 03?

The esiest way it to search for 03/01/2006 to 03/31/2006  this is to specify March 2006,  or 01/01/2004 to 12/31/2004 to specify year 2004.

In your search form you should put two search fields
- Field 1 name it as stdate
- Field 2 name it as endate

Create a DRW and create a statement that searches Between.

Save the DRW
Post the form to the DRW


0
 

Author Comment

by:jfs9900
ID: 16296523
The offical name of the feild is "TIMESTAMP"

When I do what is listed above I get the following error:

Database Results Error
Description: Data type mismatch in criteria expression.
Number: -2147217913 (0x80040E07)
Source: Microsoft JET Database Engine
0
 
LVL 14

Accepted Solution

by:
hhammash earned 1500 total points
ID: 16298739
OK,


Timestamp field is the problem.

I usually create two fields on my own 1 for date and 1 for time I don't rely on the TimeStamp field that is created by Frontpgae.


0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question