Okay. Now I'm trying something a little different. Instead of using a friend sub routine, I've defined a public property on Form1.
Public Property GetPNumbers() As Object
Get
Return Me.strPNumbers
End Get
Set(ByVal Value As Object)
Me.strPNumbers = Value
End Set
End Property
Form3 calls to...
Alright,
Here is the situation: I have a main form (Form1 (Yes, I know the naming convention for the forms are horrible.)). This Form has two fields filled out and once those fields are filled by the user, the main form makes a call to another form (Form3). This form has several text boxes...
First, that's an interesting way of dealing with the datatype. I hadn't thought of that. Cool idea.
Second, that story made me laugh. That's hysterical. You better get your friend up to date. Who knows where else your friend might be thinking the computer will understand implicitly what to...
Whole Issue Resolved!
David,
Thank you very much for your help with this problem. You were very awesome sticking with me through all of my silly questions and issues.
I have been able to take care of everything that related to this problem now. I did a lot of the formatting manually in the...
I actually got it fixed. I don't know how. This is what my code looks like now:
Dim crMargins As New CrystalDecisions.Shared.PageMargins(23, 4, 394, 225)
Dim rpt1 As New CrystalReport1
rpt1.SetParameterValue("MfgLotNum", strMfgLotNum)
rpt1.SetParameterValue("MixLotNum", strMixLotNum)...
In the viewer it looks near perfect. And it prints out almost perfectly from the viewer. What does it mean? Why does it not print correctly from the code and the .PrintToPrinter function?
Also, how can I print from the viewer programmatically with no input from the user? This interface I'm...
No matter where I put the text (details, page header, report header), it always prints to the same spot on the label. I did try some test text in Word and when I scaled the paper size down to the correct size, everything worked just fine. Text showed up where it should and everything.
It seems...
Resolved!
This issue has been resolved. Initially, my table did not actually possess any rows. When I looked at the table, I only saw the automatically created row with the default value in the table. Once I manually created a new row, everything was fine.
So, that whole Designer->Printer Setup thing. Amazing. I feel really dumb for not using that first. However, my first piece of data is in the Page Header and it still shows up about 3/4 of the way down the label. Why? The margins are now set correctly and the paper size is correct.
And this is what I was testing with Crystal Reports. So far, It prints out the one parameter in landscape format on the label, except the last character is completely cut off and the parameter is about 3/4 down the page (in respect to landscape orientation). I have tried to set my own margins to...
...' Print each line of the file.
While count < linesPerPage
Select Case count
Case 1
line = " " & strMfgLotNum & " "
yPos = topMargin + count * myLargeFont.GetHeight(ev.Graphics)
ev.Graphics.DrawString(line, myLargeFont, Brushes.Black, leftMargin, yPos, New StringFormat)
Case 2
line = "Gross "...
...Dim AccessDataSet As New System.Data.DataSet
Me.txtMixLotNum.Text = "000000-000N"
AccessAdapter.SelectCommand = New OleDb.OleDbCommand("SELECT * FROM tbl_HCI_Missing_Lot_Count", AccessConn)
' There should only be one row returned from the .Fill function.
AccessAdapter.Fill(AccessDataSet...
...table in a database with one column and only one row. This table is supposed to stay at the size of one row and one column. When I use the below SELECT statement on this table, I get no rows returned. Why?
"SELECT * FROM tbl_HCI_Missing_Lot_Count"
All suggestions are greatly appreciated. :)
JohnH,
Wait...That's how you define a font?! The information I had found regarding that was so confusing and didn't seem to be applicable to my situation that I couldn't figure it out. Holy cow, John, that is exactly what I was looking for! You took what I had been pouring over yesterday and...
I know, I know. It's only been an hour. But so far, I am curious, can I use Crystal Reports to generate a report based on data in the fields of my form, rather than the data in a database?
Also, when I try to use a wizard to generate a Crystal Report, the table's come out all funny and I can't...
You bring up a good point about the possibility of good data actually screwing with the lost lot data. However, I have hopefully avoided that issue with good data being saved as xxxxxx-xxx-x and the lost lot data being saved as 000000000001 instead. Hopefully anyways. ;) But you are right. If...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.