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...

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...

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...

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...

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...

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...

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...

How do I create a &quot;SELECT statement that allows me to get records using 2 dates (obtained from textboxes) and get all records whose date appears within that range?<br> <br> For Example: The user selects to print out all records with a particular date. My program asks them to input a...

What is the best way to output the results of an SQL query so that my user can then select the one needed? For example, say I am attempting to output a report for a single record from my database. To generate the query, my user types in a string for Last Name. Based on that string, I generate...

Everyone!<br> <br> Thanks for reading my question! I would like to be able to edit the same record from 2 forms...could this best be accomplished by setting a bookmark for current record in one form, then opening the second form and (with ADODC control hidden) set current record to...

I am totally lost! I have an application that I need to be able to allow 2 different user-types to access. I want an Admin user who can access everything and I want another user who is limited to particular options from the main menu. What's the best way to accomplish this? I would also...

I have a main form..to save the operator from having to tab past fields that might not be entered on every record, I would instead like to put something like a checkbox that they would select to indicate that a particular student has attended workshops. It would look like this:<br> <br>...