mysql - Access: How to structure input vs read only forms -

-

ive got peoples db , after development recordset main form not updatable because of subqueries etc etc..

all because redesigned db resemble real life more, meaning added tables track things. made relations little more complex , im left db cant add new records or edit hahaha , thats pretty useless

so i'm left thinking can't me there either simple solution can't see or have designed forms totally wrong.

whats praxis in design/structure when have/get form based on recordset that's not updatable in "regular" peoples db , want add or edit details in it? (think hr managment db)

relationships

(reason recordset being un-updatable: recordset based on query gets records 3 related tables , max function on date field recent record on 2 of tables)

now have mainform , 3 subforms on it. can edit/add info in subforms of course mainform displaying names , other personal details not updatable...

the mainforms query querying tblperson, tblinmate, tblclassificationhistory , tblsquadhistory...

in case, recommend 2 possibilities:

  1. build form input , edit data persons record source tblperson. input/edit-form can open in main form via button or ribbon example. can build 1 form input , edit data , change behaviour vba-code (or macros?). or can build 2 forms edit , input data seperately. can add ok , cancel buttons safe or undo changes. possibilities endless. basis access knowledge , there tons of tutorials out there, not explain further.
  2. change query on main form. if have continuous form , not want add new form, should edit query. can not estimate described query complexity given information, there must way "max-date"-recordsset without aggregated ("group by" -statement) query results. goal change main-form query, not have "group by" part. aware can use subquerys "group by" finding "max-value". should check main form query, if need queried fields main form. let 3 subforms data query work.

basically, perfect user interface (ui) forms in access depends on users preferences, expectations , use case itself. have find out, design suits best application. can research on ui design patterns if want knowledge recent experiences. huge field of expertise!


Comments

Post a Comment

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

-
i trying parse date 2014-12-03t10:05:59.5646+08:00 using these 2 formats: yyyy-mm-dd't'hh:mm:ss yyyy-mm-dd't'hh:mm:ssxxx when parse using yyyy-mm-dd't'hh:mm:ss works fine, when parse yyyy-mm-dd't'hh:mm:ssxxx parseexception thrown. which correct format parse date , difference between these 2 formats? note : cannot use joda :( those valid formats: yyyy-mm-dd't'hh:mm:ss.sssz >>> e.g.: 2001-07-04t12:08:56.235-0700 yyyy-mm-dd't'hh:mm:ss.sssxxx >>> e.g.: 2001-07-04t12:08:56.235-07:00 edit: btw, "x" refer (iso 8601 time zone)
Read more

c# - Get rid of xmlns attribute when adding node to existing xml -

-
i have xml-file: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:d>some content</d> </a> </root> i need add new node in specific place, code is: var doc = xdocument.load(file); xnamespace ns2 = "namespace"; doc.element(ns2 + "root").element(ns2 + "a").element(ns2 + "c").addafterself( new xelement(ns2+"new", new xelement("new1", new xelement("new2","some content"), new xelement("new3", "some content")))); the output is: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:new> <new1 xmlns=""> <new2>some content</new2> ...
Read more