Search results

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.

I have updated a form of mine in a database. In design view everything is how I want it. Whenever I switch into the form view, none of the new labels or check boxes I have inserted are in the position that I have placed them. They are either in another location on the form or are not being...

Thank you so much. This is exactly what I was looking for,

Hi there, I have a main form (Daten) with a sub form (BewerberUF) in my database. The sub form is shown as a table. In the sub form one of the columns ("Ausgewählt") is made up of checkboxes. Is there a way (possibly with a command button) to loop through one of the columns and set all the...

Thank you for the many tips. I finally got it to work by inserting the code If Len(Me.txtSuchen) <> 10 Then Exit Sub into the module. Thanks again.

I have a Date Picker on my form to jump to the record that corresponds to the date in the Date Picker using the change event As long as I select the date with the date picker, everything is Ok. If I wish to select a date by typing it in manually, I get an error message because the change event...