Recent content by ylp

Thanks very much! You are right, assigning values to the form and then trying to update the table by executing the query caused the problem. Me.requery solved the problem. Thanks, this forum is great!!

thanks for your great help!

yes, the pk is the autonumber.

Yes, a field from a record.

Hi, I have a continuous form with a textbox, which displays one month records' integer data, I need to get the current and previous record and see which one is bigger ? I can get current one easily, but is there a easy way to get the previous one? Thanks for help!

Actually, assigning to the form is because these values are based on the calculation, and then write to DB. do you mean I cannot data bound these values? Also tried: If Me.Dirty = True Then Me.Dirty = False Still got the error? Any other ideas? Thanks

' set the total of totalFullDrums,GallonsPart and gallonsDayTank. 'Me.sumGallons = totalFullDrum + Me.GallonsPart + Me.GallonsDayTank varSumGallons = totalFullDrum + varGallonsPart + varGallonsDayTank 'Set the lbs varAcidBegin = varSumGallons * 14 'Display the updated values Me.txtTotalFullDrums...

just one line: Call Me.combo_AfterUpdate

Thanks so much! Before I have the txtA_afterUpdate, No error. but if user update txtA value, the calculation result does not change, that's why I add this event there. I tried: RunCommand acCmdSaveRecord in the txtA_afterUpdate event before call Combo_afterUpdate, but got the error twice,one...

Hi, I have a subform with two textboxes(data bound),let's say txtA and txtB, and one combobox with 2 different values( let's say 5,6). For both the combo and txtA,I have AfterUpdate events, Combo_AfterUpdate event does calculation, like txtA*combo ( is user slect 5,then txtA*5,otherwise txtA...

HI, all Thanks so much for your great help! After enable the system objects, I saw the switchboard table,finally! Thanks ! Have a great weekend!

Hi, all Thanks so much for your great help! I can see it now after I enable the system tables. Have a nice weekend!

Hi, After open my database, the first thing is the switchboard, but I checked view: View>database objects> all the objects are disabled, could anyone tell me why and how to make them visible. I really want to edit the switchboard items table and add new forms to the application Thanks...

Sorry about that, it is too big. View>database objects> all the objects are disabled, could anyone tell me why and how to make them visible. Thanks for help.

Hi, Actually, the switchboard already has 9 items there, I want to add one more, but can not find switchboard items table, even the code has it. I just start VBA, If switchboard is not easy, then I want to go to a form ,add a button, then go to another form ,but do not know how to add a new...