Search results for query: *

thread222-1773633 Hi I'm having what I believe the same issues as you say you have resolved, but I was wondering if I could get a little more clarification. I have a .net desktop application which uses the Office 365 Interop, specifically the version 14 libraries so mention and Excel. The...

The monthly ID field contains a numerical record ID. What I'm trying to achieve with the text true or false is to get the 3rd column in the datagridview to be a checkbox that is populated if true. I did get this working previously without converting the Monthly ID to a true or false, but hid...

No, I've tried this! The SQL statement returns 3 columns of data, the 3rd contains either true or false. The data is linked to the datagridview as a datasource so rge columns are automatically created, I just need to be able to format the 3rd one as a checkbox

Evening All I'm having a headache with a dataGridview! I have a blank datagridview and I autogenratecolumns set to true. My dataset is 3 columns, 2 text columns and the 3rd returns either True or False. My code for populating the dataGridView is below....what I need is for column 2, headed...

Ok, 2 things here: 1. The original point of the post was that I was unable to write the stored procedure to SQL in order to run it 2. Can you give me an example or a link to how I can update within the code? Thanks

Thanks for the responses. I think I may not have explained clearly enough. The main issue is that I cannot have a fixed stored procedure because the actual data fields that may require updating will vary, so I need to create a stored procedure on the fly, process it for the 10 records and then...

The user can search records initially and that may return say 10 records which the user can view one after the other. The user can also amend any of the fields on say the first record and can either click an update button which will update the current record, or click an update all button which...

Morning All I have an application which allows the user to select a range of records based on a search criteria. I need the ability to update all of those records based on single or multiple field value changes. The form has c40 fields that are amendable. I have have determined which fields...

Hi Andy Thanks for your response. I'm guessing you mean add that line and remove the Update button? I've tried this and the underlying data is not updating! Thanks Steve

Good Morning All I'm using Visual Studio 2019 I have an issue with a datagridview that I just cannot resolve....after a lot of wasted time! My datagridview is populated programmatically from an SQL table, and clicking an update button needs to either update the database, or insert new records...

Good Morning! I'm having issue coding a MenuStrip to have drop down items and need some advise please! Within my Form, I have an item MenuStrip1. Within MenuStrip1, I have a collection, Sub1 to Sub10 which I populate programatically depending on a User's Login, this works perfectly! However...

Hi I need help!! I have 2 tables, tblCountries and tblTempSubscriptions tblTempsubscriptions has a column CountryConv and is linked to tblTempSubscriptions by the field Country NR. The tblCountries may have multiple records that contain the same CountryConv and I want to only pick up the 1st...

Help!! I'm using Crystal Reports 2011 I have a report which reports the number of days a support ticket has been open. within my database, there is a history table that contains ststus changes within the support ticket. I need to be able to calculate the number of days that the support ticket...

Hi I have the following stored procedure and I need to add a summary line with totals on the following fields: BTARevenue DrillRevenue GRDRevenue HoneRevenue Unit1Revenue The stored procedure is attached. Any help would be gratefully accepted! Kind regards Steve...

Thanks for the response Tamar, unfortunately this yielded far too many records! I know my target record set is only 355 records, however this has returned over 800k!

Good Afternoon I'm having an issue getting my head around a select statement using multiple joins! I've built my query in stages and tested as I've gone and it works fine until the third / fourth join is created so I need some advice! I have and POP_Header table, an POP_Detail table, a...

Hi I need to search a mySQL database to find where a certain column within a table is updated, so I'm assuming this must be either a stored procedure, a view or a trigger. I know how to do this in MSSQL but I'm struggling with mySQL....can anyone advise the script(s) that I would need to run...

Hi JBenson, thanks for the response. Apologies for my lack of reply, other projects have taken precedence on this one! I've checked my code and there is no place where genGridView.Enabled = False is set! Basically, what I need to be able to do is have the entire genGridView diasbled /...

...= MaxRowCount If ComputerCount Mod genGridView.RowCount > 0 Then ColumnCount = (Int(ComputerCount / genGridView.RowCount) + 1) * 8 Else ColumnCount = (ComputerCount / genGridView.RowCount) * 8 End If ColumnSet = ColumnCount / 8...

Hi Olaf Unfortunately, the reason for the field being declared as a float is beyond me as this is an old database! However, whilst your response didn't resolve my issue, you certainly pointed me in the right direction and I have sorted my issue, so I thank you for that! Best wishes Steve