Search results

Thanks for your help. If the issue arises again then I will follow your advise and make all extensions ACCDBs. Is there a simple way to export all objects in to a new file?

Thanks all for your help. The issue has occurred again this morning. It is becoming a running theme that first thing in the morning or after a weekend, the error message is popping up. I have checked the user log, and the majority of users remained logged in overnight, which I've read somewhere...

I have gone through and exported all of the tables one-by-one in to a new access database. Do I just replace and rename this new database with the backend MDB file that is shared between all of the users? Thanks for your reply

Yes this is what I'm having to do at the moment. My fear is however, if this continues to occur, that when I am away on holiday or taking annual leave that the team may not be confident in doing this, although it is straight forward. I am going to write up a quick manual to help if this occurs...

Thanks for your reply. If I import all objects in to a new database, will this be able to identify any corrupt elements? Or do you mean import the objects so that I have a copy that I can import back in to the earlier (hopefully non-corrupt) version of the backend? I hope I've understood you...

Hi there. I have recently taken over the management of my department's access database. I work in a Hospital and the database is used mainly to keep a record of any medical equipment that we own and also any repair or service that is carried out on it. Each user has a copy of the front end...

Fantastic, that works perfectly. Thanks.

Hi Mike, The database is used in a hospital. So in this case we have medical equipment assigned a 5 digit Asset Number. Some medical systems, will have several assets on the one system. I want to be able to assign the medical system a GroupID so that the individual assets can be easily found...

Thanks for your reply. The reason I went for a text box was because I want users to be able to edit the GroupID and create new GroupID values just simply by typing in to the text box. I then created the button to the right of it to run the query below. When I run this query it brings up all...

I have a field within a table called GroupID. Currently it has the values TEST01, TEST02 and TEST 03. I want to be able to filter the form/records by the GroupID that is within the box on that given record. So in the above example, if I was to click the button, I am hoping it will filter the...

That's great, thanks both for your help. I have taken over the database from a retired member of staff. He wrote some VBA code to remove any asterisks from any scanned values, so having the asterisks in the barcode is a quick workaround for now. I have now a textbox displaying the DepartID and...

I work in a hospital and have a list of departments within my database. Each department is designated an ID number that increments with every new record. For example WARD 1A is given the number 1. Ward 1B is given the number 2. And so on. I then have a text box in my form that is linked to the...