Visual Basic

Re: VB6 DAO Class Reference [EDITED]

14-Jun-04 18:07

Does anyone know where I might be able to find a good reference that explains all the properties, functions, and classes of the DAO Reference Library? I am trying to learn how to use the Parameter Class and would like to read up on the rest. I have search google multiple times, but can not come with anything. I can't even find a good reference book at B&N. Thanks in advance.

Dave Kreskowiak15-Jun-04 2:38

Re: VB6 DAO Class Reference

15-Jun-04 2:38

That's because DAO has been obsolete for years now. The replacement is ADO inside the Microsoft Data Access Components. Since I can't get to MSDN now (DNS is failing), go to http://msdn.microsoft.com/data[^] and look through the docs there.

[EDIT]
You might also find the docs for DAO in the MSDN Library Archives. Go to http://msdn.microsoft.com/archive/[^] to see if they still have the docs...

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

Mekong River15-Jun-04 4:38

Mekong River

15-Jun-04 4:38

Yes, there a is a little bit difficult for a people who want to learn DAO in the .NET technology era. I would like to recommend you a book, but it might be old for you to learn and it might be difficult to find it in the bookstore. As I remember, try to find the books titled “Programming DAO” published by Microsoft Press. I forgot its author name, but I think this one is the good one. Try to learn VBA books in Access 97 also teach you about DAO technology. If you have MSDN Library January 2000, then there is also a section teaching you to learn DAO Reference. Office Developer documentation also the best place for learning DAO and ADO technology.

Roath Kanel
APO-CEDC
Save Children Norway-Cambodia Office

Re: VB6 DAO Class Reference

xfitr215-Jun-04 5:22

Re: VB6 DAO Class Reference

15-Jun-04 5:22

Thanks for the information. I will try to find those books. I have had a lot more success with DAO over ADO and it seems to run faster, therefore I have been using DAO. I found some information about using the parameter class from Microsoft last night and it helped. I would just like to find a good reference for the whole object library. Thanks guys.

Dave Kreskowiak15-Jun-04 5:33

Icons referenced in resource files

15-Jun-04 5:33

I would still highly recommend you abandon the DAO approach and use ADO/ADO.NET. DAO's final version is 3.6 and will no longer be available on any future version of Windows, nor will there be any updates, other than security, to functionality.

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

Le centriste14-Jun-04 10:18

Le centriste

14-Jun-04 10:18

Hello

In BizTalk, when adding an object, you may have an icon associated with it (.bmp). The catch is that this image can only be loaded into the corresponding object this way:

BaseFunctoid.SetBitmap("IDB_SOME_IMAGE_RESOURCE")

How do I put a bitmap into a resource file (it seems to be in base64)

Thank you

Michel

--------

"I say no to drugs, but they don't listen."
- Marilyn Manson

Re: Icons referenced in resource files

xfitr214-Jun-04 18:01

Setting Permissions Programatically

14-Jun-04 18:01

Try this website.

I used this example to load all my bitmaps and icons into a resource file. It requires a lot of reading, but there are plenty of examples and source code.

sivilian14-Jun-04 9:03

sivilian

14-Jun-04 9:03

Hi,

Does anyone know of an API in VB6 (perferably) or any other way to programmatically give a user read access to a folder. I am presently using a product called Dameware, which works fine, but it removes the inheritance on the folder to which I add the user.

Any help is appreaciated,

thanks,

sivilian

Re: Setting Permissions Programatically

Dave Kreskowiak14-Jun-04 9:21

14-Jun-04 9:21

There is this[^] article on MSDN that shows a method of do it with VB.NET and the Active Directory SDK. There is also this[^] article here on CodeProject.

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

Just a counter ?

Anonymous14-Jun-04 7:22

Anonymous

14-Jun-04 7:22

How can check a string between two forms.

Re: Just a counter ?

Dave Kreskowiak14-Jun-04 7:30

14-Jun-04 7:30

How many times are you going to post this question? This is your third and it's considered very rude.

You haven't described what you mean by a "counter"? Counters don't check strings. They count, nothing else. What is this counter counting? What are you checking for in the string?

Passing the string between forms is not hard at all.

' Form1
Dim f2 As New Form2
 
f2.CheckString("This is a string...")


' Form2
Public Function CheckString(ByVal strToCheck As String) As Integer
    '  Do some kind of check on the string
    Return intResult
End Function

Like I said, since you haven't supplied any code what so ever, it's hard to tell you what you doing right and wrong.

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

convert Ms Word to PDF

franco_8214-Jun-04 6:32

franco_82

14-Jun-04 6:32

