Recent content by Bresart

I have solved it by making an SQL deletion instead of record deletion. Thanks.

It gives the same error in the line DoCmd.RunCommand acCmdDeleteRecord Thanks.

It deletes a record in the continuous subform (Secundario70 control), based on a table with cascade updating relationship with other table which the other subform is based on (the other subform: a simple one in which the image is displayed). Thanks.

Sorry, it's not a command button, it's an image in the main form that tries to delete a record in one of the subforms.

Thanks PHV. The code DoCmd.RunCommand acCmdDeleteRecord gives the same error.

The error line in the code is the second of these two lines: DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

Hi, i have a Db with DBPix for inserting and viewing images. The code for inserting an image is: strInputFileName = ahtCommonFileOpenSave(ahtOFN_FILEMUSTEXIST, _ "", strFilter, , ".jpg", "", "Imagen para '" & Me.link & "':", hwnd, True) [...]...

Thanks MajP. It works.

I see. Thanks Remou.

Thanks Remou. But i just need for the Access 2003 version, and in that link appear how to know the SP for Access 2000 and Access 2002 (XP) versions.

I have observed that the highlighted band works for the 4 first days (removing all the rest of textboxes). I don't know what that means. I also have tested putting the function = FillingCalendarBand(XXX;[FromDay];[FromMonth];[ToDay];[ToMonth];[ExactDay];[ExactMonth]) in another textbox...

Hi, i need to avoid a problem in Access 2003 without SP1 installed. I would need then to know if the PC in which DB is opened has or not SP 1 installed. I know the Access version can be known from code, is also possible to know which SP is installed? Thanks for any help given.

Thanks MajP. What you suggest would involve to change the function FillingCalendarBand, because it always gives a value so the conditional formatting would be applied always, for the 365 textboxes. However, i have tested that in one of the textboxes and no formatting is ever applied.

Thanks MajP. What is a highlighted band? Can you say me how to create it? This is the capture of my form (spanish): http://www.flickr.com/photos/_rufus_/3131344247/sizes/o/ from Access 2000. In newer Access versions the red zone (sowing period) is a continuous band instead of segments one, i...

Hi, i have a form with a continuous subform based on a sowing calendar table which has 6 fields: FromDay, FromMonth, ToDay and ToMonth, ExactDay, ExactMonth (that is, the sowing can be an exact day or in a short period of time). In the subform I want to represent where is the sowing moment into...