Database Results View

[Glenn]

I have a database in my web.

One of the fields is ExpirationDate.

When I have the record view screen come up, I'd like to have it show only
those records that haven't expired.

I tried to create a query view in Access that had >=date() ... it worked
fine in Access, however I received an error when trying to insert that view
into my page.

How can I do this?

Thanks.

 

[Kathleen Anderson [MVP - FrontPage]]

If you created the query in Access, you should be able to use it as a
recordsource in the Database Results Wizard, it would be listed as a "View".
What was the error message?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

 

[Glenn]

Server error: Unable to retrieve schema information from the record source
'date' in a database using the connection string:

'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

 

[Kathleen Anderson [MVP - FrontPage]]

Try changing the name of the query from 'date' to something else and
reimport your database and try again.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

Server error: Unable to retrieve schema information from the record source
'date' in a database using the connection string:

'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.

The following error message comes from the database driver software; it
may appear in a different language depending on how the driver is
configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

If you created the query in Access, you should be able to use it as a
recordsource in the Database Results Wizard, it would be listed as a
"View". What was the error message?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

 

[Glenn]

I changed the name and saved the database. This time I was able to add the
query without error, however when I go to the data results page, no records
are found. (There should be 3, when I run the query in Access 3 results
show up).

Try changing the name of the query from 'date' to something else and
reimport your database and try again.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

Server error: Unable to retrieve schema information from the record
source 'date' in a database using the connection string:

'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.

The following error message comes from the database driver software; it
may appear in a different language depending on how the driver is
configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

If you created the query in Access, you should be able to use it as a
recordsource in the Database Results Wizard, it would be listed as a
"View". What was the error message?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



I have a database in my web.

One of the fields is ExpirationDate.

When I have the record view screen come up, I'd like to have it show
only those records that haven't expired.

I tried to create a query view in Access that had >=date() ... it
worked fine in Access, however I received an error when trying to
insert that view into my page.

How can I do this?

Thanks.

 

[Kathleen Anderson [MVP - FrontPage]]

Can you post the SQL from the Access query?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

I changed the name and saved the database. This time I was able to add the
query without error, however when I go to the data results page, no records
are found. (There should be 3, when I run the query in Access 3 results
show up).

Try changing the name of the query from 'date' to something else and
reimport your database and try again.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

Server error: Unable to retrieve schema information from the record
source 'date' in a database using the connection string:

'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.

The following error message comes from the database driver software; it
may appear in a different language depending on how the driver is
configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

message If you created the query in Access, you should be able to use it as a
recordsource in the Database Results Wizard, it would be listed as a
"View". What was the error message?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



I have a database in my web.

One of the fields is ExpirationDate.

When I have the record view screen come up, I'd like to have it show
only those records that haven't expired.

I tried to create a query view in Access that had >=date() ... it
worked fine in Access, however I received an error when trying to
insert that view into my page.

How can I do this?

Thanks.

 

[Glenn]

I don't think this is what you mean, but I'm not sure how to find the SQL.
I just made the query using the query tab / design view:

=Date()

Can you post the SQL from the Access query?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

I changed the name and saved the database. This time I was able to add
the query without error, however when I go to the data results page, no
records are found. (There should be 3, when I run the query in Access 3
results show up).

Try changing the name of the query from 'date' to something else and
reimport your database and try again.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



Server error: Unable to retrieve schema information from the record
source 'date' in a database using the connection string:

'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.

The following error message comes from the database driver software; it
may appear in a different language depending on how the driver is
configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

in message If you created the query in Access, you should be able to use it as a
recordsource in the Database Results Wizard, it would be listed as a
"View". What was the error message?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



I have a database in my web.

One of the fields is ExpirationDate.

When I have the record view screen come up, I'd like to have it show
only those records that haven't expired.

I tried to create a query view in Access that had >=date() ... it
worked fine in Access, however I received an error when trying to
insert that view into my page.

How can I do this?

Thanks.

 

[Glenn]

I found the SQL, here it is:

SELECT Employees.EmployeeID, Employees.LastName, Employees.FirstName,
Employees.HireDate
FROM Employees
WHERE (((Employees.HireDate)>=Date()));

Can you post the SQL from the Access query?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

I changed the name and saved the database. This time I was able to add
the query without error, however when I go to the data results page, no
records are found. (There should be 3, when I run the query in Access 3
results show up).

Try changing the name of the query from 'date' to something else and
reimport your database and try again.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



Server error: Unable to retrieve schema information from the record
source 'date' in a database using the connection string:

'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.

The following error message comes from the database driver software; it
may appear in a different language depending on how the driver is
configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

in message If you created the query in Access, you should be able to use it as a
recordsource in the Database Results Wizard, it would be listed as a
"View". What was the error message?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



I have a database in my web.

One of the fields is ExpirationDate.

When I have the record view screen come up, I'd like to have it show
only those records that haven't expired.

