Search Result

Mang Kanor · Feb 27 '12, 10:00 PM

so I have a template in Crystal reports using vb.net, I changed my data source location and that source still contains the needed tables for my report, the problem is this... My original template displays the exact report but when I changed its data source it duplicates the data in the details section(e.g I made a query that will show 1 item only,but instead I get 4) here is a screenshot of my problem, I want to alter the template rather than to...

Joe Farage · Apr 1 '11, 08:17 PM

I have a form that has several subforms on it. They are all linked to the main table by use of a field called Patient ID.
On this form, if I use the buttons for first record, previous record, next record, last record; there is no problem and everything works correctly.
But if I try to type in an ID number in the box and then hit tab, it gives me the following dialog box.

"The changes that you requested to the table...

Fspinelli · Nov 22 '10, 03:15 PM

Happy Monday,

I have a table (Master) and two queries. The first query (qry A) takes data entered into a form and converts that data into various symbols. The second query (qry B) is an append query and takes qry A and appends the data to the table (Master).

When I open up the Master table there is one row that shows the data entered and another row with the same data entered plus the symbols it created. It makes two...

David Shears · Aug 3 '10, 04:21 PM

I am trying to use an append query to add data to another table i have. I have tableA and tableB. tableA has 1000 rows while tableB has 800 rows. i would like to add the other 200 rows in tableA to tableB without adding the 800 identical rows. I have an append query but there is an error that is bothering me.

INSERT INTO tableB
SELECT *
FROM tableA
WHERE NOT EXISTS (
SELECT *
FROM tableB
WHERE...

Talnus · Jul 1 '10, 08:58 PM

This question is completely backwards, to what a database is suppose to do, however because of the interaction between two systems it needs to be this way. I am looking for some way to have a report display the information bellow.

I am simplifying the problem to what I am trying to accomplish. I need to have quantities be able to repeat an entry as many times as there are quantities.

OrderNumber, QTY, PartNumber...

AccessUser123 · Apr 20 '10, 10:13 PM

I am trying to get my Access database to INCLUDE duplicate records. I have a simple database with one table that does not have a primary key and I am using one query to generate a report. The data has a lot of duplicate records that need to be included in my report. Is there a way to include duplicate records so that they will show on my report. All table fields that are indexed are set to "Yes, Duplicates OK" and all fields in the...

JMANTN · Apr 18 '10, 10:01 AM

Hello, I'm hoping someone could help me out with a problem I've ran into while trying to create a training database. I'm just a beginner with Access and VBA so please take that into consideration.

The problem I'm having is the possibility of record duplication in my current database. I'm hoping maybe there's a way to set up a relationship or query/vba to prevent this.

I currently have a form (frmCE_AddAgent Training)...

chemlight · Jan 28 '09, 08:49 PM

I'm trying to figure out how to order an array based on the number of duplicates, and then remove all duplicates.

This is my code right now:

Code:

foreach($acID as $searchterms){
$results = mysql_query(SELECT * FROM table
     WHERE field LIKE '%$searchterms%')

   while($row = mysql_fetch_array($results)){
         array_push($resultArray, $row['id']);
         }
}

...

nspader · Nov 26 '08, 06:24 PM

OK, I am pulling my hair out on this one. It seems like it should be so simple and I cannot seem to find the answer.

I am using Access 2000 on Windows 2000.

I have two tables set up. Table One is updated Daily, Table Two is going to keep a running tally of Data.

What I need to do is add records form Table One into Table Two. However, I only want to add records that do not exist.

Here...

Search Result

Crystal Reports Problem

manually updating text box causes primary key problems

How to stop my records from multiplying when I click Append?

Append Query Without Duplicate Rows

How to Duplicate Table Entries by a Quantity?

Allow Duplicate Entries in Access

Duplicate Record issue with Training Database with Multiple tables & temporary tables

Order array based on number of duplicates

append query - nonduplicate records