Search results

Phew..found the problem. The Access program open the default system workgroup instead using the workgroup i assigned

hi maybe i was too brief.. so here i try again..I want to open a secure backend database. And i got my code working fine in Excel (open the db, grab data). The problem is when i run in Access and it gives error 3029 at this line (password,username all correct) Set MyWorkspace =...

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

well..I solved it finally. Just to share my experience with whoever may need it 1. i created a public variable and use it as part of the condition. Thank you Rural 2. rectify my mistake of using wrongly the events of subform. Shoud use subform control's events not subform's!!

Thank you for your reply! I tried using get focus and lost focus events of a hidden button on sub2. It didn't work when opened as a control of sub1 but worked if opened as a form on its own. I am not sure if i know correctly what u meant but will try that anyway.Thanks again Maybe there is a...

any one has any idea? :) to elaborate, i need to pull out information from a field in either sub1 or sub2 when the focus is on a particular record on either sub1 or sub2 hence the need to check if which sub form has focus. I know sub2 will be treated as a control on sub1 so how can i...

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

spot on Chris! thats exactly what i did and i got it done thanks again cheers mate

BRILLIANT! thanks stopher..got it workingnow... i agree with you on the function does not want to evaluate the expression i pass. Dont see it will affect performance at all.dont see how. One setback though..somehow it disables my 2nd level datasheet subform on the 1st level subform. Anyway, will...

Thanks all for your input. This "Not (Like "SysReq*" Or Like "ACR*" Or Like "ACSR*")" works fine (return the values i want) in a criteria of a query. But when it's used as a "true part" in a Iff function or as "value" in Switch function, it just doesnt work. Stopher,maybe i didnt explain mysefl...

actually i tried that already..even after i removed everything leaving only 'not like "SysReq*" ' it still didnt work..

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...

I'd like to add my unimportant thought...This forums and a lot of members(seniors, veterans) are so helpful, best on the net. Its not just the help given but the the willingness to share that is amazing.i learnt a lot from here. Thank you and APPRECIATE!:)

why not make all the subforms invisible? when you need a form, you'd make it visible... lets say when your CV selected in the combo, the form would appear. Put the code in AfterUpdate event If cboName = "CV" Then subfrmCV.Form.Visible = True End If

hi i found the problem...its the date format i use b4 entering the combo box...thanks

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...

I dont know if i understand you right but the field IO in PO table has "Number" as its data type. How can the index interfere in this case i wonder?

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...

oh man!! you are great! thanks a lot...it worked!!!dont know y i tried other ways but couldnt work...thanks alot:D