Databases
StackOverflow2013
Postsdbo
PORuntime query does not work.Why?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORuntime query does not work.Why?
    primarykey
    data
    text
    <p>I have a Problem with my codes and it made me confuse.this is my scenario:</p> <p>in my access Project I have a Form and subform that work together.I wanted to enhace my performance . I deceided to load my form and subforms in Runtime(from this <a href="http://www.granite.ab.ca/access/performanceforms.htm" rel="nofollow">article</a>) .I put my query on my form code, in Form_load event like this:</p> <pre><code>Private Sub Form_load() Me.RecordSource = "SELECT DISTINCTROW tb_bauteile.* " &amp; _ "FROM tb_bauteile LEFT JOIN FehlerCodes_akt_Liste ON tb_bauteile.CDT = FehlerCodes_akt_Liste.CDT " &amp; _ "WHERE (((FehlerCodes_akt_Liste.Steuergerät)='MEDC17'))" &amp; _ "ORDER BY FehlerCodes_akt_Liste.Fehlerpfad;" End Sub </code></pre> <p>but another problem occured with another controls in my form.when i click another control .this function should be run:</p> <pre><code>Private Sub subPfadFilter(Kombifeld As Variant, Obd As String) Dim strKrit, strAuswahl, strSg As String If (IsNull(Me.CDT) Or (Me.CDT = "")) Then strAuswahl = "*" Else strAuswahl = Me.CDT blnFiltOn = True End If ..... </code></pre> <p>but it doesn't work and say me <strong>method or dataobjectt not found</strong>( without this if statement works the function works fine .the problem come from CDT ) if I put the query in Datasource in my form property that works properly</p> <p>I cant understand the relation between these two things(putting the query on datasource of form property then working the if statement (CDT) good but when i put the query in Form load that does not work ) ,would you please help me if posible?have you any idee? thank you so much for your helps </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USBaper
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PORuntime query does not work.Why?
      1. USMatt Donnan
      1. VTFavorite
    2. VO
      singulars
      1. PORuntime query does not work.Why?
      1. USBaper
      1. VTFavorite
    1. COI think there should be a space before ORDER BY. Don't know if that will make a difference....
      singulars
      1. PORuntime query does not work.Why?
      1. USSimon
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload