Search results

Hi Does anyone have any idea how to write in VBA a procedure to highlight and then delete a record selected by the user in a subform. I used CurrentRecord property but did not go really far. any suggestions thanks

Thanks for your feedbacks, I will try to be more precise and concise in the future.

It is true I got answers for my initial questions, but it happened that the last three were unanswered when I wrote this. In a meantime I got an answer for my third question Pb in a BeforeUpdate Event. I am not trying to tell off anybody, I was simply wondering why, if it was due to my...

thanks Peter for your answer, but my problem remains. What I forgot to say is that this code is in the form_BeforeUpdate and the message comes up when I close the form, Access tries to save the record after the BeforeUpdate procedure and before the close event, thing I don't want. If the...

This is the third question that I ask and that is the third time I don't get any answer. Please let me know why? are my queries not clear? or you don't know the answer? It would be nice to have just an answer saying anything! thank you

Hello everybody I wrote a validation test in my beforeUpdate Event which DOES NOT WORK!!!! The user is prompted to enter a number if he leaves a textbox empty and I want the beforeUpdate event to be cancelled and the user be able to make its changes. However before the user can do anything...

Hi everyone I don't have a clue what's going on with my form and subform. In my form "Dataset Update" there is a subform "SirDatabase subform" which show all the manipulations done to one dataset. For each manipulation the dataset has a new update level. My field update level in my subform has...

Hi all Here is my problem: I have a form containing a subform showing dataset delivered monthly. The user selects the name of a dataset in a combo box and can view automatically in the subform the changes that was done to the dataset overtime. The subform's source object is a form called...

It is me again! I don't know what I have done with one of my form, but when I want to add a new record I have the following message: You can't go to the specified record, you might be at the end of the recordset. Previously it did work perfectly, any ideas what I might have done and especially...

I have added a subform to my form based on my query. I have tried to write in VBA nameofmysubform.Refresh and it does not do anything. Have missed something in the code?

I have one form used as a search engine. On the form the user enters what he wants to search for: for example he wants the information about the CD sent in the year 1992, in the month May,.......those are the criteria for the search. Then I press a command which does the search. The button runs...