MAPI Message problem - Visual Basic Discussion Boards

Re: regarding excel sheet generation in vb.net

usernamess19-Dec-05 3:46

19-Dec-05 3:46

hello, so let me get this straight, you are using datagrid and you want to create excel file from that. Or you want to create from webform.

Here are links from internet.

http://support.microsoft.com/default.aspx?scid=kb;en-us;317719

http://geekswithblogs.net/azamsharp/archive/2005/08/05/49291.asp

let me know if you need more help

thx

Printing problem in VB.net

HemaRawat19-Dec-05 0:17

HemaRawat

19-Dec-05 0:17

Hey All

I am Stuck in a problem

I have an application that generates the Barcode

When I am printing that with the laser printer , Then That printed barcode is readble through the Scanner

But when I am printing it with the Label Printer(USed to print small badge cards, Address labels etc.) then that printed barcode (printed by label printer) is not readable by the barcode scanner

Can you give me the direction Why is it so.

Thanks for this help

Hema Chaudhry

Re: Printing problem in VB.net

Duncan Edwards Jones19-Dec-05 0:25

Duncan Edwards Jones

19-Dec-05 0:25

Does it look different to the human eye? (stretched, etc.)

If not then your ink may not be compatible - i.e. the scanner has a single light wavelength and maybe the difference between bars and spaces in your ink in that wavelength is not sufficient.

'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd

Re: Printing problem in VB.net (Urgent)

HemaRawat19-Dec-05 0:31

HemaRawat

19-Dec-05 0:31

Thanks for this prompt reply(really your answer is urgent for me)
I can't understand what is problem

That Printer also has a software that also generates sample Barcodes
& those printed barcodes (By label printer) are readable by that scanner

But the barcodes generated by my application & printed by label printer is not readable by that scanner.

But the barcodes generated by my application & printed by Laser printer is readable by that scanner.
That's why I am not getting the actual problem
what it is????

thanks & regards

Hema Chaudhry

Re: Printing problem in VB.net (Urgent)

Dave Kreskowiak19-Dec-05 7:27

Dave Kreskowiak

19-Dec-05 7:27

