Search results

Hi there, I have 6 buttons which are label controls. Ideally I want to set a condition that unless the label called 'New' is clicked, the label called 'Find Student' is greyed out and not clickable. Any ideas how to do this with labels as opposed to buttons?

Thanks for that. One user has mentioned that when the database is inactive for longer than 10 minutes and they go to use it again, an error message appears in the form of ERROR ##. Is it possible that the reason for this is also because it is stored on the networked drive? In simple terms...

Thanks for this, I never thought about the fact that Access is run from the C drive. Your explanation shows how the data could become corrupted having to go through so many connections. Just one question about your solution to my problem, I have all the frontends on the network drive at the...

All stored on the shared server.

Hi guys, I have a database that I designed in access 2007. I split the database and kept the backend on a shared network drive. I created 10 copies of the frontend to deploy to 10 users. This worked fine to begin with but now some users are getting backup copies being created on opening the...

Thanks that worked!

The query is in the database attached. is called CountStudents

Hi there, I have three tables with the information to be able to get a count of how many students that each tutor has seen but everything I have tried using the cross tab type of query and putting a count on studentID and group by tutor name but this seems to count the students the same for...

Hi there, I developed a database for some users and one of the users has recently got the following message on opening: 'The document ASK_Database_v7_temp.accdb caused a serious error the last time it was opened. Would you like to continue opening it?' (options: yes or no) When she clicked...

Sorry I couldn't work out how the search would work without the findfirst code so this was the confusion. Thanks alot for your help and patience :)

Attached. Thanks :)

Hi guys, I still haven't managed to fix this form. Has anyone got any ideas? In the original search form, I had a search filter on the surname but for uniqueness it needs to be student ID. Thanks for any replies.

Do you mean take out all of the code from the after update section?

Thanks for replying. I have tried removing the brackets and then performing the search. The results appear but when I click on any of the results I get the error message '[studentid] cannot be found'. Then the form opens with a blank record and not the one I clicked.

Hi there, In my search form, I can type in a surname or firstname of a student and then any matches appear in a listbox. I have a double-click method which should allow me to double-click on a listbox item and that unique record opens. This works sometimes but in situations where there are two...

Any ideas anyone please? :)

Hi there, I am using the following code to allow users to enter partial first names, surnames or student IDs and search for any matches in the database. These matches appear in a listbox and then the user should be able to click on any of those matches that that particular match record should...

Hi Mstef, Thanks for your efforts but unfortunately this type of solution is not suitable for the amount of information that users will be dealing with. Having the search facility on the actual record form would make the performance for the user very slow given that on loading the form all...

Has anyone else got any ideas? :)

Hi, Thanks for that, had a look and made some changes to my code to look at the StudentID as opposed to the surname but the problem I am having now is when the I click on a search result it says the studentID and then brings up a parameter box. I have attached it to show you what I mean,