Search results

Rain Lover Just re reading the posts, can you advise where the Lock File is located to view, as you suggested? Cant seem to find it.

Hi Are you able to explain a bit more, I am not sure what you mean or how to do this?

Hi Doc Man I understand your first point, as I have all my forms opening from queries. I dont understand your second point though. How do you do this? I think my queries are optomistic locked but I would have to double check. It sounds like it might help. Could you explain more on 'one query...

Yes, you were right. I totally forgot that I had a report loading at the start. I have switched this off and ran the performance analyzer, applied the suggestions and this is now running much quicker. thanks to all for your help and suggestions

I will do a test on disabling it to see if it makes any difference. It is enabled because the database if used by people in different parts of the building and we experience problems with people locking a field and leaving there desk for long period or forgetting they are in the record, thus...

Thanks dave, I will give that a try too

It will do a test

I do have a code which logs users on and off the database and shows who is logged in. I found it on here called User Logging.mdb I just imported the table, forms and module into my database.

I am part of the team that uses the database. I was told the back should sit on a shared server. Sorry, I dont know what you mean about moving or copy the back end? I am one of the muliple users accessing the database. There are about 8 of us using the database. Just going to check for...

I regularly 'Compact and Repair' the back end, once per month and do a back up. I made an accde file of the front end to distribute which is 8.96mb. I saw advice on not performing a 'Compact and Repair' on the front end whe I originally split it. So before I split the database, I did a...

ok, the folders may be burried deep. Very difficult as we have a large shared server with team folders, certain folder with access restrictions. So it looks like this S:\Services\Our Team Name\BOB Database\Split Database\Front End S:\Services\Our Team Name\BOB Database\Split Database\Back End...

oh, also I made the front end an accde file before copy it for each user. The front and back end are only 250mb each. It is not a big database. Is there anything else I can tell you to help? thanks

Hi Rain I dont know why it takes so long. I have read other posts of this happening to other people but I can't seem to find an answer. The split database takes approx 2 - 2 1/2 minutes to load. The front and back end sits on a shared server. Each user has their own copy of the front end. I...

Hi I have a split database with multiple users. Since I split the database, it runs slower than the unsplit version. I understand this happens. I would like to have a message pop up when the database is loading. It takes approx 2 mins to load. Users get impatient and start clicking. So, I...

This one DoCmd.OpenForm stDocName, , , stLinkCriteria

Wow, it worked using just this code Private Sub SearchResults_DblClick(Cancel As Integer) DoCmd.OpenForm "frmResourcesbyStepOneRecord", , , "Title='" & Me.SearchResults & "'" End Sub thanks!

Hi, I too would like to select the record and open another form to that record. I have modified the code above to my form info but it get an error message 3075 missing syntax. I can't see where? My code is (which I tried in click and dbl click event) Private Sub...

I found this database on this site (in sample databases) and it does what I have been looking for. The only problem I have is that when I type a lower case 'i' in the 'search for' box, I get an error 2110? If I use an upper case 'L', it doesnt happen. I can't figure out why this is? The creater...

I followed your instructions and the code for my fields is as follows. It exports and opens the file but it still does not exclude the columns and it locks up the database and I have to force close it and reopen to use the database? Not sure why this is or why it does not work? Private Sub...

I did set up a query to include only the columns I wanted to export and that worked fine but it output all the data and not the data in the filtered on a search in the datasheet. I dont know how to do that bit? I don't know how to set the query so that it exports the filtered data in the...