Hi..

I'm actually trying to do a project on converting Ms word into PDF and storing them in SQL server database. The problem is that i would like to the conversion without using third party software. However, i can't find the codes or snippets in vb.net. Appreciate any help on this matter. Thx

Dave Kreskowiak14-Jun-04 7:10

14-Jun-04 7:10

Sorry. You're going to use third party software to convert to PDF. There are no snippets anywhere on how to do this because of the complexity involved. The only free solutions are going to be PDF printer drivers that create a .PDF file that you can then read as binary data and send to a large field in an SQL database.

Search http://SourceForge.net to find some open source projects that do this. You'll quickly see why you haven't found any .NET code snippets...

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

xfitr214-Jun-04 18:21

14-Jun-04 18:21

Actually, there is a way to convert text files to PDF format, and I guess by using VBA to convert the WORD document to text, you could then convert it to PDF. I can't post the open source code on this site because I am not sure where I got it from and therefore I do not want to infringe on publishing notices (I have the author, but no website). Get in contact with me and I will send a ZIP file from my code library. I've used it to create simple text reports and it works great!

Also, if you have time on your hands, you could read up on the PDF file format. Adobe has a 518 page reference that explains how to do build it. You can get a copy of this file from: http://www.wotsit.org/

xfitr214-Jun-04 18:39

14-Jun-04 18:39

I found the website where you can access the code.

http://www.vb-helper.com/howto_write_pdf_report.html

franco_8215-Jun-04 2:12

franco_82

15-Jun-04 2:12

Thanks for the comments Dave and Garrett. I will try out the codes and convert them into vb.net and see it it works. Thanks for the url links again. Cheers.

Mekong River15-Jun-04 4:27

Mekong River

15-Jun-04 4:27

Hi, I would like to share an idea with you. I never do it but I think it might work of something go smooth with the following step.
1. Install the adobe acrobat writer. So when you need to convert any file (ex. Ms word) you have to go to File menu and Print… sub menu and choose Adobe Acrobat Writer from the select printer name and save it in a proper place.
2. Create your VB6 or VB.NET application that could connect to the SQL server database.
3. Write the code in appropriate procedure to select the source file (ex. Ms Word file) and then call for the Print Dialog box (using the common dialog control or common dialog API).
4. After select the acrobat writer from the printer name and press then it will prompt you to save the file into the specific place. Then save it and write the code to return the path and file name of the file that you save in acrobat and return that string to store in the database.

This method could make your database file require small amount of disk space and easy to access the file from your application.

If any one have any comment about this solution please correct it in order to share our knowledge and idea to each other.

Roath Kanel
APO-CEDC
Save Children Norway-Cambodia Office

franco_8216-Jun-04 1:59

franco_82

16-Jun-04 1:59

I've seen such conversion being done in VB 6..using adobe acrobat. However, trying to apply the same concept in VB.Net resulted in errors. I will attempt to solve it. Thanks for the steps to solve it, Roath. Appreciate it.

Regards

Frank

Counter?

ymohd_22214-Jun-04 6:08

ymohd_222

14-Jun-04 6:08

Could you help me to make two forms. one for input text and other for output the text.
I need the out put to appear in the second form when i click the button and the counter check the name.

Go forward and never Stop....

Re: Counter?

Dave Kreskowiak14-Jun-04 7:12

14-Jun-04 7:12

This sounds too much like a homework project. You'll have to write the code. We can help with specific questions, but we wont' design and build it for you.

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

Convert to VB.Net

Anonymous14-Jun-04 4:37

Anonymous

14-Jun-04 4:37

Could you please help me convert this to Vb.Net? Thank you very much in advance.

Getting an image area for displaying in B/W.

CRecImage Image;
CRecInfo Info;
COleVariant vBitmap;
LPBYTE pBitmap = NULL;
HBITMAP hBitmap;

try
{
. . .
Document.SetLineOrder(TOP_DOWN);
Document.SetPadding(PAD_WORDBOUNDARY);
Document.SetRGBOrder(COLOR_RGB);
vBitmap = Image.Get(Info,0,0,160,100);
SafeArrayAccessData(vBitmap.parray,(void **)&pBitmap);
hBitmap = CreateBitmap(Info.GetWidth(),Info.GetHeight(), 1, Info.GetBitsPerPixel(), pBitmap);
. . .
SafeArrayUnaccessData(vBitmap.parray);

VariantClear(&vBitmap);
. . .
catch(CRecException e)
{
TRACE("Error code = %X\n", e.m_hr);
}

Re: Convert to VB.Net

Dave Kreskowiak14-Jun-04 5:01