Search results

AFAIK, Modern Charts upgrades are only available in Access 365, not desktop version. I have not tried coding for Modern Charts. My code for Classic is working but the data is very limited. Unfortunately, not all graph properties show in Intellisense hints (such as SeriesCollection although it...

Vertical is a property of labels and textboxes that can be set in design. I think MarkK meant to rotate the paper, not the screen. I did a test. Build report in portrait or landscape orientation, print it then turn paper for reading. However, report and page headers will not position above...

Your output table does not reconcile with the input data but I think the requirement is clear enough. Rearrange data to normalize vertically. There is no builder/designer for UNION - must type or copy/paste in SQLView. Limit of 50 SELECT lines. Query1: DataUNION SELECT WeekOrder AS Wk, 1 AS...

It is possible to calculate a week number DatePart("ww",Date()) but that won't handle week that crosses years. To see that, output from Immediate Window: ?DatePart("ww",#12/28/2025#) 53 ?DatePart("ww",#1/1/2026#) 1 So instead calculate a field for "first day of week" and aggregate data by...

Error triggered by wmp_Theme.URL = CurrentProject.Path & "\" & txtTheme I disabled all lines for WMP then game works, just without sound effects. Tested with Windows 11 Home and Office/Access 2010. Same issue with WIndows 11 Home and Office Pro Access 2021 version 2507 (Build 19029.20156 Click...

Don't think a pic will provide more info but here it is. I will have to do some debugging.

Options have been described. Make a choice. Table would not be required for option buttons or checkbox.

You build query object that has MinutesWorked and DateWorked fields and use it as form RecordSource. Then create two textboxes on form and copy/paste expressions. Or use Ken's custom function. Then tell us what happens. Tell us more than "I tried". Or provide db with your efforts.

Click Start button triggers error "Object doesn't support this property or method." I click OK and next form loads but cursor buttons do nothing.

We understand the requirement. Several approaches suggested. Post 11 shows two textbox expressions to produce desired results. On a form, using DSum() expression will result in daily total showing on both lines for each employee. What exactly did you try and what happened?

This data is not saved to a record?

Agreed. Your options: 1. define field as text type 2. keep number type but use a value list that saves a number while showing text set combobox for 2 columns with widths 0";1" and ValueList of 1;LEE;2;Withheld This means will have to use combobox on report (will look like textbox) or an...

I am using: Windows 11 Microsoft® Access® 2021 MSO (Version 2507 Build 16.0.19029.20136) 32-bit My box looks like the old one, except corners are slightly rounded. Don't think I did anything to cause that. I don't think there is an Access setting to change this. Would probably have to be...

Do you want to show detail records or just aggregate so one line per employee per day? Either way can be accomplished with report Sorting & Grouping and aggregate calcs in textboxes. Or use aggregate query as suggested. I think what has been provided pretty much "spells it out" so you need to...

Why would you NOT do these calcs in report?

Oops, I overlooked the word "form" in original post. If you don't want form to be used for data entry/edit, then build aggregate query as I suggested and use that as RecordSource. If you want to be able to do data entry/edit, then, as Gasman suggested, use domain aggregate expression in...

Build aggregate query that calculates total MinutesWorked grouped by employee and date. Then do HoursWorked calc in a textbox on report. SELECT TCtable.EmployeeID, EmpTable.EmployeeName, DateValue([TimeIn]) AS WorkDate, Sum(DateDiff("n",[TimeIn],[TimeOut])) AS MinutesWorked FROM TCtable INNER...

Try: If Parent.Name = "this name" Then 'do this Else 'this End If

The "tool" is a DELETE query with filter criteria.

Review https://www.accessforums.net/showthread.php?t=91036