If your barcode is getting streched left and right (I'm assuming a Code 39 or 128 barcode or something similar here) at all, then it won't read properly. Print a sample barcode on the printer that prints the working barcode and on the card printer (exact same barcode!) and measure the two. The length of the barcode should match exactly. If not, there's your problem.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Printing problem in VB.net (Urgent)

HemaRawat19-Dec-05 17:26

HemaRawat

19-Dec-05 17:26

Yes I am using the Code 128 B BarCode symbology .

And also ,The Barcode printed by Label printer are somewhat different from the barcode printed by the laser printer.

That's why my scanner reads the barcode printed by the laser printer
but can't read the barcode printed by the label printer.

Now , I can't understand with what the exact problem is :
1. with barcode
2. With Label printer.
3. or Sacnner

Although all three are working properly individually.

Plz repy me as soon as possible for You

Thanks a bunch in advance.

Hema Chaudhry

Re: Printing problem in VB.net (Urgent)

Dave Kreskowiak20-Dec-05 2:42

Dave Kreskowiak

20-Dec-05 2:42

HemaRawat wrote:
The Barcode printed by Label printer are somewhat different from the barcode printed by the laser printer.

There's your problem, although you don't say what's different about it. Because of this, no-one can really help you with anything.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

MAPI Message problem

Anant_Radadia18-Dec-05 23:38

Anant_Radadia

18-Dec-05 23:38

I am Looking for filtering messages with redemption.mapitable....

Set Restr1 = Restr.Add(RES_PROPERTY)
Restr1.relop = RELOP_GE
Restr1.ulPropTag = PR_DELIVER_TIME
Restr1.lpProp = CDate("11/27/2005 11:00 AM")
Filter.Restrict

I am doing like above but filter done with date not time. Is there any help regarding this ???

anu_s2002@yahoo.com

How to create shortcut key in vb.net toolbar

chewmp18-Dec-05 23:07

chewmp

18-Dec-05 23:07

i had use toolbar to create a button on my form..but dunno how to set the shortcut key..for eg..the open file is ctrl + O, i create a edit file..but dunno where to set the Ctrl + E as edit the file..anyone got answer..please help..thank you.. i am using vb.net 2003..

Re: How to create shortcut key in vb.net toolbar

vertig073019-Dec-05 1:17

vertig0730

19-Dec-05 1:17

You need a MainMenu. It is a function of the Menu control

1. Out of clutter, find simplicity.
2. From discord, find harmony.
3. In the middle of difficulty lies opportunity.

Albert Einstein
three rules of work

retrive data from Database in table form

vmadhan18-Dec-05 20:34

vmadhan

18-Dec-05 20:34

Hello All,

Retrive particular data from MSAccess Data base using Visual Basic as front end. The data retrived should be in Table form and it should be enable copy that data and paste it in the same form (ie table form) in any of the applications such as word etc.

Please some help me out Frown | :(

(

Re: retrive data from Database in table form

jcrussell18-Dec-05 20:38

jcrussell

18-Dec-05 20:38

what part are you having problems with? Sniff | :^)

getting the data from MS Access.
Displaying the data in VB(.NET?)
Copy and Paste of Data

and what language are you using VB6 or VB.NET.

/jason

Re: retrive data from Database in table form

J4amieC19-Dec-05 3:49

J4amieC

19-Dec-05 3:49

4. Doing your own homework?

Wink | ;)

I dont think anyone minds helping people out with homework, but simply copying and pasting the assignment into a forum does not really constitute learning.

Re: retrive data from Database in table form

jcrussell19-Dec-05 12:41

jcrussell

19-Dec-05 12:41

i find it shocking that they are still using MS Access for homework though. I barely remember when I last connected to an Access backend.

/jason

Experts! help in scaling the images in vb.net

JUNEYT18-Dec-05 12:24

JUNEYT

18-Dec-05 12:24

Hello!

How could I scale all the images under one specific directory according to my (Width = 433 x Height = 566) white image template? Moreover, I should be resizing all the images according to aspect ratio.

If you help me to figure out, I would really apreciate it!

Thank You.

Bedri.
bckurd@e-kolay.net

Sample code

lijocm19-Dec-05 2:04

lijocm

19-Dec-05 2:04

Sir
I request you to sent me sample code of prime number, factorial, even and odd numbers in VB.Net/ASP.Net for an interview.

Regards
Lijo

Re: Sample code

toxcct19-Dec-05 2:20

toxcct

19-Dec-05 2:20

what's that crap ????

if you cannot answer a question, don't spam the forum, especially when it is your second message on the forum, and when the 1st one was not that better... Mad | :mad:

people on CodeProject help because they want to ; no one owe nothing to anyone here, so if you're not satisfied, get out of here. Suspicious | :suss:

TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VisualCalc 3.0]

Re: Sample code

Dave Kreskowiak19-Dec-05 7:22

Dave Kreskowiak

19-Dec-05 7:22

For a what?? An interview? You want source code sent to you so you can answer question about it during an interview?

Guy, if you can't write simple algorithm like this yourself, don't even bother going to the interview! You'll embarass yourself.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Sample code

jonathan1520-Dec-05 2:37

jonathan15

20-Dec-05 2:37

Tosser.

Parametrized query on related tables - VB.NET2003

liquid_18-Dec-05 9:15

liquid_

18-Dec-05 9:15

The problem is how to make use of relation between tables when I try to use parametrized query on the master table.
The code is like this:
1. Created data adapters
SqlDataAdapter1 - for first table, eg. PurchaseOrders with primary key PONum
SqlDataAdapter2 - for second table, eg. PurchaseOrderItems with primary key of two fields PONum<->POItemNum
2. Created data set
DataSet11 - for two related tables (one-to-many relation), joined by the key PONum
3. Filled the data set of data grid

