Search results for query: *

All:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanks for reading this.&nbsp;&nbsp;I am looking for help on creating an <b>array of records</b>.&nbsp;&nbsp;The array would be based on 2 fields from a recordset.&nbsp;&nbsp;I want to count the occurrence of data in a particular field.&nbsp;&nbsp;For...

Danny:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;both machines are running original versions (development machine running 98) and test machine running 95.&nbsp;&nbsp;I'm going to try the service pack for VB6.0 and see if that makes a difference.&nbsp;&nbsp;Thanks.<br><br>Renae

Danny:&nbsp;&nbsp;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;How do I know what all the files that my program needs are?&nbsp;&nbsp;I downloaded from Microsoft an executable called vbrun60sp.exe&nbsp;&nbsp;(it is supposed to include all of the necessary files for any VB6.0 application, it also...

I found where to set the compatibility..it is under the project properties.&nbsp;&nbsp;In my project, however, I cannot choose the compatitiblity types (all are grayed out).&nbsp;&nbsp;The default setting is -- no compatibility.&nbsp;&nbsp;So I cannot change that.&nbsp;&nbsp;Is it possible that...

HELP!!!<br><br>&nbsp;&nbsp;&nbsp;I created a project and whenever I install it...I get this message!&nbsp;&nbsp;I looked it up on Microsoft.com and their resolution is to Use Binary Compatibility.&nbsp;&nbsp;Unfortunately, I cannot find anywhere that I set any type of Compatibility whenever I am...

DannyB and skelly,<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;You've both given me some ideas--thanks alot! I'll try those out tonight.<br><br>Renae

If the contents of the field are empty, then the field should be null....is that what you're asking?<br><br>

All:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I have an SQL statement (see below) that generates a limited recordset.&nbsp;&nbsp;I want it to generate that recordset based on a particular field being empty (exit_status).&nbsp;&nbsp;In my database, if a particular record has anything in the...

I have a large application with 3 main tables.&nbsp;&nbsp;My application has about 20 different forms...on almost all of these forms, I need a relationship to my database.&nbsp;&nbsp;I have combinations of ADO data controls on my forms as well as code to connect to the database and...

Bruce:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The wildcard character is no longer a * (star), Microsoft changed it in their new engine to be a % percent sign.<br><br>Renae

I have a report created and in my program I am allowing the user to select a record for printing based on student ID.&nbsp;&nbsp;Therefore my DataMember property is an SQL statement that contains a variable representing the ID.&nbsp;&nbsp;It is as follows:<br><br>With...

Collin:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;That's exactly what I'm doing now...my question was very confusing (I know that)..sorry.&nbsp;&nbsp;My question was this if I am populating 3-4 combo-boxes on the same form...I have the same database connection for each one (seems redundant to...

I have several places in my application where I am connecting to the same database in order to do things like populate a combo-box with data from a particular table.&nbsp;&nbsp;Often this is on the same page/form.&nbsp;&nbsp;How can I create a public function that <b>all forms </b>can access...

Anyone:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;First, thanks for taking the time to read this...I hope you know the answer or it helps you as well.&nbsp;&nbsp;<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I have a combo-box which is populated via a connection to a table from a database.&nbsp;&nbsp;It...

Thank you both very much for your response.&nbsp;&nbsp;RHicks, I tried that, but for some reason it just didn't work for me.&nbsp;&nbsp;Cornerstone....you hit the spot!&nbsp;&nbsp;Great Job..it works exactly as I need it to.&nbsp;&nbsp;Both of your responses are what makes forums like this...

Anybody!<br><br>&nbsp;&nbsp;&nbsp;&nbsp;I have a table with a field for holding an ID number.&nbsp;&nbsp;Whenever the user enters an ID, I would like this number to be saved with any necessary leading zeros.&nbsp;&nbsp;My field length is 10 spaces, therefore, if my user entered 12.&nbsp;&nbsp;I...

Elizabeth:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I probably won't buy any product..this is for a school project. Thanks!<br><br>Renae

Thanks Eric!&nbsp;&nbsp;I'll give that a try.<br><br>&nbsp;&nbsp;Renae

I have created a fabulous report structure and it is exactly what I need...now, can I export it or somehow get it into VB without having to re-create?&nbsp;&nbsp;Any help would be much appreciated.&nbsp;&nbsp;I know this is an Access forum..just thought that somebody here might...

How do I programmatically execute an &quot;auto-fill&quot; for a drop-down list?<br><br>For example, say I populate a combo-box with the contents of a field from a table.&nbsp;&nbsp;If my table has 100 records and the particular option the user is looking for is 100, then the user has to scroll...