Search results

hi. got it working by using the load event of he subform which happens after the open event and (importantly) after the code in my main form finishes. still confused as to why form.filter wasn't working but I'll save that battle for another day. thanks.

thanks bob i'm getting error saying can't find the form when i use Forms!.... what i want is to - click a row in a datasheet - get the stockcode value - load another form into the subform - set the combo box on that form to my selected stockcode - filter the form by the stockcode the filter...

worked perfectly. thankyou.

ahhhhghghhgghhh why oh why is access messing with me. i have this If Left(ctl.Name, 11) = "txt_SafeHaz" Then MsgBox ctl.Value MsgBox Me.txt_SafeHaz01.Value basically i wat to loop through my controls. when i get to some with a prefix of called...

hi i want to be able to use vba to 'click' a button on a subform on another form. hope that makes sense. i have this Form_frm_main_form.frm_subform.Form.cmd_reset_Click but it doesn;t work. i'm getting an app/object error. anyone? thanks

Hi i am trying to create a dsn less connection so i don;t have to go round to each pc to set up an odbc conn. i have found this... oConn.Open "Driver={SQL Server};" & _ "Server=myServer;" & _ "Database=myDB;" & _ "Uid=myUser;" & _ "Pwd=myPass" but...

hi i am trying to get he values of some check boxes and put them into an array. I can see on my form that some are checked, other not. however when i loop through the controls all the check boxes are coming up as -1 even though i know they are not. when i click the check box i have the...

Hi i have a navigation control (access 2010) and one of my button is 'admin'. I want to cancel the admin form loading if the user doesn;t have access. To check access i do a lookup in a table on the click event of the nav button. problem is that even when i exit the sub the admin form still...

hi my form has some unbound radio buttons (Yes/No options) which when changed update the value in a hidden bound textbox (values Y and N, the db was set up this way unfortunately). i want to create a rollback table so that changes can be undone. so, on the forms dirty event i insert the...

i tried using the OnDirty event for the form which does fire when i make a change to one of the forms controls but if i set OnDirty = True after i've made my insert it fires the OnDirty event again so i get stuck inside the OnDirty event. If i change it to OnDirty = false then then the next...

thanks bob. I think that's definitely the correct code to get the value but what i need is an event that is triggered by a change to the form NOT the control, otherwise i'll have to go through every form control and add something like an after update event. That would be a pain as there are...

Hi I have a form that gets updated regularly. I want to create an audit of changes made to records. How can i get the value of the field with focus (to insert into a table) without placing an event on every form control? thanks

Hi i'm trying to return a list of all users in my companies active directory. i have : Private Sub Command2_Click() Set objConnection = CreateObject("ADODB.Connection") Set objCommand = CreateObject("ADODB.Command") objConnection.provider = "ADsDSOObject" objConnection.Open "Active...

worked perfect thanks.

Hi i am dynamically changing the sourceobject of a sub form. I need to pass the subforms sourceobject into a function, as a form. This doesn't seem to work Dim nexTbl As Form Set nexTbl = Form(frm_nexus_switcher.SourceObject) I get an 'access can;t find "my form" error. what's going wrong...

Hi i have an OnExit event from a text box in a subform (bound) that insert's the record into another table. Can i check whether the field being exited has changed from it's original value?? If the value hasn't changed i don't want to run the insert. Thanks

Hi the field is typed by the user from 'H' to ''. so 0 length string?? Thanks

Hi i am trying to filter a recordset but it doesn't seem to be working. The forms recordset has 3 rows. One of the fields is a status flag. I want to only show the rows in my recordset where the StatusFlag is empty (""). I use the filter but when i do a row count i still get 3 rows...

Hi Is it possible to create a form in outlook and when it gets sent to me (or a mail group) to automatically populate a table, or when i click a button within access it retrieves the email data? can't seem to find anything definitive on the web. thanks, Spin.

hi i have a memo field which i've put into a report. is it possible to conditionally format a part of the text to bold?? i.e. if the text = "My Name" then format only the text "My Name" in the memo to bold?? Thanks.