SqlDataAdapter1.Fill(Me.DataSet11)<br />
SqlDataAdapter2.Fill(Me.DataSet11)

Then when I do not use the parametrized query the filling is done without errors. But when I modify SQL command of the SqlDataAdapter1 to use WHERE clause with parameter (eg. PO date) I get the error message. It cannot enforce constraints.

How to overcome this problem?

-- modified at 16:38 Monday 19th December, 2005

Problem with the coding..(VB6)

mellvincent18-Dec-05 5:16

mellvincent

18-Dec-05 5:16

The coding shown below is my coding to select the largest integer in 'Inventno' field which have the same 'productCode'. say, I have 3 same items in the 'productCode' field but all of them have a different inventory number. my intention is to display the largest integer of a selected product code. the problem is there is nothing happen when i execute the coding n I dont know what went wrong. Confused | :confused:

Private Sub Command6_Click()<br />
Dim strSQL As String<br />
Dim conn As ADODB.Connection<br />
Dim rs As ADODB.Recordset<br />
<br />
    Set conn = New ADODB.Connection<br />
    Set rs = New ADODB.Recordset<br />
    <br />
    conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\User\Desktop\IS\ISDB.mdb; Persist Security Info=False"<br />
<br />
    conn.Mode = adModeRead<br />
        conn.Open<br />
    <br />
    strSQL = "SELECT MAX(inventno) FROM IncomingStk WHERE ProductCode= '"&code.Text&"'"<br />
<br />
    rs.Open (strSQL), conn<br />
    conn.Close<br />
     DataGrid1.Text = rs(0).Value<br />
    <br />
    Set rs = Nothing<br />
    Set conn = Nothing<br />
    <br />
End Sub

-- modified at 11:20 Sunday 18th December, 2005

Re: Problem with the coding..(VB6)

KaptinKrunch19-Dec-05 2:36

KaptinKrunch

19-Dec-05 2:36

Does the database table for ProductCode define that field as an int. if so, remove the single quote marks from you sql entry.

like:
strSQL = "SELECT MAX(inventno) FROM IncomingStk WHERE ProductCode =" & code.Text

also the way the your getting the value rs(0).value is not valid.
Should be

label.text = rs.Tables(0).Rows(0)(0).ToString().
This produces the value of row 1 col 1.

Re: Problem with the coding..(VB6)

S Douglas19-Dec-05 22:17

S Douglas

19-Dec-05 22:17

KaptinKrunch wrote:
also the way the your getting the value rs(0).value is not valid.

Naw, this is vb6, rs(0).value is the equivalent of saying
rs.fields(0).value
Smile | :)

ZeePain! wrote:
This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.

thedailywtf.com[^]

Re: Problem with the coding..(VB6)

S Douglas19-Dec-05 22:15

S Douglas

19-Dec-05 22:15

Well if I had to guess, then I would probably say your WHERE Clause is filtering out all of the results, so your getting a recordset with no records.

Also I just wanted to point out that while you close your data connection you forgot to close the recordset before setting it to nothing.

mellvincent wrote:
DataGrid1.Text = rs(0).Value

Doesn't this set the data grids header text to that value (I don’t really remember)? Have you tried setting the text to a col - row first.

Or Set DataGrid1.DataSource = rs should also get the same results.

Hope this helps...

ZeePain! wrote:
This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.

thedailywtf.com[^]

Getting started (beginner)

mellvincent18-Dec-05 3:46

mellvincent

18-Dec-05 3:46

Hi all,

I'd like to do a PDA programming in VB.NET. The Q is:

1. Is there any website where I can find details on PDA programming-from scratch (details of what software to be used, the installation, etc )?

TQ

-- modified at 10:30 Sunday 18th December, 2005

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.