Strange Error #3200 "no Record Found" 关注

0
Avatar
Legacy Poster

Hi there,

 

I use an Acess data base as a data source. I have a prompt to enter a production order number.

On several production orders, I get a #3200 error "No record found".

post-40868-0-39066600-1447692675_thumb.j

What seems strange to me is that when i browse the data manually, I find the relevant production order ! So I can select it manually before printing, but this is not the way it should be !

post-40868-0-04876300-1447692674_thumb.j

Do you have any idea of what's going wrong ?

I use Bartender 10.0 SR4 and Access 2010 (OLE)

 

Thanks in advance,

 

Simon

7 评论

0
Avatar
Legacy Poster
评论操作 固定链接

Hello,

 

Could anyone help me ?

 

Thanks in advance,

 

Simon

0
Avatar
Legacy Poster
评论操作 固定链接

I've had this error a few times myself when creating my database using access.  Most of the time, it was because of an invisible character also being present in the access document product code.  If you delete the entry and re-enter the information, does this solve the issue?

0
Avatar
Legacy Poster
评论操作 固定链接

Could also be a join issue

0
Avatar
Legacy Poster
评论操作 固定链接


I cannot re-enter the information because my access database uses distant SQL server data tables. I'm going to check out the invisible character issue (may it be a space or something ?)
 
Thanks for you replies !
 
Simon
0
Avatar
Legacy Poster
评论操作 固定链接

Hi,

 

Could you please  re- send  completed link.

 

I have same  problem.

 

 

 

Thank you

B||R

0
Avatar
Sandy Bodell
评论操作 固定链接

I also have the same problem, though I am using Excel as a data source.  I can browse using the query to the correct record, but when I print or preview, I get this error.

 

Sandy

0
Avatar
Jasper Wen
版主
评论操作 固定链接

Generally, the error message "no records found" means just that and can't find any matching records being queried for. The most common scenario people run into if it browses correctly in the database connection setup but not at print time is the query records selection is not set correctly under the file->print dialog. Make sure it is set to all records if you are trying to query from all records on the database.

If you are still running into further issues, please contact our tech support directly to open a support ticket.

请先登录再写评论。