Search results for query: *

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

UPDATE! For the benefit of people reading this wondering about what worked / did not work - an amazing reduction in the initial delay being reported was achieved purely by switching 'Track Name AutoCorrect info' off (Tools => Options). This actually removed any delays when accessing the...

hi dilettante, The history of the application is that it was run as a single MDB on the file-server with multiple users across the network (LAN and WAN) accessing it via a network drive. I believe this meant both forms and data were being sent across the network to each client PC (about 8-10...

These are interesting points about index ranking - will bear this in mind when I write queries in future. In this instance the table has indexes on any fields brought back by the queries, and these fields are at the top of the query select list. willir - thanks for your list of hints. The...

Thank you both for your replies. Will now try the suggestion and re-install it as uncompiled back-end and front-end and test the record-retrieval after this. Will post to the thread to describe which change helped the most as I have a feeling this is a common problem experienced by developers...

Hi, I did indeed compile it as well as split it, whereas prior to the split it was an uncompiled (MDB) system with both forms, queries and tables in one file sitting on the server. The reasoning behind compiling was for security of the forms and to prevent people modifying their copy of the...