Search results for query: *

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...

I've put in a new thread the problem 2.

Thanks Remou RoyVidar. I have compacted & repaired, decompiled, imported into a new database, followed the steps in the link http://www.granite.ab.ca/access/decompile.htm, and i have left two problems: 1.- Which i have explained at the beginning of the thread: DoCmd.OutputTo doesn't work. I...

Thanks PHV RoyVidar. Replacing the constant with it's literal value didn't work. Perhaps there's an instalation problem like you said, because the described one isn't the only i am having: a form with many controls hangs up with the status bar showing 'Calculating...', and some times the error...

PHV, yes, i have made a compilation in Access 2002. Thanks.

Thanks Remou. No, there's no reference marked missing. The only three references that my project use are: - Visual Basic for Applications - Microsoft Access XX.X Object Library - Microsoft ActiveX Data Objects 2.1 Library Is it possible that in different pcs or in different Access versions...