database - MS Access 2007 - OpenArgs not passing the value to next form? -

-

so pass id value 1 form next using

docmd.openform "secondform",,,,,, mainid docmd.close acform, "firstform", acsaveyes

and check value on second form's load event:

mainid = val(me.openargs)

and when debug , step through hover on , can see contains value

then have button click event on second form supposed repeat process, when run following

dim rs dao.recordset dim dbs dao.database set dbs = currentdb  set myrs = dbs.openrecordset("tblmain")  if myrs!mainid = mainid

after rs.edit, etc stuff....the routine not making far. once same debug , hover, value here empty. there missing because can see value on forms load event, once try use in action mia

thanks justin

sounds scope problem. mainid declared?

if declare within form open procedure, it's gone once procedure finishes.

consider changing button's click event procedure.

if myrs!mainid = val(me.openargs)

openargs doesn't "go away" after form load. don't see why need store openargs mainid variable. use val(me.openargs) using mainid variable.

alternatively, make mainid module level variable available form's procedures.

update: there situation might open form without feeding value openargs? if so, val(me.openargs) return 0. error condition in application's logic? should command button "clickable" (enabled) when openargs value has not been supplied?


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more