Mike Bishop

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 …

I have a problem that my crystal report shows the decimal values as 00 every thing is fine but it does not display proper value e.g. If i have 0.235 it shows 0.000 If i have 2.356 it shows 2.000 Whats the matter behind it the database field is text …

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 …

Dear all, I wanted to fill the combo box with the data from my SQL server database. There are two column in the table, product_id and product_name. for example: product_id| product_name ---------- -------------- 1| pencil 2| NoteBook I was successful in displaying the product name in combo box. The code …

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 …

Hi there. I am making an application in VB.Net. In which i am scanning some system folders and on the execution time it gives me the error; E.g, access to the path "C:\any system file" is denied. Is there any code you people have that is edited in to the …

I need help. I just finished with the c++ tutorial on learning c++ syntax. So my question is what do I do next. I wanna learn

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 …

Hi all, I just came up with a little problem.I used crystal reports for my reporting. And i used five tables for the report.I've used SQL statement to select the records that i want. But crystal reports displays each record (selected by the sql) on a different page which makes …

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 …

Hello everyone, am doing a small project and i need to use crystal report with MS access. i did the connection by wizard but now am having problem with the path when using it on another PC. What i need to know is how to connect Crystal report with access …

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 …