Search results for query: *

Wondering if someone can help me. I want to create a report that prints out what are essentially tickets (2" x 3.5") on pre-scored business card sheets, 10 to a page, 5 rows in 2 columns. Each ticket is unique and has different data that gets printed on it, so it's not as simple as just making...

Hi JE Well, the complete DB is about 16-20 mb, and that seems like a lot to make a copy of every time a new session gets created. Then again these days that's a drop in the bucket in terms of storage memory, isn't it? I did find a reference as follows: INSERT INTO <tablename1> SELECT *...

Hi folks Got a bit of a head-banger going here. I'm trying to use the Microsoft Report Viewer control and an RDLC report to show some data from my project. But I'm having some trouble trying to get it to work the way I want it to (and how I think it should). Here's what I've got: I created...

Hi Folks I have an Access database I'm using for my application that contains about 15 tables, mostly fairly static data. But three tables are fairly dynamic and contain data that will change from one 'session' to the next. I plan to create a separate 'Session' access DB that I can copy and...

Thanks so much Guys, you both really helped. This is what I finally did to make it work, and it's working really well. Joe, the list is about 12,000 entries long but it only adds about a half-second to the return of the grid data, probably because I figured out how to so a search against a...

Hi Folks, Merry Xmas! Was hoping someone could help me out here. I have a DataGridView control in my project and in it, one column that I'd like to check the value of against a group of data to see if the value matches one of the items in that group. If it does, I'd like it to display...

Hi folks, I could use a recommendation. I'm writing an application in VB.net 2008 that I would like to distribute someday soon. I'm trying to make it as independent as I can so other software pre-requisites don't affect who can use it. For instance, I have some specialized reporting I need...

I may be barking up the wrong tree here and this might not be possible, but if you don't ask you might never know. I have a page on my app (VB.NET 2008) that has a group of four combo boxes designed to allow the user to drill down and select more and more granular data until in the last box...

Glad you finally figured it out, Joe! CraigHartz

Thanks Joe - I'll have a close look at it when I get a chance! CraigHartz

Hi SoonerJoe OK Well I finally figured out a solution from one of the how-tos on the net. I created the DGVComboBoxColumns just as we discussed, but instead of trying to assign them to the dolumn of the DataGridView, I used the Insert method of the DataViewGrid to force them into it. At least...

Yeah so here's the thing - If I don't use the New keyword when defining the object I can do the assignment, but when I go to run the program I get an error stating that the DGVComboBoxColumn is not a valid object. If I do use the new keyword it creates the object, but won't allow me to do the...

OK SoonerJoe, thanks. I dug a bit more and setting the columns in the grid to readonly = false now allows them to be clicked and upen up - but there's no data. I looked further and realized that while I have defined the DataGridViewComboBoxCoulmns and anm able to load them with data, I can't...

Thanks SoonerJoe - that was really straightforward and simple to understand, and it looks like it works perfectly. Couldn't fins anything that clear in hours of casting across the net. I have one other issue which is still stymieing me - when I run the program it seems like everything is...

Hope someone can help, this is really kicking my butt. I have a DataGridView I'm displaying in my VB.NET 2008 application. I'm not having any problem displaying data from the datatable being used as a datasource, but I do have a column in the grid that is supposed to be a drop-down listbox...

yep, that'll do it too. CraigHartz

Hey SoonerJoe I think I figured out a solution after banging my head on this all day yesterday - don't set the datasource property to nothing. Instead, just before you issue a new Fill command, do a Dataset.Datatable.Clear() call. then fill the datatable as you would have. This worked out...

Hoping someone can help... I'm using a DataGridView to display information from an unbound table. The first time I load the grid it uses my formatting settings I created at design time, which is great, looks perfect. But when I refresh the DataTable the grid is bound to as a Data Source, I...

Hey RiverGuy lol- oddly enough I sort of understood what you were trying to say! In the end what I ended up doing was to create a function with a select query into which I pass the table name, the Code field, the Desc field, and the Code Value, and return the Desc value. Just a simple...

Hi RiverGuy Thanks - unfortunately the values are not static, or yeah I would have set it up pretty much like you suggested (perhaps not as well). But the values can be different, which is why I was hoping to figure out something that would take the code value and look up the descriptive...