Recent content by Mister-B

This database is used in a hospital comprising of 5 buildings each comprising of 1 - 4 floors (stations). Each station is crewed by up to 3 people and each station has its own table in the database and the structure of these tables are mostly identical. The query is supposed to go through all...

Hi, is there any way to speed this query up? It takes a long time to run and is requeried fairly regularly. SELECT Startup.Datum, Startup.ID, Startup.ArbFrei, Haus1_EG.FD1, Haus1_EG.FD2, Haus1_EG.FD3, Haus1_1OG.FD1, Haus1_1OG.FD2, Haus1_1OG.FD3, Haus1_2OG.FD1, Haus1_2OG.FD2, Haus1_2OG.FD3...

I hope you'reright. I just learned the other day that Microsoft Publisher will cease to work after October 2026. There will be no alternative.

That was it, thank you so much. I was using normal quotation marks. Learned something new again today.

Nope, it's just text that has been manually entered.

Hi there, I have a database that handles all the administration of training courses offered in our establishment. I have a query that is supposed to find all the courses that are offered by a particular school this year but exclude all the Microsoft courses. Here's the query but it returns...

Hi, thanks for your input. Not what I was originally looking for but my research seems to suggest that it is not possible to manipulate this part of the 365 backstage view.

Hey all, I've just moved up from Access 2016 to Access 365 Apps for Enterprise. Unfortunately some of the XML Backstage commands that worked on 2016 no longer work on 365. I would especially like to hide the list of recently opened databases and favourites. The old command line <tab...

Thanks GPGeorge. I never knew that was possible. That's exactly what i needed.

Hello all, I have a user form that shows, among a lot of other information, the last 15 records of the table that were added. To do that I found these snippets of SQL that work: SELECT TOP 15 Daten.FoBiID, Daten.Jahr, Daten.Fortbildung, Daten.Von1, Daten.Bis1, Daten.Kennziffer...

Thanks for all the input guys. MarkKs information about the optional parameter for OutlookItem.Display is just the ticket and solves my problem. Thanks again.

Actually that is actually what I am doing, but the message appears before I have finished tending to Outlook.

I have finally gotten my code to work. From my form I create an outlook appointment from data on the form and send it to recipients that are also on the form. After generation the appointment is displayed in Outlook and I check for errors or may add notes manually. After all is OK I send the...

Horizontal: left Vertical: Upper This is the same as with all controls on the form. I have never messed with anchoring.

Thanks for the suggestions. I have not changed the design of the form. All controls are visible and they all have the sam anchor settings.