Search results

Hi..the field that you do the calculation in on the subform, (you need to do the original calculation there unless someone knows otherwise..) is referenced on the main form by using .. =Nz([subformnamehere].[Form]![nameofcontrolinsubformthatholdsthetotalyouwant],0) which is the control source...

Hi ..try this it works for me .. Your subform text box should be in the subform footer Make this the control source of your text box in the main from =Nz([subformnamehere].[Form]![nameofcontrolinsubformthatholdsthetotalyouwant],0) hope it helps

Morning Rabbie...works a treat many, many thanks for your help, and on to my next brain teaser :) cheers Fi

Yours sure does work:).. not getting it to work on mine yet.. but will work on and post back thanks a lot for posting the demo...cheers Fi

Hi Rabbie...any chance you could post the form or do a screen print so i can see what you did and where you put it ...:) as it does sound like the best way to do it cheers Fi (In Exile in Gibraltar )

Hi Rabbie...tried Dmax as the default value of the field, couldnt get it to work I'm afraid, I am going to stick with AutoID +50000 as the easy option, its never going to be a huge DB perhaps 20 new records a week so hopefully the AutoID number will behave :) thanks again for all your help...

hi Rabbie..data is entered directly to the form, at the moment I have DataStoreID primary key of the underlying table used to give a sequential number by adding a text box which adds 50000 to the ID number, which works well and cant be changed by the user and i have a number that is generated by...

Hi Rabbie...thanks for your reply, where you say to put the expression directly in the payment table would I put it in for example Validation rule??.. apologies my knowledge is fairly limited :) I had tried putting it on the query behind the form but that didnt work (the way I had done it...

Hi Rabbie...been playing about with the code and am guessing that most of the original code should have stayed and that I should have inserted your Dmax solution into it, I have tried but am not sure how and where to add it to make it work...would you be able to help furhter ?? thanks again fi

Hi Rabbie...I have put this on the OnClick event of the cmd button Private Sub cmdGetNumber_Click() Me.CRNum = DMax("NextNum", "tblNextNum") + 1 End Sub I started the NextNum at 49999 in tblNextNum it works for the first record created then all other it stays at 50000 ?? would you know what is...

Hi Rabbie...the reason I wanted an autonumber is because my DB is to produce documents to raise payments, currently the numbering system of these docs is a 5 digit number starting with 5 ie 50000 etc i wanted the users to be able to create a record and once it is ready to print they would click...

Hi...I am using the following code to generate an auto number (taken from previous thread on this forum as always;) ) problem is the button whcih genartes the autonumber will generate a new number each time clicked within the same record I would like the field to lock after it has been updated...

hi fifty2one..thanks for the reply here is what I have on the OnDblClick event Private Sub ClientCompanyName_DblClick(Cancel As Integer) DoCmd.OpenForm "frmAgedDebtorsStore", acNormal, "", "[ClientID]=[Forms]![frmClientDebtLookUp]![ClientID]", acEdit, acNormal End Sub am I missing something on...

Hi...with help from previous posts I have the subform on the mainform (frmAgedDebtorsStore) opening at a new record only, it is set to singleform with DataEntry set to Yes and again from a good thread i have mimicked viewing the previous data entered on the subform by adding another subform...

Rabbie ..u r a star...cheers Fi:)

Hi..is it possible to view Linked Table Manager from a button on a form..using code on the OnClick Event ?? thanks for any help...cheers Fi

Hi...been reading various threads and it sounds like it would only be possible with a lot of code and unbound forms (Rich in 2005 so perhaps that has changed), I have used the code below not ideal but at least gets the focus on the last record when the subform opens, it that helps Private Sub...

Hi Sue...I was just about to post this exact question :) if you work it out could you post your solution as I will do ...cheers Fi

Glad I was fanally able to help someone instead of being the other way around :D

add a text box to table A to hold the data then set the control source of the combo box to the text box in table A ...hope this helps..Fi