Search results

Thanks a lot, will try in the morning! Have to leave now.

Hi there, I do save the record first -I've tried now putting the requery in the "on Current Event" of the sub form - it works as soon as I leave the record (by enter or tab), but not when I docmd.gotorecord, nextrec in the procedure in the "on delete". It looks a bit untidy when I have to...

In a sub form I don't want any records to be physically deleted to maintain data integrity (foreign key) therefore I have a field "deleted" (boolean) in the subfrom. In the "on delete" of the subform, I set the "deleted" field to yes, and docmd cancel Event, to stop the record being deleted...

Thanks a million!!

Hi all, I am having a problem opening a form and displaying certain LinkCriteria. I need to combine and and/or clause. I need to select all records where the patient Nr is the same (me.patnr) and the category is either "P" or "S" I've tried different variations but cannot get it to select the...

Help! I need somebody! Background: I have 4 different .mdb on my system, running Office 2000. In all of these I have built menu`s called "FormMenu". I bought and loaded Office 2007. As these Menu now show as "add-Ins" and cannot be changed, updated in the normal way in Access 2000 - I...

Thanks so much for the answers. The problem was as you say, a variable that was not set to nothing. It took time and patience, but I found it. Thanks for the code anyway... a handy quick fix to know !

Thanks for the reply Peter. I've got it working now!

Hi again, I'm getting there.. the line I need is Application.CommandBars("Formmenu").Controls(1).Enabled = False Now I need to take this one step further... This disables the main menu point, but how do I refer to the "sub menu options" e.g. I dan't want to disable the main option "File"...

Hi there, Can anyone tell me if (and how!) I can set entries in a customized menu bar to "enabled" true or false. Users login to the DB with a password, and I would like certain menu items dissabled for certain users. I've been trying along these lines but no joy yet! Set menubar =...

Hi tehere - thanks a lot .. this looks like the solution I've been looking for. Will test after Christmas.. off on holiday in South Africa till the 19 Jan! Merry christmas!

Thanks Rich!

Hi there, I'd like to write a function that puts the visble property of all loaded forms to False when a report is opened (on the on open of all my reports) and sets the property back to visible=true when the report is closed (the on close of all reports) Can anyone help me here? Thanks...

Hi again anf thanks for all thhe replies and suggestions! soo.......... this is what happens.. I assumed that when a main form with different subforms is opened, the on open of the main form is executed before any sub form routines. This is incorrect. I stripped the form piece by piece until I...

Hi there, I'm still wrestling with this problem! I have one very strange occuence that I think may be responsible for the crash. On the main form, I have several sub forms. When I open the main form, even before the "on open" event of the form is started, the "on enter" event of one of the...

Hi Doc, I found and looked at the event viewer as you suggested, but it gives basically the same info that it gives at crash time namely. Faulting application msaccess.exe, version 10.0.4302.0, faulting module msjtes40.dll, version 4.0.8618.0, fault address 0x00008b6a. After reinstalling...

Thanks for both the replies! This I must admit is the strangest thing I've had in 15 years of programming! This problem was reported by one of my customers, and my first thought was of course "funny data" - since then more and more customers reported the error. I immediately asked to have the...

Thanks anywy Ron. Have a good day!

hi there, Am testing on my own machine at home - no server involved. Both Back-end and front end on local D:\ drive. ich bin echt verzweifelt!

Hi Rak, Thanks - have done that along with the others that the Knowledge Base recommends msjter40.dll, msjet40.dll.... it still crashes