Search results

If you want to compare to cost, need to modify each conditional rule to reference appropriate field or control or expression in place of of "0". Possibly: [Stop_Current] > [TotalCost_$] AND [Text523] > [TotalCost_$] [Stop_Current] < [TotalCost_$] AND [Text523] < [TotalCost_$] Expression for...

This rule also worked in my test of combobox: In (-1,0) Or Is Null

I tested with Colin's app. I cannot use CDO with Outlook any more. Been a while since I tried but as I recall this requires some kind of account I can't have as an individual. However, I can get CDO to work with Gmail. I did have to set up a special Google account. Although, my phone email app...

And the zombie phenomenon should not apply with SQLServer backend? Perhaps we can track down issue with db. Make copy of frontend and import relevant tables.

Review http://allenbrowne.com/AppInventory.htm

An UNBOUND form using VBA to lookup LoyaltyAmount and execute SQL actions is one option. Another is form bound to Clockings table and focus on new record row (form set for DataEntry yes will only allow new records) Scan barcode into a combobox control. Combobox RowSource is like: SELECT...

Yes, subforms could work. I have actually done this (once). Build each subform with static criteria in Filter property for particular attribute type. A combobox will have attribute values relevant for that type only. Might also be able to apply this concept to report with subreports and avoid...

With Plog's suggested data structure, all attributes are stored vertically. Each selected attribute is a record. This eliminates MVFs. Then if you want to display the attribute values under attribute type columns horizontally in query or report, would likely need VBA to concatenate into CSV...

"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?