vba - Dependent queries and referencing subform controls -

-

status

In my database there are many questions and a form, let's call them Query1a , Query1b , and Query2 , and Form1 .

Form1 control Text1 , ComboBox1 , and one button command1 .

Question 1A and 1B reference control on Form1 obviously, eg a SELECT Forms! Form1! Expr1 as text1 Question 2 depends on the query 1A and 1B.

Command1 run DoCmd.OpenQuery "Query2" click, and everything works fine.

The problem

I have many forms with the same structure as Form1 , and I want to put them all in one navigation tab. I create - & gt; Navigation - & gt; Drag the horizontal tab and form1 on any tab.

Now, when I try to use Form1 in the Navigation form, then I ask for the value of the pop up Text1 , Because query1a it

forms! Trying to look in Form1 , but my Text1 actually resides in form! NavigationForm! Form 1 Form .

Effort

I can change the code clearly in every question and refer to the subform, but it is tedious, not very elegant, and this navigation form Will break the ability to use the form outside.

Inspired by the comments, I also tried the following:

  1. a1 and Query1b
  2. Add parameter announcements to form1 in my button, I set parameters to program through QueryDef . In this way, I can do something like Dim qdf, such as DAO QQDf set qdf = CurrentDb.QueryDefs ("Query1a") qdf.Parameters ("Forms! Form 1! MyPerm"). Value = I! Text 1

    However, I do not know where to go from there, because for my queryDef object Query2 Is invisible.

    One thing that makes life easier, should be that the form object has been called from, to be able to refer to those questions, but I do not know that this is possible.

    This is ending with the parameter query, and with QueryDef query2 parameters. It works by commenting in @VBlades

    Because QueryDef objects access can see the parameters of queries on them, the query is located at the top of the query 2 GET_CUSTOMER; You can write code like this: query defaults ("query2"). Parameters ("customer_id") = 123, although not related to the ultimate top level, so the versatile of the underlying query can be reached at the higher level (at the top of my head), I do not know what happens if the pile of questions Have the same nominal parameters, I think they are all given the same value if the ultimate set is done) then yes, it can be done.

    In other words, I can pass any parameter to a query, it is also seen on the basis of all the questions. I do not know what happens if there is a name conflict.

    So I think my OP is a cheat, but it took me a while to understand ...

Comments

Post a Comment

Popular posts from this blog

php - PDO bindParam() fatal error -

-
I am trying to learn PDO, now I have written this small code, but it gives me a serious error: Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
Read more

php - How can I cram 6+31 numeric characters into 22 alphanumeric characters? -

-
I have a 6 digit number and a 31-digit number (such as "234536" and "201103231043330478311223582826") that I The API needs to be crawled in the same 22-character alphanumeric field that uses PHP. I tried to convert each one to 32 (using custom code could not handle the base_convert () large number) and to connect with a single-character delimiter, but It only gives me 26 characters This is a restore API, so the letters should be URI-protected. I would like to do a database table cross with two references without reference to another reference value, if possible, any suggestions? Instead use a radix of 62. This will give you 22 characters for the top, 3.35 for the pre and 17.3 for the next. & gt; & Gt; & Gt; Math.log (10 ** 6) /math.log (62) 3.3474826039165504 & gt; & Gt; & Gt; Math.log (10 ** 31) /math.log (62) 17.295326786902177
Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

-
For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i...
Read more