|
|
This functionality will give the RadCombobox type ahead functionality, like Google
|
|
|
|
I'm having a issue with the RadCombobox, I'd like to change the state of other controls on the page based on the text that is in the RadCombobox. I'm trying to use the RadComboBox ItemsRequested event to do this, but it's not working. I submitted a support case and got a very good answer, I'm going to blog it here so that I can easily find it in the future.
|
|
|
|
Today I needed to import a csv file into SQL, a task I've done hundreds of times. But it's not my favorite. The wizard is a little clunky and if the data isn't in great shape I get errors.
Today I tried BULK INSERT and it seemed to go great. I'll document the syntax below (much easier than looking the syntax up again), and I'll add notes as I go if I find anything worth reporting. |
|
|
|
| This example shows how to get a reference to a grid bound column. The uniquename for the column is "imgWarning". To get the type to convert it to, run the code below and you'll get a convert error on the 'Dim imgWarning' line. The error will give you the type to convert it to. |
|
|
|
| This code details changing the background color of an entire row |
|
|
|
| Set the text of a GridBoundColumn |
|
|
|
Most everyone that is a subscriber uses this site at least for the Dynamic GP table definitions. In fact, most do. But Dynamics GP is twilighting, and we all need to look to the future. Most of my clients are moving to Dynamics 365 or its little brother, Business Central. To that end, a customer has asked me to learn Power Apps, so I'm leaning how that all works.
What we do here is provide very quick, low verbiage instructions on how to accomplish a task. As I learn it and master it, I write it all down (so I'll remember next time). If that interests you, welcome along. If not, all the emails have a link that will allow you to edit the topics that you get notified about.
I'm currently plowing through the PL200 course from Udemy, I'll blog as I go along.
As always, I welcome your feedback.
|
|
|
|
I'm currently going through the prep for the PL 200 exam, the first thing that we do is create a screen that has a Gallery control to see a list of data (Customers, Items, etc)
Here are my notes on that subject, I'll add as I go along. |
|
|
|
| Adding a New button to a Gallery Screen |
|
|
|
Adding a Save Button to an Edit Screen
|
|
|
|
| Creating a Display Screen for one item |
|
|
|
| How to filter a Gallery control |
|
|
|
| Shows how to set a Default value for a dropdown on an Edit Form |
|
|
|
| Quick Guide to your first look at Power Apps |
|
|
|
| Using Global variables is pretty straightforward, example below |
|
|
|
| Shows how to set Context/Local variables |
|
|
|
| How to implement search functionality |
|
|
|
| Code example for exporting a radgridview to xlxs |
|
|
|
Creating a custom Power Apps component is one of the most effective ways to bring consistency, reusability, and polish to your apps—especially as they grow in complexity. Instead of repeatedly rebuilding the same UI patterns or logic across screens, components let you encapsulate functionality once and use it everywhere. In this article, we’ll walk through the process of building a component from scratch, explore the key concepts behind properties and behaviors, and show how a well-designed component can dramatically streamline your development workflow |
|
|
|
Input properties are the backbone of truly reusable Power Apps components, giving you a clean way to pass data, configuration values, and behavior into your component without hard-coding anything. Whether you’re building a simple visual element or a fully interactive control, input properties let you shape how your component behaves in different contexts while keeping the internal logic neatly encapsulated.
|
|
|
|
Building consistent, scalable apps in Power Apps becomes dramatically easier once you embrace the power of Component Libraries. Instead of recreating the same menus, dialogs, headers, or UI patterns across multiple apps, a Component Library lets you design these elements once and reuse them everywhere. It’s a simple idea with huge payoff: cleaner development, faster updates, and a unified experience for users. In this article, we’ll walk through how to create a Component Library, how to bring it into your apps, and why this approach should be part of every serious Power Apps developer’s toolkit.
Note that this approach in new in 2025 |
|
|
|
| Adding a component library to a Canvas app is one of the simplest ways to bring consistency, reusability, and professional polish to your Power Apps projects. Instead of rebuilding the same UI patterns or logic across multiple apps, a component library lets you design once and reuse everywhere—saving time while keeping your apps visually and functionally aligned. In this article, we’ll walk through the process of connecting a Canvas app to your component library and show how quickly you can start using shared components to streamline your development workflow |
|
|
|
Mastering Power Apps Collections: A Complete Guide to Every Command
Power Apps collections are one of the most versatile tools available to app makers. They allow you to store data locally, manipulate it on the fly, shape it for galleries, and even cache data for offline scenarios. Whether you're building a shopping cart, an editable grid, or a dynamic component, collections are often the backbone of the logic.
This article walks through every command used with collections, explains what each one does, and provides clear examples you can use immediately. |
|
|
|
A bar chart in SSRS looks simple on the surface, but the moment you try to sort it—especially by an aggregated value—you discover just how many places SSRS can hide a setting. Sorting isn’t just cosmetic, either; it’s the difference between a chart that tells a clear story and one that forces your readers to hunt for meaning. This article walks through why sorting behaves the way it does, where the real controls live, and how to get your categories to line up exactly the way you expect.
|
|
|
|
Bar charts are great at showing comparisons, but SSRS doesn’t always put the numbers where your readers actually want them—right at the end of each bar. If you’ve ever squinted at labels buried inside a narrow bar or lost them in a sea of color, you’re not alone. In this article, I’ll walk through the simple tweak that moves your data labels to the bar’s edge, making your charts clearer, cleaner, and far more readable for the people who depend on them.
|
|
|
|
When you build a report in SSRS, the parameters bar can quietly turn into a game of hopscotch—fields appear in the order they were created, not the order that makes sense to the people actually using the report. A few poorly placed date pickers or dropdowns, and suddenly the top of the screen feels more chaotic than the data you’re trying to analyze. Reordering those parameters is one of the simplest ways to make a report feel intentional, readable, and user-friendly, yet the controls for doing it aren’t always obvious. This guide walks through how SSRS decides parameter order, where you can override it, and the cleanest way to get your parameters lined up exactly the way you want.
|
|
|
|
| Returns the variable name that we want to use in VB for a SQL table column |
|
|
|
This code isn't finished, but I don't have time right now and I need to save it, so...
It is designed to write VB code for a form that has an editable Telerik grid.
|
|
|
|
Hi, we have to enter a lot of prior FX Rates,i'm tempted to do a SQL script in DYNAMICS.DBO.MC00100 and enter them like this:
NOTE: the Currency ID is USD-UYU and the Rate Type id is USD-UYU-DAILY.
insert into DYNAMICS.dbo.MC00100 (EXGTBLID,CURNCYID,EXCHDATE,TIME1,XCHGRATE,EXPNDATE) values ('USD-UYU-DAILY','USD-UYU','2025-04-01 00:00:00.000','1900-01-01 00:00:00.000',42.1270,'2025-12-31 00:00:00.000');
insert into DYNAMICS.dbo.MC00100 (EXGTBLID,CURNCYID,EXCHDATE,TIME1,XCHGRATE,EXPNDATE) values ('USD-UYU-DAILY','USD-UYU','2025-04-02 00:00:00.000','1900-01-01 00:00:00.000',42.2260,'2025-12-31 00:00:00.000');
insert into DYNAMICS.dbo.MC00100 (EXGTBLID,CURNCYID,EXCHDATE,TIME1,XCHGRATE,EXPNDATE) values ('USD-UYU-DAILY','USD-UYU','2025-04-03 00:00:00.000','1900-01-01 00:00:00.000',42.2850,'2025-12-31 00:00:00.000');
insert into DYNAMICS.dbo.MC00100 (EXGTBLID,CURNCYID,EXCHDATE,TIME1,XCHGRATE,EXPNDATE) values ('USD-UYU-DAILY','USD-UYU','2025-04-04 00:00:00.000','1900-01-01 00:00:00.000',42.1080,'2025-12-31 00:00:00.000');
I just wonder if someone else tried it this way.
Have you tried Integration manager?
|
|
|
|
Is there a way we can turn on history tracking for multiple (50+) existing parts on the Item Master? We have several part that we were created without history tracking activated, the quantity received never appears in our inventory and it is not available to ship or sell. Is there any implications to doing this after the fact? Is there a SQL query that could do this or do I just need to go into item maintenance card for each item?
|
|