Recent content by positran

What I would do is use the Execute method of the database object.<br><br>dim dbMAIN as database<br>set dbMAIN = dbengine.opendatabase(&quot;c:\scs.mdb&quot;)<br>dbMAIN.Execute(&quot;YOUR SQL STATEMENT HERE&quot;)<br><br>If you go the SQL view in Access you can cut and paste in the SQL that your...

What kind of error are you getting?<br><br>You should be able to shorten the SQL to this:<br><br>&quot;SELECT Nam, Phone1<br>From Customer_File<br>WHERE CustNo = '&quot; & strCasAcctNumber & &quot;';&quot;<br><br>Also make sure that the 'strCasAcctNumber' variable matches the variable type in...

Is it an Active X Dll?

I have a book called VB6 Database.&nbsp;&nbsp;You are going to have to use DAO or ADO to connect to that and there is a good number of books on that subject.<br><br>Good Luck

I believe that the Active X Dll's creted in VB can be used in any dev enviroment that supports Active X Dll's.&nbsp;&nbsp;I would expect that if you are using DAO that you would have to have the appropriate Dll's for it to otherwise your dll will not be able to create the DAO object

before printing the report try<br><br>cr1.retrievedatafiles<br><br>

Best to put definitions into a .cpp. The class should be a general declaration of what variables and functions are available. The .cpp defines those variables and functions as to specifically how they will be used. Keeps it clearer.

You could also you a flexgrid control. Not as easy to add and delete items but it does give you control of colors and you get the added benefit of rows and columns. Neat Project<br> <br> Pos.

any time you output to the label <br> <br> Label1.Caption = format(LocalVar, &quot;currency&quot;)

Saxcomm makes a good 3rd party control that can be plugged in with little trouble. It has many more features than MSComm including built in protocols like Xmodem and Ymodem. Although fairly expensive I have used it and there is a 30 day trial.

I have code snips for you ...but not with me. Do you know how to connect to Access? It is very much the same with a few mods.<br> <br> Will try to post my snips...<br> <br> <br> pos

not sure how to show the check box. I use the words active/inactive or checked/unchecked. <br> <br> When user clicks on the grid the row and column property are set to that box.<br> <br> try this to see:<br> <br> private sub flxGrid_Click()<br> <br> msgbox "Row &gt; " & flxGrid.row & " Column...

don't know....that attribute can be set during runtime or design time. Works fine on my end. To Chips point you must be sure that your users are aware that changing time values on the pc can effect the performance or your app. <br> <br> Way to go Chip....just goes to show how little I consider...

masked edit control works fine. I agree that it can be challenging to work with at time. <br> <br> set your mask property to ##/##/####. This guarantees that users can only enter numbers and causes a trappable error if they do not complete the date. set the Prompt Include to false. If set...

you absolutely need to use app.path or use an external storage place (registry or .ini) to tell the app where the file is. To avoid all that nonsense simple indicate the entire path in code and do not give your users a choice as to where they want to install the app. To do that you need to...