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

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

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

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

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

HELP!! I have a dynamically created datagridview which is added to my form controla and repeatedly refreshed. The gridview has 3 sets of 8 columns but only displays a set of columns if the row count in each set is greeater then 0. Initially the datagrodview was disabled as it was only intedned...

Hi I have an old database that stores dates as floats and I need to change 2 records on one of the tables and the front end generates an error. As it is only 2 records, I have suggested, to save time at least, that I manually amend the SQL record! Unfortunately I do not know how to convert the...

Good Evening I'm struggling to get past an error 3075 - Missing Operator and would like some advise please? I have an Access database with the following tables: tblOrderMth tblOrderRFP tblStatusList tblOrderMTH contains the required Order Number in field OrderNO The tables are joined as...

Good Morning I have a question relating to multiple combo boxes on one form....I have 4. The first 3 allow the user to select a single record from 3 seperate tables. The 4th needs to be able to select records from a 4th file based on the 3 items selected in the first 3 combo boxes! Please can...

Hi I have a table, SupportFiles that has columns ClientID, SupportYear and SupportMonth. Each ClientID has multiple records for each SupportYear and SupportMonth. I want to be able to select distinct on the SupportMonth and SupportYear, combining the 2 into a dropdownlist record! (I think that...

Afternoon, I'm hoping I am in the right forum, if not, could someone please advise. I have an ASP.Net application, using VB to code. I am creating client invoices and saving the PDF version in a SQL table. My users have an option to be able to Email the invoices to the respective client, and...

Hi I have the following select statement: select PurchaseOrderID, (cast([OrderDate] as VARCHAR(11)) + ' ' + cast([OrderTotal] as VARCHAR(8))) As Detail from PurchaseOrders where SupplierID = 117 and PurchaseOrders.Paid = 0 It gives the following output: 1916 Sep 21 2016 13.00 1917 Sep 27...

Afternoon All! I hope this is the right forum, if not, please let me know! I'm in the process of creating a VB, web based application, with an SQL back-end. I have multiple forms completed and working fine, however, I now have an issue with the following line of code and I have absolutely no...

I have a table, Invoice that has a column InvoiceDate, type date. I need to create a computed field that is based on the month number and the year number of the InvoiceDate but it needs to be in the format MMYY. For eample, if my InvoiceDate is 2014-07-14, I need the result to be 0714. I've...

I have a project where I am populating and invoice template where the main body of the invoice has alternate lines that have a background colour of white and grey. Depending on the size / length of the invoice text, lines within the invoice are merged and then dependant on the invoice line count...