Recent content by liborp

Welll the problem was that I had resume on main form of the records. When I removed this subform from main form then I was able to remove record. Ok I can delete record but I need this summary subform on main form. How can do that? I mean show subform and delete record in other subform?

Thanks for response. Yes I'm trying to remove actual opened record. Should be done like this way?

Hi, I'm trying remove actual record by this VB code: Private Sub Command41_Click() On Error GoTo Err_EditDelBox_Click Dim rs As Recordset Dim strBMark As String Set rs = Forms!Media.Form.RecordsetClone With rs Do Until .EOF .Delete .MoveNext Loop End With...

Thank you pbaldy it is exactly what I need. But now I have probably simmilar problem. Same situation realionship one-to-one ( tables User and UserDetails). I have form, whichhas some field from User and some from UserDetails. When I try to save this form error appear: ou cannot add or change a...

Hi there! I'm quite new in Access and I faceing this problem. I have two tables A and B with relationship one-to-one. I would like to create button and put it on form of table A which has onClick event some trigger that open form of table B but with relevant record. I mean A.id = B.id. How can...

Thanks for response! Because I want to have all data on one page (form). Well as I mentioned I'm pretty new in access forms. But when I put subform on main page and then I check Data source of subform, there is some select query anyway. So what is difference? So shall I use subforms, don't I...

Hi there, I'm litte bit a greenhorn of Access forms. I have 7 tables one of them "Movie" is the main. The remain ones are for details (Subtitle, MovieTrailer,ScreenShot...). These remain tables have relationships many-to-one to the Movie. I try to create main form of movie with six subforms...