Cannot explicitly refer to controls on a report (MS Access/VBA) -

-

how refer report's controls explicitly? referring implicitly works expected:

me.lbltest.visible = true

however, of attempts @ referencing control explicitly meet various nonsensical runtime errors. access' favorite:

"the report name 'rpttest' entered misspelled (it's not) or refers report isn't open (it is) or doesn't exist (it does)."

i've tried dozen syntax variations msdn , everywhere else find, producing errors:

reports!rpttest.lbltest.visible = true     ' ^--expected syntax, forms!frmname.ctlname.property reports!("rpttest").lbltest.visible = true reports![rpttest].lbltest.visible = true reports("rpttest").controls("lbltest").visible = true etc. etc.

this should no different referring forms' controls, right? there must way refer explicitly report's controls.

check names of reports access thinks open.

with report open, go immediate window. ctrl+g take there.

paste in for each rpt in reports : ? rpt.name : next 1 line , press enter. access tell names of open reports sees them.

here immediate window example system 1 report, rptfoo, open ...

for each rpt in reports : ? rpt.name : next rptfoo

the problem you're facing rpttest open, access disagrees. discrepancy can caused @ least 3 ways:

  1. rpttest see when report open, report's caption property instead of name
  2. rpttest subreport contained in other open report. reports collection, access looks find open reports, contains "top-level" reports open. if you're dealing subreport, reference via parent report ... reports!rptparent!subreportcontrol!lbltest.visible subreportcontrol name of subreport control contains rpttest. careful because name of subreport control may not rpttest --- need name of subreport control, not name of report contains.
  3. if rpttest contained in subform/subreport control within form (instead of within report), situation similar #2, must reference via parent form ... forms!yourformname!subcontrolname!lbltest.visible

Comments

Post a Comment

Popular posts from this blog

html - Firefox flex bug applied to buttons? -

-
i'm trying apply flex button on firefox i'm having problem on chrome doesn't happens. this css: .button { display: inline-flex; align-items: center; } as can see in fiddle, "caret" word moved new line, happens if element <button> tag, <div> works expected. http://codepen.io/anon/pen/xblmgx is firefox bug or there css i'm missing? nevermind, looks "mr firefox" doesn't idea... <button> not implementable (by browsers) in pure css, bit of black box, perspective of css. means don't react in same way e.g. <div> would. this isn't specific flexbox -- e.g. don't render scrollbars if put "overflow:scroll" on button, , don't render table if put "display:table" on it. stepping further, isn't specific <button> . consider <fieldset> , <table> have special rendering behavior: data:text/html,<fieldset style="d
Read more

html - Missing border-right in select on Firefox -

-
Image
when put select div width , padding-left, options have no border on right. more, happend if select have width 118px , parent have 15px of padding left! have idea, going on? my code: <!doctype html> <html> <head lang="en"> </head> <body> <div style="width: 1000px; padding-left: 15px;"> <select style="width: 118px;"> <option>a</option> <option>b</option> <option>c</option> </select> </div> </body> </html> and result: here plunker: click it happend on firefox on windows. tested on 40.0.2 version -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -ms-box-sizing: border-box; box-sizing: border-box; source: https://stackoverflow.com/a/11390432/4431269 source of problem: https://bugzilla.mozilla.org/show_bug.cgi?id=924068 and use of google ! edit: (source of problem, explained) after rea
Read more

c# - two queries in same method -

-
i trying execute 2 queries in same method gives me exception. can red of exception declaring new command there way use same command? string id="hi"; connection.open(); oledbcommand command1 = new oledbcommand(); command1.connection = connection; string query1 = "select * products category='" + combobox1.text + "' , subcategory = '" + combobox2.text + "' , sizes='" + combobox3.text + "'"; command1.commandtext = query1; oledbdatareader reader = command1.executereader(); while (reader.read()) { id = reader[0].tostring(); } textbox1.text = id; string query = "insert category_in (category_id,amount,amount_in) values ('"+ id+"' ,500,300)"; command1.commandtext = query; command1.executenonquery(); messagebox.show("saved"); connection.close();
Read more