Visual Basic

Re: Problem accessing Resourses and Settings in visual studio 2008

7-Jul-10 2:51

I have no idea. I've never heard of the problem before. I can't even replicate it...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Аslam Iqbal7-Jul-10 4:28

Аslam Iqbal

7-Jul-10 4:28

This is twice in my life. anyway thanks.
I solved that creating a new project and add old forms and classes and all other components.
I have no other choice.

Communication with Finger Print Machine [modified]

εїзεїзεїз6-Jul-10 21:49

εїзεїзεїз

6-Jul-10 21:49

I want to communicate with a Finger Print Machine but no SDK /APIS is provided by the client bcz vendor wants to sell SDK separately , its Pinging but how i can send and receive data without having any SDK or manual.

Is there any way that i can communicate with any machine and can send and receive thumb impressions without having any SDK or manual.

If so then is not it like developing a VIRUS/Trojan or something. Mad | :mad:

SOFTDEV

Luck in life always exists in the form of an abstract class that cannot be instantiated directly and needs to be inherited by hard work and dedication.

modified on Wednesday, July 7, 2010 7:45 AM

Steven J Jowett7-Jul-10 0:41

Steven J Jowett

7-Jul-10 0:41

You need to speak to the manufacturer or distributor of the device.

Steve Jowett
-------------------------
Real programmers don't use PL/1. PL/1 is for insecure momma's boys who can't choose between COBOL and Fortran.

Dave Kreskowiak7-Jul-10 1:26

7-Jul-10 1:26

You'll have to contact the manufacturer of the device for the SDK. There is no getting around this.

Also, where did you get this thing from? Every fingerprint scanner I've seen always came with a copy of it's SDK.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

εїзεїзεїз7-Jul-10 1:36

εїзεїзεїз

7-Jul-10 1:36

Actually the Manufacturer is selling SDK separately three times more then the Price of the Machine and client does not want to pay Frown | :(

SOFTDEV

Luck in life always exists in the form of an abstract class that cannot be instantiated directly and needs to be inherited by hard work and dedication.

Dave Kreskowiak7-Jul-10 2:49

How find unmanaged dll methods?

7-Jul-10 2:49

Then client doesn't get their solution, now do they?

The manufacturer has you over a barrel. You can try a third party library, but you're not going to get the full functionality of the scanner. You can find some by Googling for "fingerprint sdk free[^]".

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Sonhospa6-Jul-10 1:13

Sonhospa

6-Jul-10 1:13

Hi everybody,

I'd like to make a little application to handle 3rd party gauges. These are basically C/C++ dlls, so it seems that I have to find out their entry points and members first. One major thing would be to simply show the bitmaps, which they provide for the GUI in the game (MSFS), inside my application.

Does anyone know a way how to do something like retrieving member and resource information from an unknown dll in VB.NET (or C#)?

Thank you
Michael

ddecoy6-Jul-10 1:33

ddecoy

6-Jul-10 1:33

depends.exe
oleview.exe

Sonhospa6-Jul-10 2:38

Sonhospa

6-Jul-10 2:38

Thank you, I'll go google for these tools.

Dave Kreskowiak6-Jul-10 1:48

6-Jul-10 1:48

For the uninitiated, that's Dependancy Walker[^].

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Excel to XML Conversion using VBA

Sonhospa6-Jul-10 2:30

Sonhospa

6-Jul-10 2:30

This seems to be a really cool tool for the initiated Wink | ;)

... giving me what I asked for and showing me how far I am from "making a little application" with display support.

At least the dlls in question obviously don't expose any bitmaps, but only "ImportTable" and "Linkage" functions which both belong to a world of C-language and the 7 seals...

Thank you still!

priyaahh5-Jul-10 18:55

priyaahh

5-Jul-10 18:55

Hi Friends,

I wanted to convert excel sheet data to xml using VBA.
Kindly help me.

Thanks in advance.

Regards,
Priya.

Re: Excel to XML Conversion using VBA

_Damian S_5-Jul-10 19:03

_Damian S_

5-Jul-10 19:03

A quick search found this article clickety[^]

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!!

If you like cars, check out the Booger Mobile blog | If you feel generous - make a donation to Camp Quality!!

How can I take the most recent record from a table?

waner michaud5-Jul-10 9:53

Re: How can I take the most recent record from a table?

5-Jul-10 9:53

Hi,

I have this table

Accessories table
(ID, description, date, ArmoryID, ProfileID)

with these records:

1 belt 05/01/2010 1 1
2 hoslter 05/02/2010 2 1
3 charger 05/03/2010 3 1

I need to take the most recent record for profile 1

to have as result: (3 charger 05/03/2010 2 1)

I tried a number of querries, can't seem to get the right answer.

Please guide me through it..

Thanks a lot..

EliottA5-Jul-10 10:51

EliottA

5-Jul-10 10:51

Select count(*) from Accessories, the result is 3, then select * from Accessories where ID = result

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

Re: How can I take the most recent record from a table?

waner michaud5-Jul-10 11:20

Re: How can I take the most recent record from a table? [modified]

5-Jul-10 11:20

Hi thanks, but we will not know what the result is..
One profiler can have more than one accessories as of in history archive.
but to check to see if a profiler has an accessorie, it should load based on the most recent date since we can have more than one accessories entries for one profiler.

Hope a bit clearer now.

thanks a lot

Dr.Walt Fair, PE5-Jul-10 11:18

Dr.Walt Fair, PE

5-Jul-10 11:18

SELECT * FROM Accessories ORDER BY date DESC;, then use the first returned record.

By the way, using "date" for a column name is a very bad idea, since it is a reserved word for a data type in most SQL dialects. I always use "order_date" or some other variation to make sure the SQL engine doesn't think you are using a reserved word. Sooner or later that problem will bite you.

CQ de W5ALT

Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software

modified on Monday, July 5, 2010 5:24 PM

Re: How can I take the most recent record from a table?

waner michaud5-Jul-10 11:31

Re: How can I take the most recent record from a table?

5-Jul-10 11:31

Hi,
Thanks.

I have used a variation for date..again thaks for the info..
I thought of doing it this way..wasn't sure if it was the right approaoch..

thanks..

Dave Kreskowiak5-Jul-10 18:16

Re: How can I take the most recent record from a table?

5-Jul-10 18:16

Instead of returning the entire ordered set, how about returning SELECT TOP 1 ... ORDER BY date DESC instead?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Dr.Walt Fair, PE6-Jul-10 3:55

Dr.Walt Fair, PE

6-Jul-10 3:55

Yes, you're right. When I need to do that, I usually end up needing more info, so I usually just get the whole set, but if he really needs just 1 and only 1, selecting TOP 1 is the way to go.

CQ de W5ALT

Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software

Re: How can I take the most recent record from a table?

riced6-Jul-10 6:47

riced

6-Jul-10 6:47

Question: Is it possible to have two (or more) entries with the same date?
If so, then sorting on date descending and selecting first one (e.g. by using top) is not guaranteed to get you the most recent entry.
If the ID field is autogenerated then perhaps the max of that is a better candidate?

Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
The only valid measurement of code quality: WTFs/minute.

Re: How can I take the most recent record from a table?

waner michaud6-Jul-10 7:06