Search results

I tried it Forms!frm_adminmode!sfr_AdminTrainingHistory.Form.Filter = "participantid = 'u565873'" and it gives me error message that it is an invalid reference to the form btw participantid is in subformB (sfr_AdminTrainingHistory) the above code is in the OnCurrent event of subformA Any...

it is not a control, it is text (for testing purposes) afterwards I would like to put a control of the subform there

Dear All, I have a form that contains two subforms SubformA contains LogonID, SubformB contains the same but with a different recordset I would like that if I click on any records in SubformA, SubformB gets filtered to display records for UserID in SubformA I have put this code to SubformA...

Thank you very much it works fine!!

I use Access 2007

Unfortunately I have 2 fields to check as the table has a compound key Basically I dont want to check them as primary key is set so Access checks them for me, I just want to display an error message when entering duplicates with the "Accmd Newrec" method Do you have any suggestions please? Thank you

Dear All, I have a table with a compound key I have a form with a button that adds new records each time pressed Code: DoCmd.GoToRecord , , acNewRec Me!sfr_LineManID.Form!ParticipantID = Me.user Me!sfr_LineManID.Form!StatusAlloc = "Pending approval" If I want to add duplicate values data is...

Thank you, it works very well!! :)

Dear All, I would like to know how I can make Access 2007 display a message if I open a database that contains macros but in the Trust Center macros are disabled I know that Access automatically displays a warning bar when doing so, but that is no good to me, I would need a msgbox that appears...

it works, but first you need to check the version number in the registry, I think for Access 2010 it will be 13.0 instead of 12.0

Thank you but is there a way to skip saving the attachment as a file? So the OLE object could be sent as an attachment without first being saved in a file on the hard disk... Cheers

Dear All, I have a form that contains an unbound OLE object (xlsx file) I would need to send that as an attachment in an email In my code I use: olattach.Add Me.OLEobject but I get an error message that object does not support this property or method Could you please advise? Many thanks

The problem is that this is for Access 2000 and not for 2007 I tried it and it did not work with a 2007 db.... :(

Dear All, In case of an Access 2007 database, how can I see who is actually in the database? (username(s)) Many thanks ;)

OK, then is there a way to run a code when a subdatasheet is expanded? (it is actually a form in Datasheet view) Thank you

Dear All, Which event is triggered when a subdatasheet is expanded/collapsed? Many thanks!

Thank you, I will try that! Just out of curiosity, what else do you use instead of subdatasheets? Cheers

Thank you But now I have another issue: what is the event that is triggered when expanding a subdatasheet? - as I would need to use the ColumnHidden property at that event Many thanks!!

Dear All, I have a main form with a subform, both in Datasheet view I use the little + sign to expand the main form in order to see the subform If a control on my main form has a specific value I would like the subform to hide certain fields (datasheet view!) when expanded I tried using...

OK, can I use then two continuous forms instead of datasheet view? (for me it does not work either :( Thank you!