Search results

hi, i have a form with a dropdown list of values e.g category (values, A , B, C). When select on category, it should display a kind of checklist which will need to tick and save value in table. each category A, B , C will have their own checklist. sample db attached. whats the best way.. to...

thanks arnelgp :) perfect.. it works !

i tried the code but getting error: when click on yes get run time error '2115' debug pointing to Me.Dirty = False when click No runtime error '-2147352567(80020009) debug point to Me.CIR = "" The macro or function set to the beforeUpdate or validationRule property for this field is...

actually the code will be pops up for duplicated CIR. if CIR exists in the table then msg will be display that it exists and option to click on Yes it should allow the CIR entry and cursor go to next text If Click NO, then it should clear text box Is it possible to do that??

hi access 16, have several text box (ID, CIR, Name) in a form with a save btn.. if when input a CIR that already exist then below display added the code in before_update.. how to amend it that when click on yes it goes to next text box i.e name when click on no.. it clear the text box CIR...

Hi, In access 2016, I have a forms with some locked fields. How can i display a message that when select a value from the drop-down then a msg pop up that "Access denied to amend this field".

ppfff.. yes its working.. :) Thanks a lots June7

The filter property and filter on loade to be added in search btn or form property? Vba code added on click event proc for search btn As whn I click on search it not doing anything...

can u pls amend the testdb.. it still not wrking

no its not working.. can u pls chk attached file.

writing it like that but getting error.. "compile error: Expected:line number or label or statement or end of statement" what i miss pls.. Dim strSearchCriteria As Variant strSearchCriteria = Null strSearchCriteria = "NZ([emp_name],"") Like " * " & [Forms]![FrmTestSearch]![Combo224] &"*'"...

the Nz(fieldname,"") LIKE ... is ok.. :) But im adding multiple combo box 6more and its getting limited character. Any of those 6 fields can be null [Emp_name] Like "*" & [Forms]![FrmTestSearch]![Combo224] & "*" And (IsNull([comp_name]) OR Nz([comp_name]) Like "*" &...

It seems that in the main table if one of the field used in the combo is null then the record is not being displayed in the form. but if i put any data in the fields that used as combo.. then get record is displayed. search cmd attached. How can do it to display the record even if some fields...

The combo contains a list of drop down values. Select combo value and click search btn Is there any limit of display in continuous form?

hi, access 2016 Ive a continuous form with 5 combo box, a search btn and a clear btn in the header. Detail form contain the text box for data display and footer blank. After select of empl_name and click on search btn. its displaying only 25 records instead of 32 records. But when the query...

i want the highlighted data to be displayed. Will post a db sample

hi, i have 2 tables.. tbl_sales fields (ID, Date, Empl_name, type, status, category, comments) contains full list of all details that being sold per date. tbl_specific_empl fields(ID, mainEmpl_name) contains only 5 specific employee name using it as list of values. tables are...

hi, i have an excel macro sheet that contain a button . It consolidate the data from other sheets to a main sheet in the excel. After have a mail merge template V2016, that take data from the excel like name, address, phone to create the letters. The documents (mail merge template & macros)...

Ive changed ze function & module name and was ok. thxs

hi, Pls help... getting error undefined function 'fncDateDiff' in expression when opening / running the query.