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

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

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

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

Hi i am trying to dynamically change the IN sql from within VBA using parameters. for some reason i have no luck, no errors shows up, but it's actually not picking up the criteria. can someone guide me what i am doing wrong here ? thanks in advance ! THE SQL IN STATEMENT In (select RemID...

Hi Guys i am having an issue setting an instantiated forms' control. i am having RemDate ("Date") and RemTime ("Time") TextBox; so far the date textbox shows 1/1/1988 12:00 AM (the visible value is the time only) and the Time textbox Doesn't show anything; any inputs are appreciated ...

Hi Guys i am using the method from allen browne http://allenbrowne.com/ser-35.html to open a form and add it to a collection and when removing it it closes. actually, usually it does work so but i have now a form which does not close until i am hitting the reset button in VBE , is there...

hi, i am having a field with values like this 7132013220348, which is 7/13/2013/ 22:03:48, how can i make it happen it should be a date\time , the records are being imported from a raw text file, the field type is text thanks,

Hi, i would like to get some help how to receive emails using pop3 with gmail using the Microsoft CDO class, thanks in advance !

Hi, My Access 2010 DB which is working on another computer will not work on my, i tried to export the corrupted Forms as text and loadastext which was successful, but the reports is not working and will just not respond i cant understand why on another computer which uses the same office...

Hi, i have one form filtered based on a field value, now i want to open another form which has only the same member ID but not the actual field on what the first form had been filtered (so i cannot just use the same filter) , so what i want to do is that the 2nd form should only show the members...

Hi, i am having a orders Table having customers ordering spots in a publication, so let say that 1 spot is $100 and they ordered 4 spots and they paid only $300 i want a report should show a equal amount for the 4 spots ,in this case $75 for each, any help will be appreciated !

Hi, i would like to know if someone can guide me or there is some tool to get a list of table and field differences when comparing 2 databases thanks,

Hi, i am trying to group the following Query to find duplicates with no success any help will be appreciated Base Query: SELECT AccountActivity.AccountID, Mid([details],InStr(1,[details],"-")-1,4) AS FetchedCat, elookup("Neighborhood","Combo","Category='" & [FetchedCat] & "'") AS...

Hi, i am trying to get in-Depth information of the RaiseEvent method, i believe it will enhance Building my applications, i understand so far that it will call a procedure but i don't understand the difference whether just referencing the sub \ function then using RaiseEvent, any guidance is...

Hi, i need help for this criteria, in the false part it should return anything even its null, i tried adding "*" or is null does not work, any help?? thanks in advance: Like IIf([Forms]![Master].[Customers_Panel].[Form]![cmbSearchBY]=3,'*' &...