David Gluth
Last Activity: Aug 9 '11, 04:34 PM
Joined: Oct 6 '10
Location:
-
I think that it will return new object ret_obj after each call. I have used this functions like this with simple bjects (string) and I allways get new object. -
You copied a FillRectangleRe ctangle from a place that tried to use it as an event andeler (byval e as ...Eventargs). All you need to do is call the graphic method.
...Code:Private Sub PictureBox1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PictureBox1.Click Dim i As Integer Dim pt As Point Label1.Text = "X=" & MousePosition.X & " Y=" &Leave a comment:
-
You may be right, I don't remember. You can still do a sperate thread but it is more difficult. I don't know of any way that your primary program can continue to execute while the call to the DLL function processes.Leave a comment:
-
Try using a backgroudnworke rLeave a comment:
-
Try this
...Code:Dim mainform As New DBexit Select Case mainform.ShowDialog Case Is = Windows.Forms.DialogResult.Yes ' do yes option Case Is = Windows.Forms.DialogResult.No 'do no option Case Is = Windows.Forms.DialogResult.Cancel ' do cancel option Case ElseLeave a comment:
-
Hi GR,
First if you are only trying to summarize, not actually remove the duplicate rows then you can do it easier in SQL.
This querywill give you one row for each unique product name item pack combination and sum them for you.Code:Select product_name , item_pack, SUM(available_qty) AS QTY from warehouse_master GROUP BY product_name, item_pack order by serial_no"
If you really need to purge them for...Leave a comment:
-
Try posting you question in the SQL section for SQL specialist to see.
I would create a user that only your application will use. Grant appropriate access (datareader, datawriter) to that user to the application database only. This will limit the access that the application has.Leave a comment:
-
try changing lline 41 to use % filters. In SQL the way you have have coded the 'like' it would act like'='.
Code:dv.RowFilter = "estno like = %" & cbostr & "%"
Leave a comment:
-
You have set yourself a large and fun task. I have participated in a conversion like this once.
First convert your access program to use the SQL database. This will be the easiest task as most all of your queries will work and all you have to do is change your connection strings.
VB includes a version of Crystal reports. It is a good report writing tool, though not the same as access. When I did this project I...Leave a comment:
-
Sure you are,
Public xxx as date is a declaration (Public means that other forms can see and use it)
Dim xxx as date is a declaration (Dim means that only the procedure that it is in can see it)
The two statements that I gave you before declare the variable for you to use.
" Public payPeriodStartD ate As Date = Nothing"
" Public payPeriodEndDat e As Date = Nothing"
...Leave a comment:
-
I may have keyed it wrong for you -
Variables as defined
Public payrollstartdat e As Date = Nothing
Public payrollenddate As Date = Nothing
Variables you are setting
payPeriodStartD ate = oDr.GetDateTime (1)
payPeriodEndDat e = payPeriodStartD ate.AddDays(7)
These are different variable names
Change the declarations to match the ones you useLeave a comment:
-
Your Dim at the top of main won’t work. You can’t set the value to a SQL reader value before you open the reader.
Declare them as public and they will be available to other classes within your application.
Code:Dim payPeriodStartDate = oDr.GetDateTime(1) S/B public payPeriodStartDate as Date = nothing Dim payPeriodEndDate = payPeriodStartDate.AddDays(7) S/B public payPeriodEndDate as Date =nothing
Leave a comment:
-
Sorry I don’t think I can be of much help on those issues. You should research Crystal Reports. They used to have a large knowledge base online. Their issues with the merge modules and licensing were very troublesome.
My problems with it were resolved in VS 2005 and now VS 2008.Leave a comment:
-
Go to your applications property page.
Select Settings.
Give it a name, select connection string and enter you connection sting as the value. When you save the application it will be added to app config for you.
I would end the string at accdb; the in code append “User ID=Admin; Password=xxx” to the end of myCNLeave a comment:
-
David Gluth replied to How can I store and retrieve image in sql server2005, without storing image location?in .NETUse FileStream (System.Io) to convert the image to binary. Store it in SQL using Blob format. Google FileStream and SQL Blob you’ll get there.Leave a comment:
-
There really isn’t enough information here to figure out what is supposed to be happening.
VB event basics:
Declare an event: - [from your error message it looks like this is in there somewhere
Raise an event: - [I think this is probably somewhere in your code as well]Code:Public Event Complete(byVal sender as Object,ByVal e as System.EventArgs)
The line...Code:RaiseEvent Complete(me,args)
Leave a comment:
-
I am not familiar with the web site you are querying so don't know the difference between the two msft references that I see in your code, however to include X this is how you would do it:
"URL;http://finance.yahoo.com/q?s=msft", Destination:=Ra nge("F27"))
.Name = "q?s=msft_1"
"URL;http://finance.yahoo.c om/q?s=" & X, Destination:=Ra nge("F27"))
.Name...Leave a comment:
-
What method did you use to 'deploy'?
1. Did you simply copy the bin\release folder to your CD?
You will have to go to the crystal reports web site on your laptop and install the crystal report runtime. Look at you program (Visual Studio Help / About) to determine what version of crystal runtime you need. With VS 2003 it was either 8 or 9 I don't remember.
2. Did you build a setup project?
...Leave a comment:
-
You have to install the Crystal Reports runtime (it's free) on the laptap or you can deploy the crystal report runtime with your application - google crystal runtime for more infoLeave a comment:
-
I played around with the info you gave and don’t see the problem, but then my implementation of your control is not producing the line me.UCDx1.Contro lDataSoruce = nothing. Obviously I am missing some of your code. Did you implement daSet as New Dataset?
Hope you get it figured out.Leave a comment:
No activity results to display
Leave a comment: