PC Review


Reply
Thread Tools Rate Thread

Access Data search comes up empty

 
 
=?Utf-8?B?Y2xvbmUxMjM=?=
Guest
Posts: n/a
 
      23rd Mar 2005
From Access I imported an Excell sheet into my database. Everything works
great with the DBW . Then I created an ASP search page on one fiield in my
database. When I search that field on records created from the excell
import, I get "No results found". But any new record I add to the database
will give correct results.

Any Ideas,

Thanks in advance
 
Reply With Quote
 
 
 
 
Thomas A. Rowe
Guest
Posts: n/a
 
      23rd Mar 2005
You need to compare the exist content with the content being added to see what eh differences are.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"clone123" <(E-Mail Removed)> wrote in message
news:6F8D8379-72A1-490B-A029-(E-Mail Removed)...
> From Access I imported an Excell sheet into my database. Everything works
> great with the DBW . Then I created an ASP search page on one fiield in my
> database. When I search that field on records created from the excell
> import, I get "No results found". But any new record I add to the database
> will give correct results.
>
> Any Ideas,
>
> Thanks in advance



 
Reply With Quote
 
=?Utf-8?B?Y2xvbmUxMjM=?=
Guest
Posts: n/a
 
      23rd Mar 2005

I'm not sure what you mean by "exist content". I have compared all the
fields in access, everything seems to look fine.



"Thomas A. Rowe" wrote:

> You need to compare the exist content with the content being added to see what eh differences are.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "clone123" <(E-Mail Removed)> wrote in message
> news:6F8D8379-72A1-490B-A029-(E-Mail Removed)...
> > From Access I imported an Excell sheet into my database. Everything works
> > great with the DBW . Then I created an ASP search page on one fiield in my
> > database. When I search that field on records created from the excell
> > import, I get "No results found". But any new record I add to the database
> > will give correct results.
> >
> > Any Ideas,
> >
> > Thanks in advance

>
>
>

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      23rd Mar 2005
Look at the data that you imported from Excel versus the new data being entered into the database.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"clone123" <(E-Mail Removed)> wrote in message
news:2034DE0D-40B1-4273-9249-(E-Mail Removed)...
>
> I'm not sure what you mean by "exist content". I have compared all the
> fields in access, everything seems to look fine.
>
>
>
> "Thomas A. Rowe" wrote:
>
>> You need to compare the exist content with the content being added to see what eh differences
>> are.
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> WEBMASTER Resources(tm)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> To assist you in getting the best answers for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>>
>> "clone123" <(E-Mail Removed)> wrote in message
>> news:6F8D8379-72A1-490B-A029-(E-Mail Removed)...
>> > From Access I imported an Excell sheet into my database. Everything works
>> > great with the DBW . Then I created an ASP search page on one fiield in my
>> > database. When I search that field on records created from the excell
>> > import, I get "No results found". But any new record I add to the database
>> > will give correct results.
>> >
>> > Any Ideas,
>> >
>> > Thanks in advance

>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot table getting empty set of data from Access GordonA Microsoft Excel Crashes 2 3rd Nov 2008 09:29 PM
Why access reset data to empty ghost Microsoft Access Form Coding 6 14th Jan 2008 02:29 PM
Word Mail Merge w/Access Data Base - reports empty data base recor =?Utf-8?B?U3RldmUgUnV0bGVkZ2U=?= Microsoft Access Macros 1 13th Apr 2007 08:48 PM
Save XML data to new(empty) Access Database james Microsoft Access External Data 0 12th Oct 2004 02:59 AM
How can I access only non empty data field in report Mr Sajid Munir Microsoft Access Getting Started 1 14th Sep 2004 03:03 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:17 PM.