Recent content by MrDeveloper

Phew! I did some further investigation and realised that I could not avoid how the calendar operates, but I *could* change how the trigger deals with it. Modified the code to detect a change by the calendar and prevented the insert operation from functioning - thereby solving the original...

Hi, I have a row of text-boxes in a form linked to columns in the database (with the property of the data block set to display multiple rows). One of the text-boxes uses a calendar pop-up (displayed by clicking on a button associated with that text-box) to add in a chosen date. I can enter a...

Hi, thank you both for your suggestions. I have spent some time trying to get to the bottom of what is going on and have now made a bit more progress. Ran lsnrctl status (or any other lsnrctl command) and I get a series of TNS listener errors (TNS-00511: No Listener), the last of which in every...

Hi, I have tried to stop it but it fails to stop (Services => Stop process). I have a feeling once I stop the service, I can then delete that file and the Listener might be happier writing to a smaller log-file. If kill does not work, are there any other solutions to getting rid of a service...

Hi, I have a windows 2k server with 9i DB and 9i OAS installed. Has been working fine with several re-boots in its lifetime. Today, however, after a reboot the lsnrctl start command I have in a self-developed oracle start-up batch file fails. Even running the command manually at the CMD prompt...

CMP: Thanks again for your useful post regarding this issue and including the code. I will have a look and try and implement it. Regarding the issue of using 2002 forms, I think I will assume the possibility of corruption is minimal and perhaps no need to re-build them in 2000 format. Any...

CautionMP: That was a big help to confirm those issues actually. I am going through an update of the Jet DB engines as well but it is useful to hear this has helped in other situations. May I ask what the contents were of the autoexec macro? That would be most helpful. The workgroup file was...

Hi, I have read that loading an Access 2002 application from Access 2000 is a possible cause of corruption and therefore in a shared-user environment (where multiple versions of Access exist) it is best to create the application at the lowest version level (e.g. build a 2000 app so both 2000 and...

About a week prior to this happening the back-end was compacted/repaired. Could it require compacting on a weekly basis? MrD.

Has anyone had a problem with a form loading but the text-boxes and buttons (well just about every element in the form) not showing at all when the form loads? The form runs as part of an MDE with the back-end MDB on a server. Form has loaded just fine in the past, only recently has decided to...

Hi Golom, Many thanks for your response. I open the pop-up form using the standard button code Access gives you. i.e. I dropped a button on the screen and it requested which form to open and on what criteria to use to open the form and subsequent table: Private Sub buttRefs2_Click() On Error...

Hi, I have started to come across the error message "Index not found" when accessing a form. I have a main form which display a list of details about a person, and then a button that links to a pop-up form which gets related information to that person from a second table (i.e. a second table...

Sorry - detail I forgot: The application is multi-user (split front-end/back-end) for lots of people on a network. The majority don't get the error when accessing the form except 2 users - although they use Access 2002 and this is an Access 2000 application, but I don't believe this would cause...

Hi, I have started to come across the error message "Index not found" when accessing a form. I have a main form which display a list of details about a person, and then a button that links to a pop-up form which gets related information to that person from a second table (i.e. a second table...

Hi, Turning Autocorrect off was 4th the list of things I was going to try, with the original posting being a confirmation of whether anything else I should try just in case before I tackle the issue. Made an impressive difference, yes! BNPMike: I think the reason why performance is impacted is...