SharePoint 2013 "open with access" grayed out
In any SharePoint 2013 list the "open with access" grayed out for some computers and others it works. The same users with the same rights are involved here. Running Office 365 with Access on two computers. One has 32-bit office, the other 64-bit office. The 64-bit office works works the other does not. Both are Windows 10 latest office and windows patches.
Populate Access ListBox with Distinct/Unique Values
I'm a CS student in my 4th year, my professor wont grade my assignment because i didn't populate a ListBox correctly (I got a 10/200 but i have an option to turn in 1 revision). The ListBox named "lstCateName" displays a property type (castle, villa, manor) from a table named "tblProperty" on a form called "frmType". My problem is with getting the ListBox to display only one of each Property type (Only 3 options instead of many same repeating options like in the image below) I need it to only display 3 options, "castle", "villa", and "manor". I have looked endlessly for the solution to no avail. There are some tutorials out there that focus on Excel and use VBA which i am not familiar with nor do i know how to implement into an Access Database. [edit] This is what i currently have in the property sheet for the ListBox under the Row Source SELECT DISTINCT tblProperty.PropertyID, tblProperty.PropertyType FROM tblProperty ORDER BY tblProperty.[PropertyType]; The PropertyID property is hidden form what i recall.
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.
Having 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.Item 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 Marcello
