Search results

Hi friends A quick one . User at sub form, i want to give him a dialog box when he leaves a sub form record that will move him to a new record in the sub form. At this point i would like to offer user an option to move to new record in the main form instead. Got it, i hope? I was thinking...

Bro & Sis, your ideas give me something to tinker further. Thanks & more hopeful with the light up.

To those who was following this, i think i know what is the cause of this phenomena. Essentially if 2 subforms are unrelated, if we try to make changes to 2nd subform from an event in first subform it will not work. I experimented by setting focus on the 2nd form and then apply the filter from...

Thank you Sir, will follow your good suggestions. Have a good day!

Thanks mate, Update Query should be fast & easy Would the "Adj Qry" be the similar to an Update Query or you can show how. Essentially i have to pick up a few values in the recordset, add them together and assign to a target record. Thus i created a simple select recordset, pick the...

3rd time around i will try another way just simple buttons on a single form to filter and come back to this problem when i settle down my current urgent needs. Thanks G.

Hi gurus This must be dead simple and yet i don't know Lets say i have a adodb.recordset eg rsMy which is opened with 2 fields eg rsMy.open "SELECT Fld1, Fld2 FROM tbl;", currentproject.connection,1,3,1 I want to assign a value to Fld2 eg "valt" for a record with value "Tgt" for Fld1. How...

G because i am not sure how or if it is really necessary. A little direction may help. :D Two subforms are in the same mainform; my little evil plan is when user switch records in Switchingsubform, on arrival in a new Record, filter codes is sent using TargetForm..blah blah from...

Sorry Gina you whizzing by with blank string did not do the trick. I was just wondering if this is the cause. All subforms at in Main form and there is NO relationship among them eg master / child relationship. The event in the switching subform is OnCurrent wherein the filter codes are sent...

Got you, Thanks. Will try how it goes.

Point about reserved word taken. I have used linked tables but what you just said is new to me in relations to recordsource. Are you saying that this is a way from filter option. I imagine it is a iink to a recordsource via a linkFld, hope you can elaborate a bit. Thanks in advance.

I remember that filter has the following observations It will fire the current event if AllowEdit is False, filter will not work IF current Record is already outside the filter, it will not work. Could the last observation be the culprit? :banghead:

I did not use Field, it is for this thread only i use the reserved word field.

Yes Sir With Form_Target .FilterOn = False .Filter = "Left([Num],2) = '" & me.Field & "'" .FilterOn = True End With If i use recordsource then "select * From Tbl where Left([Num],2) = '" & me.Field & "';"

In Access 02, 03 & 07 it happens. If i get out of the Access and return then no problem, filter works first time ... but on reentering form, same problem as stated above. Compact and repair mdb still problems persist. I am going to duplicate this with a much simpler form to see what really...

Sorry Pat, thousand apologises.

Hi guys This is really puzzling for my little brain. I have a FormM with than one sub forms. I use one of this subform eg SwForm to filter or change the recordsource on TargetSubForm eg TargetSubForm.Filter = "[fid] = 'x'" whenever SwForm goes currentEvent on a record ie arriving on...

Sir you have always gave the most valuable practical advice, THANK YOU SO MUCH.

Hi members I had avoided moving away from Access02/03; I was just comfortably enjoying the .mdb even avoided using .accdb from 07. The reason being I feel so good staying in my comfort zone; living with familiar things yet get the job done. At the back of my mind is "small is good"...

Enjoy the exchanges & learning. For mdb or accdb i only backup at the start/end of each session by a user. In an multi users environment, the file system will not allow you to do it if another is using it anyway.