Combining two dates fields into single appointment field

Today I have Start and End date fields and I'd like to leverage the appointment field so I need to write a script that will combine them. However the format to do for the appointment field hasn't…

• Answered

How to clear/null a reference combo box

I've created a combo box/reference that will allow me to create tasks for a record from a list of selections. The field in the main record "Project" has a combo box called "Tasks to Apply" and when a…

• Answered

Two condition nested If not working

I am trying to color a field when days overdue (delta_days) is the below however with the below code, I get either red or green, never Yellow. The second else/if should be skipped when the number for…

• Answered

Open view on startup

Is there a way when the Database is opened (OnPrem) to go to a view so it’s always what the user sees when they start?

• Answered

Fields that appear in Master Calendar view

I have Date fields with Show in Calendar = Yes, and I am trying to figure out which fields or more to the point, how to control which fields show up since the calendar item has limited space.…

Calendar missing some dates

I've got a number of Data Fields in my various tables that have Show in Calendar set to Yes however they don't appear in the Calendar. I'm lost as to why since I assume that flag alone should have…

• Answered

Gantt Date Format using European and not US

Even though the date field formats are done in US, when I created a view for Gantt, the top timeline dates are formatted for Europe (MM/DD/YYYY). I don't see a way to change that since it would need…

Ability to make field layout in form "static"

I've been building a number of forms for a new database and my experience mostly comes from using MS Access. When I add fields to a form, they automatically shift their locations depending on what…

Sum related field with specific criteria issue

I have a table called Projects with a reference to a table called Proposals, and there can be multiple Proposals per Project. Within Proposals I have two fields;…

Clear out Dynamic Multiple Choices

As I've been learning Multiple Choices (Dynamic) I've made a variety of changes, and not that I've settled on the proper approach the target record seems to have recorded the previous choices and now…

Searching Multiple Choice Dynamic Fields

I am using the Multiple Choice Dynamic Field and it is working great from a selection standpoint. However I want to be able to list, search or filter based upon records that have certain choices…