- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 3
- Posts with Downvotes
- 3
- Downvoting Members
- 3
70 Posted Topics
 | I normally use SQL as the backend database however for a new project I need to use MSAccess. I am trying to insert a new record, this works fine if I only have on fielid on the row but as soon as I have a second field I get an …  |
| | I have a nested query that is counting how many invoices have been raised for a customer between a daterange which is working fine EXCEPT..... I am getting null in the Invoice_Count field and I would like to change this to 0. I have tried isnull(SUM(CASE WHEN Inv1.ih_credit = 1 …  |
| | Can anyone help me with a SQL string ? or point me in the right direction? I have a colum called ctn_node_path which has results like PARTS & ACCESSORIES > PSJOHNSON - SEDDON JOHNSON PARTS > JN - JOHNSON PARTS I am trying to split the string into three PARTS … |
| | When i run the statement below i am getting a number of xxx.xxxx can anyone help me change this to two DP? (SELECT sum(oht_net) FROM order_header_total JOIN order_header ON oh_id = oht_oh_id WHERE oh_cd_id = cd_id AND oh_sot_id = 1 AND DATEPART(yyyy, oh_datetime) = (SELECT DATEPART(yyyy, GETDATE()) -1))  |
| | I have two forms the first FrmRecipe.vb form has all my calulations and functions in it the second FrmReports has a crystal report viewer with loads of reports. I am trying to call the report as a thread so that the main from is still working however when the treads …  |
| | I am importing data from excel into datagridview its kind of working fine. my data is like this in excel 10001 MR NEW 10002 MR OLD 10003 MR CLEAN 1MB21 MR DIRTY 1BA12 MR DIXON 1EA12 MR RYDER When I load the data all is loaded untill it gets to … |
| | convert the text to a number `If NumericText ({field}) then ToNumber ({field}) else 0` you may also have to do a calulation to make it into a decimal number  |
| | I have a form with only 1 object on it , a progress bar. when the form loads it runs the progress bar, which is working fine. when the progress bar hits the max vaule i want the form to close but no matter where i put the me.close the …  |
| | What i do in this case is use a datagrideview and make it behave like a combo box. I set the datagridview to one coloum in width, and when you select your required option use the datagridview row click option to bring back the data you require |
| | I have the folling code which imports my CSV file into the respective columbs on my datagridview I would like to clean the string by removing any " from the string before populating the datagridview. can anyone point me in the right direction please? Dim newstring As String = Nothing …  |
| | Morning all, I have some code which says if a text box is empty show a msgbox asking user to input data into this textfield. i then want only an O.K button to show on the msgbox but then no to continue with the sub. [CODE] If Me.txtLine2Rcon.Text = "" …  |
| | I am trying to calculate days between two dates so that I can find out if they fall in the 30 / 60 / 90 day bracket The calculation I am using is working fine ` DATEDIFF(day, dbo.TblReturnDetails.RcvdDate, { fn NOW() })` what I am trying to do now is … |
| | can anyone help me with the code below, I would like to strip out comas from the URL http://www.balmanltd.co.uk/products/steering/ball-joints/ball-joint,-drag-link-end/am1148 $str = trim($str);/*remove any unwanted outer spacing*/ $urlkey = preg_replace("/[^0-9a-zA-Z]+/","-",strtolower($str)); $htmlkey = ($htmlext) ? $urlkey.".html" : ""; return array($urlkey,$htmlkey); |
 | have you tried turning UAC (User Access Control) off? Start > Search > UAC |
| | |
| | I have a datagridview with 10 rows I can select mutiple rows by using Ctrl & Mouse click but what I would like to do is use a button to select the row. I.E the user could select row one, click the button and row one would be selected then … |
| | I assume that you they are diffrent Details sections on your report? |
| | I have data already populated in a datagrid I have three textbox txtCustomername, txtPartcode, txtinvo I want the user to be able to input text into the txtcustomername text box which will result in the datagrid only showing the rows that relate to that customer. Then I want the user …  |
| | would this also work if using a ODBC connection to my sql server? |
| | to open a MDIChild from my main MDIparent form I would use Dim ChildForm As New FrmComponent ChildForm.MdiParent = Me m_ChildFormNumber += 1 ChildForm.Text = "Add & Edit Components" ChildForm.Show() But I want to open another from from FrmComponent which used the same MDIParent. at the moment I am using …  |
| | I have a datagrid and when populated I would like to loop through the rows and add the rows to a email below is how I setup the datagrids 'Sets up the DGVInvItems DGV Public Sub setupRMAItems() DGVRMAItems.DataSource = GetRMAItems() DGVRMAItems.Columns("DetailID").Visible = False DGVRMAItems.Columns("PCode").Width = 150 DGVRMAItems.Columns("PDescription").HeaderText = "Descripton" DGVRMAItems.Columns("PDescription").Width … |
| | I am writing a program for a company and would like to limit how many users can use this program at one time. IE if they have a 3 user licence when the 4th user tries to log in it wont let them. I have no idea how to accomplish … |
| | can anyone help me with closing my form. I am getting the following JIT errors See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.InvalidOperationException: Collection was modified; enumeration operation may not execute. at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource) at …  |
| | i am having real issues trying to build a sql string Dim SelectQry = "SELECT * FROM TblSupplierQuotes where TenderNo='" & Me.txtTenderRef.Text & "' AND KMBPartNo=" & " " & Me.lbKMBPartNo.Text & " " in SQL the TenderNo is varchar(50) = L003141T75-2012JANTEN KMBPartNO is text = 442 019 115 1 …  |
| | I have the following code Dim adoCN As ADODB.Connection Dim sConnString As String Dim sSQL As String Dim lRow As Long, lCol As Long sConnString = "Provider=sqloledb;Server=MonsterSQ1;Database=AmiCatSQL;User Id=SA;Password=123456" Set adoCN = CreateObject("ADODB.Connection") adoCN.Open sConnString 'Assumes that you have Field1, Field2 and Field3 in columns A, B and C 'For this …  |
| | I have a string 17:55:88 I want to split this up into the three sections and store them in varibles. IE I would like to have the 88 stored in a varible the 55 in a varible and the 17 in a varible. the following code does what i want, … |
| | Hi All, I have a spash screen on my project, this isn't just for effect but to read data from a file before my main project is started. the issue is that i cant seam to close my splash screen..... here is the code from my splash screen. Private Sub … |
| | I am pulling three coloums of data from a SQL view into my data drid Day,TimeIn,Timeout I want to colour my datagrid rows red if timeout is null and green if both the timein, timeout have data in them. here is my code so far, but it aint working Public … |
| | I have an application that needs to know how many excel rows are in a worksheet before they are imported into my application. at the moment I am asking the end user to enter this into a text box, but would like my application to do this can anyone suggest … |
| | I have an issue with some new code that I am trying to thread, I am using the code below to start my thred [CODE] Dim t As Thread t = New Thread(AddressOf Me.Main) t.Start() Panel2.Visible = False [/CODE] in my me.main I have a counter using a var, if …  |
| | I have the following code that works fine, it opens and excel file and uploads it into SQL. these excel files can have over 120 thousand records. I would like to put a progress bar on the upload so the end user knows how long the upload will take. The … |
| | can anyone please help me with my update statement, i am trying to update a row within a access 2007 database here is my code. [CODE] Dim con As New OleDb.OleDbConnection Dim cmd As New OleDb.OleDbCommand Try con.ConnectionString = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" & Database & ";Persist Security Info=False" con.Open() cmd.Connection = …  |
| | i am having issues with an update query. i normally use SQL 2005 but for this project i am using an access 2007 database please can anyone point me in the right direction, [CODE] Dim con As New OleDb.OleDbConnection Dim cmd As New OleDb.OleDbCommand Try con.ConnectionString = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" & … |
| | can anyone help me add a title to a graph? the code i run to create the graph is [CODE][B]Dim strConn As String = connectionstring Dim conn As New SqlConnection(strConn) Dim sqlProducts As String = "SELECT * from VW_OEEBrakeDowns_ByYear where Year ='" & Me.lbyear.Text & "' and LineNumber =" & … |
| | can someone help a newbie with .net the code i have is working fine to pass one parameter to crystal, can someone help me pass a second parameter called "line"? [CODE]Imports System.Windows.Forms Imports System.Data.SqlClient Imports OEE_NEW.Module1 Imports System.Data Imports System.IO Imports System.Data.SqlTypes Imports System.Windows.Forms.DataVisualization.Charting Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.ReportSource Imports CrystalDecisions.Shared … |
| | i have a calculation and the results are outputting like so 96.5471447543161 i would like to format this text box to only show 96.54 (no rounding) below is the code i am using. [CODE] Dim d1 As Double = Nothing d1 = ((Val(Me.txtgoodsout.Text) + (Val(Me.txtnrft.Text))) / Val(Me.txtrawin.Text)) * 100 Me.txtyield.Text …  |
| | i have a datagrid and want to format the cell background colours which is working fine. as you can see if the value of the cell is > 95 the cell goes green if the cell value is < 90 the cell goes red. i need help with anything between … |
| | Can someone please tell me what i am doing wrong with this code. I have created a dataset and want to push that data into crystal reports. [CODE] Dim rpt As New CrystalReport1() 'The report you created. Dim myConnection As SqlConnection Dim MyCommand As New SqlCommand() Dim myDA As New …  |
| | I am doing some calculations and the outcome of those sums are like 0.743449889958 the sum is calulated like so textbox.Text = (textbox1 * _Units) / _priceincur how would i format the string so that it only shows 0.7434 (rounded)  |
| | afternoon all hope someone can help, i want to populate a report and print it directly without the user hitting the print button. i have this working in a diffrent project but for some reason it wont work in this one. i get the error missing parameter, on the last … |
| | I have a view with two tables and three fields tables are called SC011000 and SC33013 the fields are called SC01049 and SC33013 both are datetime fields. I want to make the third field show the biggest date. but i am doing something wrong I am typing in case when …  |
| | i have a private sub that reads 4 lines of data from a text file, and then uses whats read and stores them in varibles. see below [CODE] Dim FileName As String = configfileV Dim TextFromTheFile As String ' Whole text Dim Lines() As String ' File splitted to lines … |
| | i am trying to create a dataset for use with crystal reports. i have a dataset called dataset.xsd with two tables BatchHeader and BatchDetail these have a relationship of BatchID on both tables. (see picture1) I have this working when there is only one table in the dataset with this …  |
| | i have the following code [CODE] Dim i As Integer i = Me.GridDomains.CurrentRow.Index Me.lbdomainid.Text = GridDomains.Item(0, i).Value [/CODE] when i have complied it in visual studio 2010 (debug) i get a error saying system.data.sqlclient.sqlexceptions conversion faild when converting varchar value LBdomainID to data type int. in sql the datatype is … |
| | I am trying to create a view and by linking two tables together, VLP_QC_Results_Batch1000 and VLP_Stock_QC1000. (see below pics) The issue I have is in the VLP_QC_Results_Batch1000 has the testNo within a field called TestNoName and is separated by a “-“ I need to link these so that we can … |
| | anyone help with this? I have a unique id on each line of sql, i want to be able to update a row from a table i tested and tested this but unable to get this working. does anyone know how i am able to do this? [CODE] Dim PINV … |
| | afternoon everyone, I am new to using MSSQL and need help with SUBSTRING function. i have a strings like below s2-Total Solids - Std Method V1E-RVT4/2.5@20degC Initial V1Y-LVT2/60@20deg Initial A2-Alkalinity - ISO Method(%) I would like to only get the data before the first "-" IE s2 V1E V1Y A2 … |
| | i have the following code which works fine where there is data in the table. when the table is empty and there is no data in the @Ctotal varible i get my error MessageBox.Show("Unable to get Claim Total") is there anyway i can ignore this if there isn't a value … |
| | i have a very simple S/P called ClaimTotal [CODE]CREATE PROCEDURE ClaimTotal @Result varchar(50) OUTPUT as select sum(total) as Ctotal from claim[/CODE] i am struggling to get the Ctotal saved into the @result so that i can then pull this into my .net program. if anyone could help that would be … |
| | i am trying to write a SP that will return a value in vb.net here is my SP CREATE PROCEDURE ClaimTotal @Ctotal BIGINT output AS select SUM(total) from claim where @ctotal = total I want to SUM my total coloum from my table claim, and store this in a varible …  |
The End.