Visual Basic Classic Unanswered Threads

Hi I am new to Classic vb I have a really challenging problem, and I would be very grateful for any help ideas suggestions that any of you gun vb6 developers might have I need to read data out of an Access 2.0 file format file from VB6 this has to be compiled and redistributed as part of a database upgrader, licensing constraints and the end user desktops prevent the use of a VBA runtime. Thanks in advance

Posted to MB Topic: VB Classic Database Tasks

Hey y'all,I need to fill in PDF files. There is a product available that does thid for the backflow community but I do not have it nor does it do the other half of things I do. (It is not especially user-friendly either.) I do backflow testing and calibrate test kits and pressure gauges. That means filling out forms for county offices with a lot of the same data on them from year to year. Sometimes there are several devices per customer. These are scanned PDF forms from the counties (have to be their original, typed format - computer printed is okay).  Calibration data sheets are currently in Excel - spreadsheets formatted to print out for the customer. I fill these out after a test. Copy and paste tends to lead to errors and boredom. Takes too long too!--> You can guess that I do a lot of typing over - because the data for test reports, calibration sheets, quotes and billing  is not easy to put into the form where it ultimately goes.  It can be stored together, ...

Posted to MB Topic: VB Classic Control Usage and Developing

Hello, , I am sure that this is going to be a simple problem to fix, but I have just started a very steep learning curve with Visual Basic 6 in that I have to alter a program that has already been written, and I am a complete novice to VB., , What I need to do is to read in a text file which has multiple lines. The information that is read in then has to be displyed in a text box for the user to read. i.e. one line in the text file should appear as one line in the text box. Is there a simple way of achieving this, or can someone point me in the right dircetion for finding a solution., , Thank you for your time., , Gary Park

Posted to MB Topic: VB Classic Control Usage and Developing

cr_Report.Database.SetDataSource rs_Report, , Using that line returns the entire contents of the query table instead of, the items in the query., , If I assign the recordset to an array the array contains ONLY the items I, requested but when I assign the same recordset to the crystal report it contains, ALL the items in the table., , Any help would be greatly appreciated., , Thanks,, , Mike

Posted to MB Topic: VB Classic Other

Hello All,, , I'm working on an VB 6 application which has got the workflow as follows:..., , 1.Read .wpd files from the folder given by the user.There is no restriction as to how many .wpd files user can put in that folder at a time.(The application uses VB timer control to look for .wpd files in the folder say after every 3 seconds.), , ....For creating wpd object i'm using late binding :, Dim objWPD, Set objWPD = New WordPerfect.PerfectScript, , 2.If .wpd file(s) are found then the application opens each .wpd file one by one and then converts and saves it into text format file., The code which i'm using for this is:, , objWPD.FileOpen &_ , g_strWPDPath & strFileName, ANSIText_Windows_FileOpen_Format, , objWPD.FileSave g_strWPDPath & "Dummy.txt", &_ ANSIText_Windows_FileSave_ExportType, , After reading each .wpd file i close the file using:, objWPD.Close No_Close_Save, objWPD.ExitWordPerfect, , 3.Then i'm making the XML file for each .wpd file., , When the app...

Posted to MB Topic: VB Classic Other

I got a problem getting ADO recordsets to support the 'Seek' method from VB6. I have been using an access97 database, and no matter what combination of cursortype and cursorlocation i try, calling the .supports(adSeek) always returns false. Is there some wierd little trick i haven't found out about yet? Also - what about indexes, i found similar problems with these (i think that the seek method doesn't work without indexes). Any help would be vastly appreciated!, Cheers, Robin

Posted to MB Topic: VB Classic Database Tasks

Hello,, I am hoping you can help me as I am about to go mad with this problem. I would like to make a fax cover letter that has drop-downs or whatever for the send to fields. Since I am always sending faxes to my clients it seems like it would be easier to just have the fields in the fax cover letter just be drop-down lists for my clients. I am wondering if there is a way to code them, since i am a beginning programer and have no clue. That would allow for Word to pull the Name, Address, email, phone, etc... From either my Outlook address book, or from an Excel spreadsheet I set-up with my client data. Any sort of help would be VERY much apprechiated. Thanks for your help and time as always,

Posted to MB Topic: VB Classic Other

Problem with WebBrowser., , I am now developing a programming which is showing a word,powerpoint & excel files in the web browser. Whenever user click a record in a datagrid (show all information about file) then webbrowser will show the related file (using Navigate command)., , The problem is, , 1. User can edit the content of files (e.g *.doc & *.xls file), Can we control so that user can only view this content on web browser?, , 2. Webbrowser will prompt a msgbox asking user to save the changes or Save as., (This happens when webbrowser detect that a file has been changed)., This happens when i navigate to other file., , e.g Now WB (i used WB for webbrowser) is showing record no 1 (word file)., when user make changes and want to navigate to record 2 (another word file), msgbox above appear. , , Can we ignore this msgbox or force WB to ignore all changes.., I have tried silent properties but it fails., , 3. Can we wait for WB for finish loading that p...

Posted to MB Topic: VB Classic Control Usage and Developing

Can someone please advise on what code to put behind a button on a form to run an existing query and also how to create a query in code., Thanks

Posted to MB Topic: VB Classic Database Tasks

i need code to wrap the data from a string data field into a text file(.TXT)., , the one i have looks ok when viewed on notepad, wordpad or when emailed as an attachment but when it is printed it breaks up into sections., , if you need more info please let me know., , can someone help me with this problem?, , Ron

Posted to MB Topic: VB Classic Other

I have big trouble using VB to add records in a Paradox Table., , Listing records in a datagrid work fine, adding a recordset seems to work, but when I close and Reopen my recordset, Datas are not added to the table.... What's wrong???, , Thank for any answer.

Posted to MB Topic: VB Classic Database Tasks

i am writing an program to save clipboard into monochrome bitmaps. however Clipboard.GetData() always saves image in 24 colors . how do i save image in monochrome?, appreciate help!

Posted to MB Topic: VB Classic Other

This must be a well known problem!, (There are several articles in the msdn, but nothing, seems to apply 100%: Q189448 etc), (One even says the behaviour is by desgin(!?)Q166113) , , VB 6.0 connects to an Access DB:, (Microsoft Data Access Components 2.6) , , Everything worked well when the underlying DB was Access 97, Now we had to convert to Access 2000:, , "Undefined Function 'xyz' in Expression", The function xyz() is used in the query that was selected., I installed SP4 for VB with no effect. , , Thanx very much in advance, Wilfried Baumann , , wilfriedbaumann@gmx.at

Posted to MB Topic: VB Classic Database Tasks