Search results for query: *

Hi Folks May be a simple question but I can't seem to figure this out - I want to return a query of open orders and on each row show a count of the order items for the order. I'm guessing that a sub-query would be involved here but I can't seem to hit on the proper structure of the command...

Hi Folks Quick question. Working in VB.NET 2015, on a new form I've added to an existing project. Until recently I've never had to recompile (Rebuild) the project in order to have debugging work, always just saved the changes and ran the project no problem. But with this new form I have to...

Greetings! I am working on a program that will allow a user to set up scenarios for different companies. The basic company data (Name, ID #) are stored in a DB table. I have a menu item under the File menu that says "Select Company", and I'd like to create submenu entries for each of the...

Hi Folks A few weeks ago I had asked how to create a select statement that would only return one record per ID Number where the Timestamp was the latest of many. I received some very good advice (Thank You) from this group. However, it seems that there are some records with the same timestamp...

Hi Folks Hoping for a little advice. I have a VB.NET 2008 application I've been working on for a number of years, and finally it's almost ready to be released. I'm trying to figure out, though, where I can place my data file where I can have both read and write access to it and where it won't...

Sorry if this is kind of crazy, but I'm looking for some help... I am trying to set up an installer package for my VB.NET application (2008) which uses some Crystal Reports. I have the requisite MSI files to install the redistributables for Crystal Reports for Visual Studio 10.5, but they are...

Hi, quick question, hopefully a simple answer... I am tasked with returning a set of records from a table in which there can be several records for the same item with differing timestamps. I need to get the most recent record for each item from the table. I'm pretty sure a SELECT DISTINCT won't...

Hi Folks I have an app I wrote last year as an exercise in C#. In it I used a List object to accumulate a group of records that I eventually printed out on a form. Now I am revisiting it and I would like to add an Undo feature. But to make this work I need to know what the information was in...

Hi Folks OK so a few weeks ago I asked about showing several grids on a form, and you folks gave me a great solution (Place them in a panel) which worked great - thank you. As it turns out there were more controls than just the grids to display repetitively (labels, text boxes, bottons) that...

Hi Folks Just inherited a project as the new guy here at work. I have a form done at a very wide screen size resopution (1924 x 893) and some clients that don't have HD-quality monitors are complaining they can't see the whole screen. I've been asked to come up with a solution to the problem...

OK Here's another one I'm stumped on... My app supports drag and drop. Part of the logic is that when a text value is dragged from one textbox to another, the originating textbox is supposed to have it's color changed to gray. If it does, it cannot be used for drag and drop again. This is...

Hi Folks I'm working on a small app that allows users to type alphanumeric values into a series of text boxes. I would like to automatically convert any lowercase text (a-z) typed into the box into uppercase (A-Z) as they are typing it. I already know about the string.ToUpper() function...

Hi Folks OK I've taken Rhys advice and created a class in my program as follows: public class CarMovement { public int Id { get; set; } public string CarName { get; set; } public string MoveStatus { get; set; } public string SourceCtrl { get; set; }...

Hi Folks OK so I'm working on an application where I move data around from one text box to another, and part of what I need to do is keep a record of what data moved from one TextBox to the other. Since I come from a VB background I figured I would just create a 2-dimensional array and store...

New Question: The C# 2008 app I'm working on needs to be a drag and drop interface where the contents of any textbox should be able to be copied / moved to any other textbox on the form. I have the basic code to do this and it is working fine. The problem I have is that there are over 100...

Hi Folks I have a SQL Server database that I need to move into a LocalDB for distribution with an application (VB.NET) I've written. Unfortunately I'm no DBA and the half-dozen or so times I've attempted to do this I cocked it up completely. The DB was originally developed in 2008 R2 Express...

Hi Folks Working on a C# app to practice - I've been a VB.NET programmer for years and I'm trying to get used to working in C# now. The app I'm writing includes over 80 text boxes in about 8 groups, each group in more or less in a grid pattern. They are named "txt<GroupName>1_1" for the box...

Hi Folks I'm being assigned to a project at work that has an issue displaying data returned from a recordset. I have not seen the code yet, but they have described it to me - the recordset is very large, well over the 25,767 item limit to a listbox, and I think that is the problem - the...

Hope someone can help me here... Working on a MS Excel 2003 project that reads data from a sheet and uses it to create a summary report. Each row in the data sheet is used to populate one cell on one row in the report; there are about 20 rows per project in the data sheet, each one gets a date...

Hope someone can help me here... Working on a MS Excel 2003 project that reads data from a sheet and uses it to create a summary report. Each row in the data sheet is used to populate one cell on one row in the report; there are about 20 rows per project in the data sheet, each one gets a date...