I tried to create a query view in Access that had >=date() ... it
worked fine in Access, however I received an error when trying to
insert that view into my page.

How can I do this?

Thanks.

 

[Kathleen Anderson [MVP - FrontPage]]

That should work. Is Employees.HireDate defined as a date field in your
database? Are you and your server located in the same locale? Dates are
displayed differently in different countries.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

I found the SQL, here it is:

SELECT Employees.EmployeeID, Employees.LastName, Employees.FirstName,
Employees.HireDate
FROM Employees
WHERE (((Employees.HireDate)>=Date()));

Can you post the SQL from the Access query?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

I changed the name and saved the database. This time I was able to
add the query without error, however when I go to the data results
page, no records are found. (There should be 3, when I run the
query in Access 3 results show up).


"Kathleen Anderson [MVP - FrontPage]" <[email protected]>
wrote in message Try changing the name of the query from 'date' to something else
and reimport your database and try again.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



Server error: Unable to retrieve schema information from the
record source 'date' in a database using the connection string:

'DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.

The following error message comes from the database driver
software; it may appear in a different language depending on how
the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM
clause.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

"Kathleen Anderson [MVP - FrontPage]" <[email protected]>
wrote in message If you created the query in Access, you should be able to use it
as a recordsource in the Database Results Wizard, it would be
listed as a "View". What was the error message?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



I have a database in my web.

One of the fields is ExpirationDate.

When I have the record view screen come up, I'd like to have it
show only those records that haven't expired.

I tried to create a query view in Access that had >=date() ...
it worked fine in Access, however I received an error when
trying to insert that view into my page.

How can I do this?

Thanks.

 

[Glenn]

Employees.HireDate is defined as a date field, and I am about 20 feet from
the server. I've tried it at a couple of different locations and the same
thing happens (no results). When I run the Query in Access, I get three
results.

That should work. Is Employees.HireDate defined as a date field in your
database? Are you and your server located in the same locale? Dates are
displayed differently in different countries.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

I found the SQL, here it is:

SELECT Employees.EmployeeID, Employees.LastName, Employees.FirstName,
Employees.HireDate
FROM Employees
WHERE (((Employees.HireDate)>=Date()));

Can you post the SQL from the Access query?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



I changed the name and saved the database. This time I was able to
add the query without error, however when I go to the data results
page, no records are found. (There should be 3, when I run the
query in Access 3 results show up).


"Kathleen Anderson [MVP - FrontPage]" <[email protected]>
wrote in message Try changing the name of the query from 'date' to something else
and reimport your database and try again.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



Server error: Unable to retrieve schema information from the
record source 'date' in a database using the connection string:

'DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.

The following error message comes from the database driver
software; it may appear in a different language depending on how
the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM
clause.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

"Kathleen Anderson [MVP - FrontPage]" <[email protected]>
wrote in message If you created the query in Access, you should be able to use it
as a recordsource in the Database Results Wizard, it would be
listed as a "View". What was the error message?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



I have a database in my web.

One of the fields is ExpirationDate.

When I have the record view screen come up, I'd like to have it
show only those records that haven't expired.

I tried to create a query view in Access that had >=date() ...
it worked fine in Access, however I received an error when
trying to insert that view into my page.

How can I do this?

Thanks.

 

[Glenn]

I tried creating a new database and it seems to work fine. Thanks for your
help.

Employees.HireDate is defined as a date field, and I am about 20 feet from
the server. I've tried it at a couple of different locations and the same
thing happens (no results). When I run the Query in Access, I get three
results.

That should work. Is Employees.HireDate defined as a date field in your
database? Are you and your server located in the same locale? Dates are
displayed differently in different countries.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

I found the SQL, here it is:

SELECT Employees.EmployeeID, Employees.LastName, Employees.FirstName,
Employees.HireDate
FROM Employees
WHERE (((Employees.HireDate)>=Date()));


in message Can you post the SQL from the Access query?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



I changed the name and saved the database. This time I was able to
add the query without error, however when I go to the data results
page, no records are found. (There should be 3, when I run the
query in Access 3 results show up).


"Kathleen Anderson [MVP - FrontPage]" <[email protected]>
wrote in message Try changing the name of the query from 'date' to something else
and reimport your database and try again.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



Server error: Unable to retrieve schema information from the
record source 'date' in a database using the connection string:

'DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/fpnwind.mdb'.

The following error message comes from the database driver
software; it may appear in a different language depending on how
the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM
clause.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)

"Kathleen Anderson [MVP - FrontPage]" <[email protected]>
wrote in message If you created the query in Access, you should be able to use it
as a recordsource in the Database Results Wizard, it would be
listed as a "View". What was the error message?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx



I have a database in my web.

One of the fields is ExpirationDate.

When I have the record view screen come up, I'd like to have it
show only those records that haven't expired.

I tried to create a query view in Access that had >=date() ...
it worked fine in Access, however I received an error when
trying to insert that view into my page.

How can I do this?

Thanks.