Search results

Yes I switched to the filter idea and all us well.... more details at the bottom of:- http://www.access-programmers.co.uk/forums/showthread.php?p=1126156#post1126156 Thnx

Hi IN the end I opted to lose the master/child links and use ADODB filter on the subform managed by the mainform current event.... so in that event I have this Dim CntrlBX As Control Set CntrlBx = Me.My_SubForm_Control_Name CntrlBx.Form.Recordset.Filter = adFilterNone...

Hi I added a button to another form with a click event calling Forms!MyMainFrm.Form!ID and it reported the value correctly... Rather than try to do this in the Recordsource string, I think I'm going to try to apply an ADO filter on the underlying RS and then modify it from the main form...

Hi Thanks for the reply. I tried the suggested syntax but the !ID does not get updated whilst moving thru' the mainform... I msgbox the recordsource out and the "TBL1.Addrs_ID =" always shows the same value... i.e. the number of the record at which the master form was at when the recordsource...

HI I've a mainform/subform setup. I want to link them but I can't use the master/child links. I spent weeks converting them to use ADODB recordsets and when I try to add links I just get 'data providor could not be located'... I guess that master-child links only work with DAO? I build and...

Hi Unless I'm missing something, I have both... TBL1.Unique_No AS TBL1_Unique_No, TBL1.Contacts_Unique_No AS TBL1_Contacts_Unique_No The Contacts_Unique_No is the foreign PKey in the Addresses table for the Contacts table.... The odd thing is that ,despite the parameter value box...

Hi Got an interesting syntax issue. I have a linked Mainform/Subform set up. My main form is populated with an SQL Select statement in the recordsource... For all manner of reasons (mainly due to the possiblilty of a JOIN) I have to alias the column names in the Select by altering the "."...

Hi Thanks for the reply. I use an "ID" field to link a family of documents... the first autonumber , "Unique_No", created for any given family is used as the common ID number for all members. So the need to collect and re-write the autonum field in "ID" only happens once. It's an Access 2007...

Hi Thanks for the replies. Unfortunately, I originally had my CNX set to CurrentProject.AccessConnection but it would not allow me to do .addNews ... I could only get that with CurrentProject.Connection.... so looks like I'll have to think of something else... rgds

Hi Thanks for the reply.... I've give that a whirl but no joy...I think support for table aliasing in Access is unbelievably poor.. it's driven me to distraction..... I've been avoiding this for months but I think the only way to get around all these problems is to give every column in the...

Hi I'm struggling with yet another syntax problem... I want to reference a field in a form/subform recordset that has a table join in it's recordsource... SELECT * FROM My_Table WHERE Unique_no = Forms!Addrs_Dtls_Form.Addrs_Dtls_SubForm.Form![TBL1.Parent_Unique_No] If I keep the square...

Hi Anyone know where I'm going wrong here? Trying to 1. Add a record to an ADODB recordset 2. Call update to ensure a new record is created and a value given to my autonumber field (TBL1.Unique_No) 3. Scroll back to the new record again 4. Edit a field in that new record based on the newly...

Hi No luck with Allen Brownes suggestion I'm afraid. I did upgrade to SP3 on Windows XP recently... I guess it could be something in there but needles and haystacks springs to mind. Just a quick question please.... I populate my form with via an SQL string applied to the form's...

Hi Thanks I'll have a look at that link... As for cancellling updates... I have gone thru' the Access mill on that times without nunmber... the problem is that the me.undo' , cancel=vbtrue's etc only work under certain circumstances.... I found that Rs's with joined tables often go...

Hi I've a form set up where I dynamically build SQL strings and apply them as recordsources to various forms. I switch form Rs's to a 'temporary' recordset when a record is being edited.... this way, if the user clicks my custom cancel button, I can simply re-set the recordsource to the...

Well the 'locking up' of Access seems to happen less often but it's still a major pain... Sometimes when forms crash the CNX does not get closed. When I try Access 'X' button, it sometimes does not close... but it does prevent any other action beoing taken in Access (it 'freezes' it). I then...

Sure... thanks I use SQL transactions (begintrans/commit/rollback etc) with ADODB Rs's in my forms. I set up a new connection in the form-open and set it to CurrentProject.Connection. The forms in question are modal. The problem I am utlimately trying to fix is that (especially during...

Hi Thanks for the reply. I've tried various permutations of the doCmd.close in the subform but they result in an error 2585 "This action canot be carried out while processing a form or report event". So some process is still running... you'd think there would be a way to force-close a form?

Hi Here's one I've been meaning to tackle properly for a while. It's a Form/Subform situation where there are events in the subform. Where an error occurs in the subform (a checkbox click event or whatever) I want to close the form and especially want to run the main form unload sub. When...

Oh yes. I see... I'm with you.... I'll move the closing of the CNX to the form's unload event and try it there for a while... see if it improves.... will update later.... thnx