Search results

I'm having an Access FE with SQL server 2014 BE. when adding a record via ADO and trying to Retrieve the Identity ID I'm getting An error "Record is deleted" as per my research, it has to do with having a trigger "For Insert" but the trigger is only adding a record to an unrelated table, so I'm...

Hi Guys i am trying to figure out what happened to the code that it resets the err info after the Msgbox so i cannot log the detailed info in ErrorHandler Function anymore. Any thoughts ? I see it happens right after the MsgBox as a Debug.Print will also show the object reset MsgBox "Error: "...

@gemma-the-husky I Wouldn't say that this is the intent of Forms... although, this is one of the tasks it performs. So what's the rule for a business Contact list, how wide should be the business name field ? how bad is if the user can just-for-now drag a little the Company Name' Field to see...

Let me express myself better... Of course you can sort,filter every form and columns. But I'm referring to the built in column filter DropDown(table style) and the resizable columns which can be sort of help in some scenarios. For ex. Using a sub form for a side panel with list of contacts and...

@HiTechCoach A continuous form having all the abilities as a regular form - will still have its own limitations. Column filter, resizing columns with dragging. Did you ever overcome those limitations?

No. But you can make a field formatted and use the click event so it'll look and act like a button. Regards Joseph

sorry for not being expressive enough.... i meant to say that the class module it-self does not have a collection which holds all the properties like a form does (me.controls(item)) or a table (me.fields(fld))... In Short To get a collection of all the properties defined in class module By Ref...

Hi Guys Thanks for taking the time and reply... everybody's effort is appreciated ! Basically, the answer to my question is "NO". meaning - I can't pass a variable byref. But I would like to comment that this statement isn't true - "you can't pass a variable by ref" - because in case of...

Hi Guys is it possible to add a variable to a collection ByRef as i wanted to be able to set the value via collection and be cloned to the actual veriable. thanks in advance my Code: m_colItem.Add ShullContactID, "ShullContactID" m_colItem.Add LocationID, "LocationID"...

Hi Guys am trying to pass the FileDialogFilters collection to a method called "GetFileDialog" and am receiving an error that the object weren't SET... i tried to use the "NEW" keyword but doesn't seem to work for the FD object at-All. so my question is how can i initialize the collection object...

Hi Guys Ihave implemented custom events to sync between open forms. I noticed that if the code is engaging in middle of the way referncing a form with form constant (Form_formName) then the listeners stops listening so the event isn't firing, without getting the reason of this i just avoid...

Hi I am trying to figure out how to be able to enter time in access form the same way as if would be an access table (1p = 1:00 PM; 1.25 = 1:25 AM etc) any help would be appreciated

where should is start ?? Basically, i have form "contract" with subform "Payments" form "Contract" sets a variable to an instance of the Class module "clsContract" and accompanying properties...... when user hits "New" on contract form it sets clsContract.RecordStatus ="New Contract" when user...

EDIT: i see now that all the variables are having the same issue, not only class instance (i started using Raise event lately. in code. might be the cause ?)

Hi Guys I am having a strange behavior. I have a parent form which has a class variable (class module instance) to store the form' status and more.... and when i add a new record to the subform it resets the class variable field' data. but this only happens on first transaction, but if i re-run...

Final ! i've restructure the code with RaiseEvent 's so every form takes care of itself :)

thanks for reply. i must agree that's relative news for me. anyhow. till now it was reflecting the control, But suddenly it doesn't listen to me :( what could it be ?

Hi Guys as strange it appears it happened ! i have a VBA routine to lock\unlock controls on a form; the code is in a standard module (outside the form) where it calls the form using Form_FormName.ctrl.locked = true\false after running the sub and checking in immediate window...

Thanks for trying to help !! Sorry, but It's not even close to my direction. 1. I'm in USA so I don't even understand what you want to point out with date format 2. The 3rd parameter (sDismiss) is not a Boolean I want to pass a chunk of string (optional criteria) using the parameter (review the...

Thanks for reply: here's the SQL as an whole. please point me where i am wrong PARAMETERS [sDismiss] Value, [date1] DateTime, [date2] DateTime; INSERT INTO tmpReminderList ( RemID, Tbl, Fld, PrimKey, Description, Reminding, mValue, Remarks, Created, [User], Assignees ) SELECT...