Search results

"Variable not defined" on ColorBank. Is there more code you have not provided? Could provide db for analysis. I fix that then get your error on Set NewFrm = New Cls_Form Your Class_Initialize doesn't make sense to me as it is not setting default values of class properties. It is setting...

Yes, that is justification for saving the reward with each clocking. Doesn't matter if you call these "clockings" or "inventory", still transactions of in/out movement of something.

Your entities are Members and Clockings. The common identifier to link on is barcode, not reward value. Reward value for a member can change and many members can have same reward - assigned barcode should be unique per member and never change. You need history if members are allowed to...

What is LoyaltyAmount field in Members table for? Different reward for different members? This is no different from tracking inventory or leave balances. Review http://allenbrowne.com/AppInventory.html Unless you want to wipe out rewards each day. Use or Lose? I agree - relationship setup is wrong.

What worked for me in my db test: 1. VBA builds comma-delimited string of UNBOUND listbox selections 2. VBA sets form Filter property with: Me.MyMVField.Value IN(strList) 3. VBA sets form FilterOn property to true Code to build filter criteria in step 1 will certainly be a bit more complicated...

Seems that manually opening a Word merge template requires responding to an initial prompt to confirm data source. Then have to initiate the merge operation. So I presume opening a Word merge template with Access VBA is not as simple as opening a basic Word document. Found some old code in my...

Does this help https://stackoverflow.com/questions/3905580/mail-merge-started-by-vba-in-access-let-word-open-database-again

I tried that with your db. No change in behavior.

That's expected behavior. Afraid can't be long as you have and not get that. Need to reduce height of subform and box and main form so all parts can be viewed on smallest monitor this is intended to be viewed on. This is why forms have scroll bars.

I do this in my db. Report is saved without a RecordSource. Code in report Open event sets RecordSource. Going direct to print output, it has the expected data even though does not hit breakpoint in the event.

Using data driven approach, built charts in Modern and Classic without VBA. Not liking text quality in Modern. Calibri used in both. This is in Access 2021.

Perhaps I should have said "non-subscription" version?

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.