Search results

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...

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...

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...

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...

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...

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...

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...

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...

In my custom ribbon I use the getLabel function to write data to a button lable. Sub GetLabel(control As IRibbonControl, ByRef label) ' Callbackname in XML File "getLabel" ' To set the property "label" to a Ribbon Control Select Case control.ID Case "Btn_25" label =...

Hi there, I have a split database. On the backend there is a linked table with all the dates of the public holidays occuring in the next few years. The table is called "ArbFreieTage" and the column with the dates is called "Datum". When I open the form "Außenpforte" I would like to check if...