asked on Custom Tab Issue on Access Form
I had this question after viewing Access Custome Tab for Customer Page.
I have developed a form called "frmCustomers" along with it I created a custom tab. All the links in the tab section "Customer Form Tools" works except for the "Show Lots" link with the filter icon. When you click on this icon it is supposed to take you to the report "rptCustomerLots" to show the lots associated with the selected customer you happen to be on in the form "frmCustomers"
I have been able to figure out how to get the needed forms to work with the other icons but I am having problems with the report "rptCustomerLots".
Any suggestions? ideas?
CustomerDB-2.accdb
I have developed a form called "frmCustomers" along with it I created a custom tab. All the links in the tab section "Customer Form Tools" works except for the "Show Lots" link with the filter icon. When you click on this icon it is supposed to take you to the report "rptCustomerLots" to show the lots associated with the selected customer you happen to be on in the form "frmCustomers"
I have been able to figure out how to get the needed forms to work with the other icons but I am having problems with the report "rptCustomerLots".
Any suggestions? ideas?
CustomerDB-2.accdb
Microsoft AccessVisual Basic ClassicDatabases
Last Comment
Rey Obrero (Capricorn1)
I don't see any custom tab from your form
ASKER
Rey,
I think my terminology is wrong. When you open the form customers it's in the "Ribbon" at the top. It has a tab next to the red "FILE" tab that is "Customers".
The icons in that tab all work except for "Show Lots" under the "Filter" icon which is supposed to point to the "rptCustomerLots" report.
I think my terminology is wrong. When you open the form customers it's in the "Ribbon" at the top. It has a tab next to the red "FILE" tab that is "Customers".
The icons in that tab all work except for "Show Lots" under the "Filter" icon which is supposed to point to the "rptCustomerLots" report.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Rey,
Everytime I try to download the file it goes to a 404 not found page. Can you repost the link?
Everytime I try to download the file it goes to a 404 not found page. Can you repost the link?
here
CustomerDB-2.accdb
CustomerDB-2.accdb
ASKER
Rey,
Thank you I was now able to download the file. Don't know why I was getting the 404 error but it worked now.
So you commeted out the first function ShowLots() and with the second one having the "DoCmd.OpenReport "rptCustomerLots", acViewPreview"
allowed it to work.
And the "USysRibbons" was correctly pointed at the function which fired the "rptCustomerLots"
Is this correct?
Thanks again,
Sam
Thank you I was now able to download the file. Don't know why I was getting the 404 error but it worked now.
So you commeted out the first function ShowLots() and with the second one having the "DoCmd.OpenReport "rptCustomerLots", acViewPreview"
allowed it to work.
And the "USysRibbons" was correctly pointed at the function which fired the "rptCustomerLots"
Is this correct?
Thanks again,
Sam
yes, that is correct