Search results

It seems you are attempting to store a text value in a numeric field. Rather than a Value List, consider using a small lookup table to store the drop-down values. These tables typically have a numeric primary key (autonumber) that gets stored in the main tables

You can either calculate the values or reference the form and control in a text box on your report like: Control Source: =[Forms]![employee details].[First Name]

You are a better mind reader than I am 😊

Are you suggesting you can’t use a report grouping to calculate aggregates or are you referencing @June7 post? You can’t use an aggregate function in a header or footer based on the name of a control in the detail section but you can use fields from the report’s recordsource.

Typically you would group your report by employee and date. Add a header or footer for this grouping to display the sum of the time worked. As June7 suggested, there could be issues if shifts span midnight.

But you said you can’t make decisions about splitting until the database is finished. Apparently you will never split and quite possibly never deliver a working application that will be worth all the effort you are putting into it.

Your database will never be finished (I had to control my urge to type that in BOLD, ALL CAPS)!

Sorry, I had simply read the misleading title.

You may need to set an attribute to save the password. Check out Doug Steele's function for the "Addendum 1".

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?