Search results

You might be interested in this Zoom meeting of the Access Lunchtime user group. Update on calling Microsoft Graph API from VBA with Maria Barnes

You can create a stacked bar chart like this with no VBA: I have a table of values with a column for each of the colors. Create a query based on the following SQL: SELECT tblForGraph.catName, IIf([catValue]<50,[CatValue],0) AS Green, IIf([catValue] Between 50 And 90,[CatValue],0) AS...

I recommend you handle this by putting your intellectual talents into some other venture.

My previous post still applies. Good luck.

fldRecordingID is different from fldRecording.

The visit record can have a field for the ExpenseID. Honestly, I think you are wasting your time attempting to build an unmaintainable application. Healthy person ranges change over time. The latest and best disease information can be provided with a link to a web page like Mayo Clinic or...

Do you have any other context? You can use VBA behind a button to set the Filter property of a form. Does the other query return one record or more? Can we assume there is a field in the form's record source that relates to a field in the query?

It may be time to get your feet wet in VBA. Create a new, blank module and paste this code into it (I think I got the logic correct): Public Function GetWanted(intDiscNo As Integer, _ varRecordingID As Variant, _ booIgnore As Boolean) As String 'Add comments here about field types...

I would record expenses in a single table with fields that store the person, category, date, quantity, cost, comments, and maybe a few other columns. There is no way I would create separate tables for each type of utility. Have you shared your ideas with any family members? There is no way I...

Thanks. We are on the same page.

Are you suggesting this post is related to Excel or did I miss something?

If you don't have certain tables, can you provide some clue as to what causes you to have hundreds and why they are growing. Do any of your tables have similar structures? Help us understand what you have created.

I would use code like: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.Last_Name.FontBold = Not IsNull(Me.DateOfDeath) End Sub

I replied from my iPad and expected the OP to give it a try and come back with questions. Creating a function allows you to encapsulate the logic into a single object that can be used over and over within an application. If/when the logic changes, you have one place to look. Here is a...

Create a small used-defined function that has the three fields as arguments. The function will provide comments and easily understood and updatable logic. Nested iif()s should be avoided.

If you feel a pain in your chest (even if for just 5 seconds), don’t ignore it. The same is true for other symptoms.

👈 As per my image, my heart stopped (sudden cardiac arrest) two years ago at age 69. I can verify, getting old is better than the alternative. I now have a valid reason for lapses in memory. I recommend a coronary calcium scan for people over 60 particularly if you experience any heart related...

Does MySQL support MVFs? I believe there is a recent thread in the Forms forum discussing this functionality.

Have you tried creating an additional column with the field in the Format() function? DateMMYYYY: Format([DateField], "mm/yyyy")

I don’t know about others but I think this thread has run its course (and then some). This should have been posted in the Site Suggestions forum. This is similar to the great idea to create a new thread regarding MVFs.