Recent content by redBo

Hi, it's me again... This time I have a child form that has two parents and could be called (ie opened by DoCmd.Open.....) by either parent. Once the child has done it's thing, it needs to write a value back to the parent form (the callee). The field it writes to is the same in both forms...

Nice.... Thanks for clearing that out... I just hit that randomly trying things... so proper explanation helps for novices like myself.

Hello Guys/Gals I am a novice to VBA+Access. I am not sure how access/vba handles memory allocation. For example, if I declare variables inside objects (ie forms), are they cleared as soon as the objects are closed? Or do I have to clear this manually, and if so , how(what is the code) would I...

Oopss.... I got it working now... For those interested: me.subform.form.RecordSource = strSQL lets you set source

Hello all, I have a subform, frmSubA, in a main form, frmMain. The subform has a "default" RecordSource set, an SQL query (SELECT * from tblFields) I would also like to set the RecordSource of the subform from the mainform. I tried this: Me.frmSubA (I just used the access toolbox to put...

Thanks, works like a charm....

Hello All! I am running Access 2003. Time format is set to Australian standards (ie dd/mm/yyyy). I have a field in my table whose property is set to Medium Date. Similarly a textbox in form, property set to Medium Date. Im saving the form value to the table using the following technique...

thanks for the responses guys. I am importing and putting in a temp table. I have two issues here. I cannot modify the supplier's database as this is delivered as a fresh update every month. I know there will always be one table. Name of the table changes every month (ie. dataJan2007...

Hello all, Hope this is the right section to post this question. I thank all for any assistance in advance. We basically have a supplier's access database that contains one table of prices. In addition, there also exists an excel file that contains applicable discounts against the supplier's...