Search results

Hi guys, I searched the whole day but couldn't figure out this. Any help is greatly appreciated!! I got my code working fine in Excel, but just cant get it run in Access when i try to open a secured db with group security from a normal Access 2k db. DBEngine.SystemDB = "C:\Documents and...

Hi guys I'd like to track my subform changes. Records in the subform are updated through code via a button and are displayed based on a filtered parameter. My audit trail can track changes if forms are dirty but in this case form is never dirty. Any advise please! Thanks

i have nested forms up to 2 levels for now. The subs in datasheet view. I'd like to know if which subform has the focus. I tried various way like using PreviousControl or ActiveControl property but failed at sub2 as its the control on sub1. anyone has any idea? thanks

Hi guys I have a problem with filtering a query in criteria using either iff or switch builtin function. my codes look like this Like Switch([Forms]![frmMain]![grpReq]=1,"SysReq*",[Forms]![frmMain]![grpReq]=2,"ACR*",[Forms]![frmMain]![grpReq]=3,"ACSR*", [Forms]![frmMain]![grpReq]=4, not like...

Hi all i have a combo box on a form bound to a table with the source from another table. It works fine! what is interesting to me is that when i move the focus to this combo, the form becomes dirty though i havent made any changes? Could anyone enlighten me on this? is there any workaround cos...

Hi guys thank you in advance for any idea/info!! i have 2 tables, P.O and Invoice. In PO tbl i have an Invoice field with Index set to Yes (No duplicate) On a form based on PO table, I couldnt enter a new record due to this so i set the Index back to NO Now..I have a combo bound to PO table...

i have a mainform containing 2 subforms. 1st subform will display a list of records for a search on the mainform.2nd will display a list of records for a selected record on the 1st subform. The problem is that 2nd subform will show only records corresponding to the 1st record on the 1st subform...

hi all, got a tricky problem...hope to get help from u all...appreciate!!! i almost complete this but run into a "refresh" problem..I have a mainform with a textfield where users can input a number to search for an item; if found, a list in the 1st subform will appear in datasheet view. When i...

hi all, I can't seem to find any topics related to my prob, be it here or Google :( so here i am asking you all for help! I have a main form built on a table named "tblStockItems" and a subform built on a query named "qry" which is based on tblUsedIn. The main form shows each item in...