Strange Error #3200 "no Record Found"
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".
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 !
Do you have any idea of what's going wrong ?
I use Bartender 10.0 SR4 and Access 2010 (OLE)
Thanks in advance,
Could anyone help me ?
Thanks in advance,
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
Could also be a join issue0
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 !Simon0
Could you please re- send completed link.
I have same problem.
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.
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.1
Jasper Wen is correct!
This just solved my issue.0