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...

Thanks very much you guys, I will make a note of studying what you've written here as I'm sure it will come up again. To clarify, the data reflects scans of cartons on a conveyor. They are scanned and weighed at the same time. If the carton weight is out of spec (something is missing) it's...

Thank you both very much! I will try it out first thing on Monday.

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...

Well, Tamar's answer proved to work very well, thanks. But now I have a new wrinkle on this that has me stumped... I now need to add in a field from another table to the primary select statement. Ordinarily I would just set up all the fields with a tablename qualifier and then do a simple...

Thanks. I have downloaded it and will have a good look at it. Anything has to be better than the Windows installer.

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...

Thanks Tamar, this sounds workable. I'll give it a try!

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...

Thanks, I will try this out. For some reason I was having trouble hitting on the proper syntax to make this work and the examples I was looking at were not helpful.

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...

For the sake of argument, I get the point about one query not necessarily validating the results from the next. But assuming his data has values in all four records for Stock_Quantity, shouldn't it still work regardless? I'm having a hard time understanding why it does not.

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...

Played around with it some, I think I can make this work. At least I have an idea now to present, worst that can happen is they say no... Thanks Craig

Thanks Gentlemen, that sounds like it might work. I will look into it right away. Andy, yes ideally they want all three to be seen at the same time, but I think they understand that at smaller resolution they may have to put up with being able to see only two at a time. I sure hope they...

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...

Thanks Tom, I had just found it and was about to come and say thanks but I figured it out... Seriously thank you though. Craig