Search results

  1. G

    Autonumbers when we union tables

    Hi everyone! So basically I have 2 tables with 3/3 identical fields: Customer ID (Autonumber, Primary Key), Type of Customer and Customer Name. The Customer ID from Table 1 is formatted as 'PAR-"0000 The Customer ID from Table 2 is formatted as 'CHI-"0000 When I create a query to Union these...
  2. G

    Settings/Code to prevent duplicate record

    Hi everyone! I am a newbie and I have a silly question here. Hope you could help me to solve it! I have a table with 3 fields: Customer ID (Primary Key and Autonumber), Customer Name and Customer DOB. Now I want to prevent my users from entering the same customer. For example, there are 2...
    • Golo
    • Thread
    • Replies: 8
    • Forum: Tables
  3. G

    Connecting MS Access with SQL Server

    Hi guys, I am newbie who are extremely low-tech. I am currently building up a MS Access database with Tables, Forms, Queries, Reports for a team of around 6-8 people. We are working in a new office with no shared networks, no Microsoft Office Enterprise yet. Each of us is using our own...
Top Bottom