Search results

Endre, Well, it worked like a charm! The difference in performance is massive - I implemented the changes everywhere that you suggested i.e. whenever suspect details are changed, and it no longer takes forever and a day to open the case list form! I knew that there would be a solution to this...

Endre, I've uploaded the database to here: http://rapidshare.com/files/273838926/GKCT.zip.html Username: Paul Password: whiteboard Be sure to change the locations in the shortcut, to hold down Shift when opening and to update the linked tables - of course, you knew that already... The...

Hi Endre, Thanks a million for getting back to me on this one. Yes, it sounds like this could potentially be the solution that I'm looking for. I can somewhat follow your suggestion, although must confess that I am an Access novice in many respects. Would it be reasonable to upload my...

Hi Endre, Thanks for your response. Unfortunately, I think that the limitations of your method are too restrictive. I anticipate that the number of records is going to reach four figures within a few months, at which point the method would fail. I am relatively happy with how my current method...

Hi, I've got a problem with a query that concatenates records. The function that I've used is Allen Browne's (http://allenbrowne.com/func-concat.html). The function works fine - although it is painfully slow. I've only got 75 records in my test data, and I'm looking at a good couple of minutes...

The Eureka moment - it was an unbound text box using a DMAX expression that was causing the problem. RG - this is in the top right corner of the Cases form. I read somewhere else about someone that had a similar problem and put it down to an unbound text box. Lo, I removed the text box from mine...

RG, An interesting development today - when I took the original database that I was working on (very first backup copy - about 90% of the tables and 5 forms, including the Cases form) and tried it out over the network, I had no problems at all. Of course, when I tried my latest version again I...

RG - yes, that's exactly when the problem occurs. The fact that you're not encountering the same problem suggests that it's a network issue. Have you made no changes at all? (other than putting the files close to the root on the network) I will endeavour to do some more testing today. I will...

Hi RG, Thanks a massive amount for taking a look at this for me, I really appreciate your time. The problem form is the frm_Cases. When a suspect is selected on the frm_CS_and_Suspects_Subform, the frm_SO_and_Offences_Subform shows the offences for that suspect in this case (for the benefit of...

Thanks for the responses. Alas, the file is too big to attach! So I've uploaded the .zip file to http://rapidshare.com/files/262890029/New_Folder.zip.html If you do get a chance to take a look, that would be fantastic. As I mentioned, it runs ok when the back and front end are on the local...

Hi RuralGuy, thanks for your reply. Well, I tried a decompile today, followed by the compiling of my code and compacting and repairing a few times, but that didn't appear to solve the problem. There are no timer events running anywhere I have been tearing my hair out all day with this, but I...

Hi, I've searched the forum thoroughly but can't find anyone else that's experienced a similar problem. I have a database split into FE/BE with the BE stored on a network drive and the FE on the local hard disk. My problem is that when using one of the forms (which happens to be the busiest...