Visual Basic

Tom Deketelaere23-Jul-07 4:51

23-Jul-07 4:51

just search on this site after "outlook bar" and you'll find an endless amount of examples
here are a few to get you started:

http://www.codeproject.com/wtl/atloutlookbar.asp[^]

http://www.codeproject.com/cs/menu/CheatsOutlookBar.asp[^]

http://www.codeproject.com/useritems/wtloutbar.asp[^]

http://www.codeproject.com/useritems/smartclientoutlookbar.asp[^]

http://www.codeproject.com/cs/miscctrl/csoutlookbar.asp[^]

http://www.codeproject.com/cs/menu/BarTender.asp[^]

something went wrong with the pasting solved it now

Tom Wright23-Jul-07 4:53

Tom Wright

23-Jul-07 4:53

Aren't these for the bar? I'm looking for the Calendar.

Tom Wright
tawright915@gmail.com

Tom Deketelaere23-Jul-07 4:58

23-Jul-07 4:58

I thought one of the links above did that don't know wich one Sigh | :sigh:

and I think I have some code for it at home I'll take a look when I get home (in about 1 hour)

Winspool.drv - set advanced printer properties

Tom Wright23-Jul-07 5:00

Tom Wright

23-Jul-07 5:00

Man that would be awesome. I'll check out the links.

Thanks

Tom Wright
tawright915@gmail.com

dBrong23-Jul-07 4:20

dBrong

23-Jul-07 4:20

Can Winspool.drv be used to permanently set printer properties?

Or do you know of any third party libs that I can use?

Re: Winspool.drv - set advanced printer properties

Dave Kreskowiak23-Jul-07 4:33

Dave Kreskowiak

23-Jul-07 4:33

You can use WinSpool.drv to do this. The documentation is here[^]. The only requirement is you must have a complete understanding of the Windows Printing subsystem in order to use it.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: Winspool.drv - set advanced printer properties

dBrong23-Jul-07 8:09

dBrong

23-Jul-07 8:09

I was looking into this as a way to automatically setup the Microsoft Office Document Imaging printer. Like selecting .tif's and the default print folder.

I've run into several issues like this where you can just about reach it - but you gotta have a lot of time.

Thanks for the link anyway!

read paradox file(.DB)

jds120723-Jul-07 3:26

jds1207

23-Jul-07 3:26

I am writing an application in vb.net 2005 to read, update, and insert data to paradox database file(.db). When I try to connect I get this error: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Here is my code:

Dim connectionstring As String = "Driver={Microsoft Paradox Driver(*.db )};DriverID=538;Fil=Paradox 5.X;DefaultDir=C:\Data Feeds\;Dbq=C:\Data Feeds\;CollatingSequence=ASCII"<br />
<br />
        Dim querystring As String = "SELECT * FROM PriceBooks.DB"<br />
        Dim tableName As String = "PriceBooks.DB"<br />
<br />
        Dim dataSet As DataSet = New DataSet<br />
<br />
        Using connection As New Odbc.OdbcConnection(connectionstring)<br />
            Dim adapter As New OdbcDataAdapter()<br />
            adapter.SelectCommand = New OdbcCommand(querystring, connection)<br />
            Dim builder As OdbcCommandBuilder = New OdbcCommandBuilder(adapter)<br />
<br />
<br />
            connection.Open()<br />
            adapter.Fill(dataSet, tableName)<br />
<br />
            adapter.Update(dataSet, tableName)<br />
            Me.DataGridView1.DataSource = dataSet<br />
            Me.DataGridView1.DataMember = "PriceBooks.DB"<br />
        End Using

Any ideas on what the problem might be?

jds1207

Re: read paradox file(.DB)

Dave Kreskowiak23-Jul-07 4:38

Dave Kreskowiak

23-Jul-07 4:38

You might want to tell us on which line the error occurs and you also want to get rid of the ".db" after Pricebooks:

Dim querystring As String = "SELECT * FROM Pricebooks"

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: read paradox file(.DB)

jds120723-Jul-07 4:55

jds1207

23-Jul-07 4:55

The error occurs on this line:

connection.Open()

Re: read paradox file(.DB)

Dave Kreskowiak23-Jul-07 5:56

Dave Kreskowiak

23-Jul-07 5:56

Perhaps the machine doesn't have the Paradox driver installed?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Adding drop shadows to controls

Ahmad Zaidi23-Jul-07 0:58

Ahmad Zaidi

23-Jul-07 0:58

Hi,

I have made an irregularly shaped control to which I want to add a drop shadow (like the one XP menus and the mouse cursor have). Is there any way to do this?

Thanks,
Ahmad

Re: Adding drop shadows to controls

Tom Deketelaere23-Jul-07 1:32

23-Jul-07 1:32

one way to do this (a bit clumsy dough) is just to duplicate the control put its color a bit darker (or total dark depending on what you want) and then put it behind the other control.

there's probably a beter way to do this but this is one way

perhaps an other way would be to create a usercontrol and draw the whole thing yourself
(put the region of the uc to the irregularly shaped path)
down side with this is that when users click the drop shadow it will fire the click event of the uc (but it is a bit less clumpsy then methode 1)

sql query

Sonia Gupta22-Jul-07 23:52

Sonia Gupta

22-Jul-07 23:52

there is a problem in sql query.
there are following records of integer type in the table

2
3
4
5
6
7
8

in a paticular case i am getting fourth record i'e 5
now i want it's previous record i'e 4.
is it possible by the query.o i need to implement it progamatically.

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

mehul.pandya23-Jul-07 1:08

mehul.pandya

23-Jul-07 1:08

can u explain in brief ur question.

Exactly what do u want pls explain in brief.

originSH23-Jul-07 1:16

originSH

23-Jul-07 1:16

She wants the previous record of a given record by ID.

i.e. if you have rows

1
3
5
7

and the given row was 7, she wants row 5.

andyharman23-Jul-07 1:26

andyharman

23-Jul-07 1:26

Hi Sonia

To get the previous record:

select * from MyTable where ID in (select max(ID) from MyTable where ID < 5)

For the next record:

select * from MyTable where ID in (select min(ID) from MyTable where ID > 5)

Regards
Andy

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".

GuyThiebaut23-Jul-07 2:24

GuyThiebaut

23-Jul-07 2:24

Neat code - You have bypassed using group by and used subqueries instead and I wonder if this is more expensive CPU-wise than group by?
Do you know if this is the case?
I realise using group by would create more code.

Yours - trying not to be too nerdy

Guy

You always pass failure on the way to success.

andyharman23-Jul-07 5:52

andyharman

23-Jul-07 5:52

Depending on the indexes available, SQL-Server would normally resolve the sub-query straight from an index. Then do a (probably clustered) index lookup to obtain the single resulting row.

How would you do this using a "group by" clause? I can't think of any way that would be as efficient as using a sub-query in the particular case.

GuyThiebaut23-Jul-07 22:55

GuyThiebaut

23-Jul-07 22:55

Hats off to you I could not manage to code this with an aggregate query.

Guy

You always pass failure on the way to success.

text file to html

Sebastian T Xavier22-Jul-07 23:22

Sebastian T Xavier

22-Jul-07 23:22

Hi all,

How can i convert my text file(sample.txt) to html format....

any suggestions will be appreciated...........

thanks in advance............

sebastian

Re: text file to html

Tom Deketelaere22-Jul-07 23:29