End of support for Access 2016 and Access 2019 nears
Your product will still work, but when Microsoft says a product has reached "end of support", it means the product will no longer receive: Security updates Non-security updates Bug fixes New features Assisted support (free or paid) What this means for Access users: No more updates: Customers will not receive any new builds, patches, or improvements—even if vulnerabilities are discovered. No support: Microsoft will no longer provide technical support or troubleshooting assistance. Increased risk: Continued use of unsupported software can expose systems to security threats and compliance issues. Migration encouraged: Customers are advised to upgrade to a supported version or product to maintain security and functionality. We strongly encourage all Access users with perpetual licenses to upgrade to a Microsoft 365 Apps subscription. Subscription users get more out of the same Office desktop apps with artificial intelligence (AI) backed design ideas and analytic insights, rich contents and templates, cloud powered connected experiences and more. They also enjoy additional benefits beyond capabilities in Office apps, such as 1TB storage, Office on multiple devices and mobile, Microsoft Family Safey app, etc. I've noticed many perpetual users are "subscription adverse." I hear "I've used the desktop version forever and prefer not to switch to the cloud." Migrating to subscription does not mean that you'll get a different version of Access. You'll still get the desktop version you know and love, plus all the premium Office features a subscription provides. My favorites are Editor in Word, Money in Excel, and all the extra OneDrive storage. Check with Microsoft Sales Support to see if you're eligible for upgrade incentives depending on your region or organization type. (Yes, we know the Access icon does not appear with the other Office apps. You'll find it directly below the icons in the alphabetized apps list.) Sources: End of support for Office 2016 and 2019 Overview - Product End of Support and Retirements - Microsoft Lifecycle Access 2016 - Microsoft Lifecycle Access 2019 - Microsoft Lifecycle
Probleme mit Access 2016, Application Icon
Hallo Community, seit Anfang Juni habe ich ein Problem mit einem Access Frontend das in China unter Access 2016 Englisch und Windows 10 (Deutsch) läuft, Backend ist SQLServer 2014. Wenn ich in Optionen einen Link zu einem Application Icon verwende und diesen mit einem Häkchen unter "Use as Form and Report Icon" setze dann bricht die Datenbank beim Öffnen eines Formulars mit der Meldung "..... nicht genügend Memory space ....". Die Meldung ist Unfug, es gibt genügend Speicherplatz. Durch Zufall habe ich herausgefunden, dass es an diesem Häkchen liegt. Häkchen gesetzt und Abbruch, kein Häkchen gesetzt uns alles läuft problemlos. Es gab auch Anfang Juni ein Update für Windows 10 in China. Das Problem existiert erst seit kurzem, seit Anfang Juni, davor gab es nie ein Problem mit diesem Application Icon. Das Problem tritt auch nur auf Rechnern auf die unter Windows 10 laufen, bei Windows 7 gibt es das Problem nicht. Auf meinem Rechner, Windows 10 (Deutsch) und Access 2016 (Englisch) gibt es keine Probleme, gestern, 14.Juni habe ich eine neues Windows update installiert, keine Probleme mit der Datenbank. Hat jemand eine Idee? Gibt es Berichte zu Windows 10 update Problemen? Gruss und Dank für Antworten. Peter
Rating system problem
To start out with, this form is used to rate things using a five-star method. I have a combo box that a user can select a category on which they wish to rate the transaction on. Once they select one and decide to add it, I have VBA that adds that selected category to the database and requeries a subform. The subform is linked to the overall record. The entry is listed in the subform and has 5 empty stars and the user can click on the star and it, as well as the previous stars, get replaced with a filled star. The images are merely placeholders and the actual rating, 1 to 5, is stored as an integer. Everything works to this point. My issue is, when the user tries to select a star, all the ratings for all the other categories are also mirrored. I am sure it is something very simple I am overlooking but I just can't put my finger on the issue. As the 5 placeholders are individually named but duplicated for each record, my code does not know specifically which entry it should stick to. Can anyone help me on this; point me to a tutorial online or help anything to help rattle my brain My continuous form looks like : This is subform in the actual form with the Rating category combobox. The Overall Rating works like it should. Any help and guidance is greatly appriciatedItem with Access 2016, query
Any idea about this? As you can see I choose a query (campi incrociati, in italian) and the wizard show only the first columm inside, instead of the tree of these. I reinstalled yesterday the Access version (2016) without fixing it. I work with windows 10 how can I fix it Thanks a lot MarcelloEmail merge error - 3048
Hi, Some code was written in the past that worked fine until this last week or so then we get error 3048. As per a lot of suggestions on this forum we have made the location of both the client end database and the root database on the network trusted, but still get this error. As the code is a few years old I thought I would post to see if anyone knows of improvements we could make to it. It is to send statements to different contacts, here is the code: Private Sub Command62_Click() Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("qry_mass_emails") Do Until rst.EOF Me.unit_sales_unit_no_sel.value = rst("unit_no") If DCount("id", "tbl_trans", "unit_no=" & Me.unit_sales_unit_no_sel.value & " AND flag=False AND contra=False") > 0 Then Call sndrpt_unit_sales2 Else Call sndrpt_unit_sales3 'DoCmd.SendObject , , , DLookup("email", "tbl_tenants", "id=" & DLookup("tenant", "tbl_units", "unit_no=" & Me.unit_sales_unit_no_sel)), , , "Sales Report", "Sorry, you have no sales transactions to report on." & Chr(10) & Chr(10) & "Regards" & Chr(10) & "Astra Antiques", False End If rst.MoveNext Loop rst.Close DoCmd.Close DoCmd.OpenForm "frm_menu_reports", , , stLinkCriteria MsgBox "Mass E-Mails Sent" End Sub Thanks for your suggestions. KatherineHaving a date issue in a query
Got a odd issue. What I'm trying to accomplish is to have the user enter the date from what's printed from the text column PaySchedule in this example every 15th. They would enter whatever date the Payment Date was i.e. 1/6/2022. Then it would subtract the date they paid from the due date, the PayScheduleDate column. For whatever reason it's not giving the correct numbers. If I subtract 6 days from the Payment Date it should be 0 days but it's showing 31. I tried adding 1 to the query and that didn't work either. Not sure what the issue is. I formatted the DateStatus field to only show "dd" not sure if that has anything to do with the issue. I'm stuck. Let me know if anyone has any suggestions for this.
Access - Template Contacts - "Search Not Picking Up words"
Hello, first time using Access. I was looking online for what is a good(free) program for our office contacts. We have clients, trades, supplies, designer, contractors, etc. so I came across Access! It's been great! I've been able to start inputting our contacts info and have been able to add more fields. One of my co-workers came over and asked if we can search for lets say a projects name and then all the contacts related to that project will show. So I typed in the Search box and for some words or names nothing appeared. I tried other words and some worked and some didn't. I've tried googling, talked to on chat and phone call with Microsoft, one of them lead me to here and hoping someone knows what I'm talking about. I really like the options Access Contacts template is providing and I don't want to have to look at another program.
