Search results for query: *

Below is some code I use to loop through rows in a datagridview and set the row colour subject to a "STATUS" field and also changing font colour and boldness dependant on whether a flag has been set to true. Is this code optimal / can it be cleaned up somewhat? Public Sub ColourMyGrid()...

I have an application that connects to a SQL Server (2000). This application is used by 4 global sites, and each site connects to the UK (HQ) and then accesses their database from the SQL Server. I want to move these databases off of the SQL Server and into an SQL Express database. I assume...

Afternoon all, Obviously my table has a Primary Key / ID field. This is currently set as varchar, as the user has to input this (it's not a simple identity integer field) - the field is called WO_No What I need to know is can the following be done. When a user enters the WO_No, I need it to...

I've been requested by users of one of my apps to allow them to search on a number of fields. This isn't dymanic in the sense that the parameter can change, it's dynamic in the sense that what they want to search for can change. I.E. I have 5 fields that are searchable, all comboboxes with...

Good afternoon I'll try to explain this as best I can. Have a report that shows main table fields and then "links" to lookup tables I have 2 fields "Technician A" and "Technician B" In my DataSet, there are 2 datatables, TechA and TechB (both with EmployeeID, EmployeeName) Technician A is...

Good morning, I am exporting a datagridview to a text file. The code to do this is: Public Sub WriteTextFile(ByVal dgv As DataGridView, ByVal varlbl As String) Dim strExport As String = "" 'Loop through all the columns in DataGridView to Set the Column Heading...

Hello Haven't posted on here for quite a while!! Hope everyone is well. When users use my app, they log into Terminal Server and open the program from a shortcut on their desktop. I use some code which takes their user logon (they log onto TS with their network username and password). The...

I've set my app up so that when I run a crystal report, I connect to the same DataSet that my data has loaded from into the form, and just pass over the parameter of the ID needed for the report. If I fill the dataTables blah blah blah, the report will load fine. When I create a new record...

What's the best way of displaying many-to-many relationships on a form? I'm trying to create a simple app to show Printers and Consumables. Printers can have many consumables, and these consumables can be used on many printers. I've created the three tables: prn_Printers prn_Consumables...

Hey guys, I have a number of searches building up in my app and I was wondering what the best option was to show these results. At the moment I am using only 1 form, with a panel that shows first with a number of checkboxes. The user selects the search by using one of the checkboxes. some of...

OK I'm really confused atm! I haven't done any programming for a month or so, things are starting to get rusty ;) I have 3 tables, and these are the primary keys in each: TableA: OrderNo TableB: StockNo, OrderNo TableC: LineNo, OrderNo, StockNo When I add a new row to TableB after adding...

Hey all, haven't posted for a while, thought I'd post my latest stumping :) Using 6 NumericUpDown controls on a form for a user to enter some data - however, at times some of these may be entered as 0 (which the control reformats correctly to 00.00) However, when the row is saved to the DB...

Hi Guys, I can do the basic file delete, but I need to work out how to delete a file with a changing part of the filename. My app creates a PDF called DCList - date_of_creation.pdf i.e. DCList - 01 February 2008.pdf Any changes made to the data in the database automatically forces the user to...

Hi, I have a dataTable that needs to contain data columns from another table. To achieve this I'm using subselects. I'm wondering whether there is an easier way to do this though. I have 2 tables. "Ingredient" and "RecipeIngredient". RecipeIngredient is the table which splits up a many to...

Hi, I'm trying to write an SQL query that lists all Customers that haven't had any work set to them. I've got the basics, but there's a "middleman" table of Customer Sites. This is a basic DB layout: Customer (can have many) CustomerSites Development Samples A customer site is set to the Dev...

I won't go into too much detail because I don't think many people are using Outlook Redemption (from a previous post I put up ages ago with no replies ;) ) I have 4 comboboxes that drop down to list names. I want to be able to store them 4 names as some kind of array, and then loop through...

I have a search form, and another form which displays the results from that search. At the moment on the search form there are about 8 radio buttons (each one is a different search, i.e. search all, search ID, search description, etc) I have set up Global Parameters using a module in my...

Its been a few months since I last did any programming, so I'm a little rusty and this may be a nice simple question! I have a number of fields in my table, 2 of which are important. The first one is a Identity, so my SQL server sets that as needed. The 2nd field is a manually entered...

I've set my textboxes so they accept numeric values only. I want to make sure that the user can't enter a value above 100 - is the best way to check this to do something along the lines of; If me.textbox1.text >100 Then MessageBox.Show("Please enter a value less than or equal to 100") End...

I've set up a form that the user has to go through the correct motions - i.e. I've set the tab order. Is there a way that I can disallow the use of the mouse click into the textboxes, so the only way they can navigate the form is to use the tab ? Thanks!