This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.
Solved
clear subform
Posted on 2016-09-27
Access 2010:
I have a subform: but it is not master child linked.
This is the name:
dbo_t_redbook_pricing_esca
This is the "source Object" :
dbo_t_redbook_pricing_esca
I'm trying to clear the subform out...
But it just appears white and blank..
by using.
Dim temp As String
temp = ""
temp = dbo_t_redbook_pricing_esca
dbo_t_redbook_pricing_esca
me.dbo_t_redbook_pricing_e
I want to clear it as if i just opened the database. form
trying to reset the recordsource via sql but saying it is to complex ?
Dim strSQL As String
strSQL = "SELECT TOP 5 dbo_t_redbook_pricing_esca
Me.dbo_t_redbook_pricing_e
Thanks
fordraiders
I have a subform: but it is not master child linked.
This is the name:
dbo_t_redbook_pricing_esca
This is the "source Object" :
dbo_t_redbook_pricing_esca
I'm trying to clear the subform out...
But it just appears white and blank..
by using.
Dim temp As String
temp = ""
temp = dbo_t_redbook_pricing_esca
dbo_t_redbook_pricing_esca
me.dbo_t_redbook_pricing_e
I want to clear it as if i just opened the database. form
trying to reset the recordsource via sql but saying it is to complex ?
Dim strSQL As String
strSQL = "SELECT TOP 5 dbo_t_redbook_pricing_esca
Me.dbo_t_redbook_pricing_e
Thanks
fordraiders
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
Active today
try this
Dim strSQL As String
strSQL = "SELECT TOP 5 dbo_t_redbook_pricing_esca
Me.dbo_t_redbook_pricing_e
also, take note that the subform loads first before the main form, so place the codes in the Load event of the main form or in the
current event if it deems necessary.
why not use master/child link fields?
Dim strSQL As String
strSQL = "SELECT TOP 5 dbo_t_redbook_pricing_esca
Me.dbo_t_redbook_pricing_e
also, take note that the subform loads first before the main form, so place the codes in the Load event of the main form or in the
current event if it deems necessary.
why not use master/child link fields?
Active today
>"But it just appears white and blank.."
is AllowAdditions set to True? If not, and there is not a record, the form will be as you describe.
also, Rey suggested setting LinkMasterFields and LinkChildFields for the subform control (DATA tab of Properties) ... let Access do the hard work ;) ~ Just make sure that what you reference is ON each form (it can be Visible=No). LinkMasterFields references a control and it can even be calculated. LinkChildFields must be a field in the RecordSource for the subform. If you have more than one to list, separate with ; (semi-colon)
is AllowAdditions set to True? If not, and there is not a record, the form will be as you describe.
also, Rey suggested setting LinkMasterFields and LinkChildFields for the subform control (DATA tab of Properties) ... let Access do the hard work ;) ~ Just make sure that what you reference is ON each form (it can be Visible=No). LinkMasterFields references a control and it can even be calculated. LinkChildFields must be a field in the RecordSource for the subform. If you have more than one to list, separate with ; (semi-colon)
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses
Course of the Month7 days, 7 hours left to enroll
715 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.