Search results

The refresh command is used on subform A. How can I use the save method instead of the refresh-Method so that the text box B in subform B changes immediately its calculated value after the data in text box A in subform A is entered?

I had a nicely working Access 2000 database. I used some refresh commands and I really tried to avoid stuff like requery and recalc since they move the cursor around (e.g. back to the first record). Everything worked perfectly. Now the problem: When I converted it to Access97, things got...

Actually, I refresh another subform which needs to be updated. I refresh this subform because I need to compare the textbox A in subform A with the textbox B in subform B. I need to have the refreshing effect. Any ideas?

The problem is the following: I have a subform. The subform includes 5 fields (text boxes). After an input in a field, I refresh the subform with the following code: Forms![frmArticle]![sbfrmDetails].Form.Refresh Strange enough that after the refresh the cursor goes back to the first field of...

Does anyone have any ideas. I am lost. Thanks a lot. Stefan

for your information. This problem does not appear in Access 2000. It appears only in Access 97. Maybe this is a help what could cause this problem to appear. Stefan.

Thanks for your posting. Unfortunately, your code has not resolved the problem. It's still there. Do you know why the subform is "cut" after the code above has been run through? What I would like is to avoid the cutting instead of reparing the cutting. Does anyone have any idea on this...

Hello Yes I have a SaveCommandButton with the following code: ___________________________ Private Sub cmdSave_Click() 'will return: ' -1 -> record saved ' 0 -> not saved, but go on ' 1 -> not saved, cancel Dim strMsg As String, ctl As Control Select Case MsgBox("Do you want to...

Please help me. I am lost on this. Any comments and ideas are appreciated.

The issue is the following: When I save a new record, the currently focused record moves up to the top of the subform space. The records before the currently focused record cannot be viewed anymore. This can then be undone by pressing twice {pgup}. By code I could do the following: After...

I have a subform which works fine in general. However, one current problem is the following: when I press the {enter} key or the {tab} key on the subform, Access often doesn't show anymore all records. The cursor then goes to the next record and some of the previous records are not visible...

Hi I have got a subform which works fine in general. However, one current disadvantage is the following: when I press the {enter} key or the {tab} key, Access often doesn't show anymore all records. It then goes to the next record and cuts some records above. Do you have any ideas how to...

Hi I created a nice database in Access 2000. Forms, reports, etc. work fine. I then converted the database to Access 97. The forms work fine as well. However, 1 report cannot be opened (not even in design view). Access says, that some signs are not recognized by Access (strange, since the...

Hi I created a nice database in Access 2000. Forms, reports, etc. work fine. I then converted the database to Access 97. The forms work fine as well. However, 1 report cannot be opened (not even in design view). Access says, that some signs are not recognized by Access (strange, since the...

I am trying to implement the following: a text box in a form should show show a full number (kind of round down). Example: 11.9 should be shown as 11 40.1 should be shown as 40 Can you help me on that? I tried already the "code" round(....,0). However, this seems not to be the solution for...

Hello I have the "mainform A" and the "subform B". When "mainform A" is being opened, the "subform B" is blank (as there are no records in subform B). However, when I finish to enter the first record in Mainfrom A I want to be able to enter data in subform B. However, this does not seem to be...

Thanks. I think that this is what I have been looking for. Stefan

Hello I tried your code. It partly works. However, since the save command does no "recalc" the whole screen, my previous coding is not working well. How can I achieve the recalc function (after update event) without jumping back to the first record ? Regards, Stefan

Thank you both. I'll give the "CmdSaveRecord" a try. Stefan

Hello I have the "subform B" in the "mainform A". When users work in the "subform B" (e.g. entering or changing data), the cursor always goes back to the first record of "Subform B" after every amendment of data. why is that? Stefan