Search results

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

Why bother with query as form RecordSource since it doesn't have multiple tables and there are no calcs and no filtering? Just bind to table. Your code puts the first record into edit mode with Me.cboProfileDimensionID = Null. This is changing existing data. Since this combobox is BOUND, should...

No. As noted in post 23, line "Option Explicit" has to be manually added to existing modules. All the property setting does is automatically include this line in new modules.

Expression must reference subform container name. I always name container different from object it holds, such as ctrDetails, then: =[ctrDetails].Form.[txtAmtTotal] or =[ctrDetails]![txtAmtTotal]

First, please post code between CODE tags to retain indentation and readability. Second, what line triggers overflow error? I don't immediately see anything that would prevent code running in 64-bit.

Could but don't expect OP to be open to idea. Doesn't like to use VBA. Lost cause here. MVFs are essentially a normalized structure, just hidden. Beyond that, OP has rejected advice to normalize schema. See post 9.

Still get same issues. MsgBox and Table1 hyperlinks work. I tried building macro but it tells me MacroTableManager already exists but I can't see it. Copied table into my db and built macro. Now it works - except for records 1 and 2 - no form and no VBA. At least it confirms Allen Browne...

I get error 2046 "The command or action 'LinkedTableManager' isn't available now." Command works fine in another db. I think this download got corrupted because getting other weird behavior - PropertySheet insists on displaying when form in Datasheet View. Why does Allen Browne indicate...

Not clear to me what you are asking. Do you want to know how the Hyperlink works to open Linked Table Manager? The hyperlink actually triggers a macro that opens the LTM. I tried setting up a Hyperlink field that would open Access objects and it is not working. This tutorial says it should...