Jorge-
Can you see a query named qryOrderProducts? If so, can you open it in Datasheet view? You could also try compacting and repairing the database.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Jan 16, 2017, at 9:02 PM, muralles_r12@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hi Folks, I hope you are doing well.
I am wondering if anyone can help.
I am using the inventory database that came with John's Book.
I deleted the link tables, one one by one.
Then I imported the tables, but now the forms do not run well.
When I open the frmOrders I get the following message:
******************************************************************************
The record source "qryOrderProducts' specified on this form does not exist
The name of the record source may be misspelled, the record source was deleted or rename, or the record source may exist in a different database
*******************************************************************************
I have looked at the record source for both, the form and subform, they looked good.
I deleted the record source for both and set it again, but I still got the same message.
The subform does not display the order items.
Can anyone help me out please.
Thanks
Jorge Muralles
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar