Tables :: Replica Trying To Make A Column Addition To Table

Sep 11, 2014

I have a replica at work, 1 copy on the network, 1 local.. I need to add a column to the main table, getting "Operation is not supported for this type of object".... I have users that use the database but was given a change to the form/report which requires a column addition. What is the simplest way to get around this??? I'm trying not to get into major problems.

View Replies


ADVERTISEMENT

Error: You Cannot Make Changes To The Design Of The Database At This Replica

Apr 14, 2007

I recently was asked to update a client's BE & FE database.

It seems the client only has a replicated version of the database. I don't have the original Design Master.

Problems with negative autonumbers (it seems are due to replication), made me want to remove all need for replication from the database sets.

I attempted to modify some of the Tables in the BE and keep receiving the same error when I try to save it:

ERROR: "You cannot make changes to the design of the database at this replica"

I haven't found a solution on the forum yet. Any ideas?

I found the Replication part of this Microsoft KB article somewhat helpful: http://support.microsoft.com/kb/275561/en-us

View 6 Replies View Related

Make-Table Action Query Column Data

Jan 30, 2006

I use a Make-Table Action query to import data from a linked table into my database. The linked table is on a network server that is automatically updated.

One column of the linked table is named "QTY/PARTIAL" and approximately 10% of the 500 records have a "P" after a number i.e. 1000 P. I would like to separate the number and the P into separate columns in the new table to faciliate being able to compute the total number "QTY".

Thanks,
Gunner...:confused:

View 12 Replies View Related

Make Column Show True False In Table

Jun 19, 2014

Can make a column show true or false in a table when two other columns in the table match each other? I think the statement would be like this:

If([Column1] = [Column2], True, False)

The only problem I am having is that I don't know if it can work in a table or does it just have to be in a query?

View 8 Replies View Related

How To Make A Table Lookup Field Depend On Value In Another Column

Sep 20, 2012

I have a table called Locations that lists Countries and Cities:

USA, Detroit
USA, Chicago
USA, New York
UK, London
UK, Liverpool
UK, Birmingham
France, Paris
France, Le Mans

I then have another table for inputing details on people I know. This table would have columns called Country and City. I've figured out how to make the Country column a "lookup column" so that I can only enter USA, UK or France. But how do I make the City column show only the appropriate list of cities relevant to the country that I've selected (e.g. Paris or Le Mans if France is the selected country).

View 5 Replies View Related

Tables :: Auto Deletion And Addition Of Data To Several Tables

Nov 28, 2014

In my Membership Database (Access 2010), I have a Table entitled [Foreigners] in which are stored the names of prospective members of the organisation and the name and ID of the Interest Group they are proposing to join.
When a formal Application to join is received their personal details are recorded using an Entry Form related to the main [Mail List] Table.

The current procedure then is to manually delete the entry from the [Foreigner] Table and finally to record their Interest Group data using another Entry Form entitled [GroupMembers]. This relies on an operator remembering to do the necessary.

It occurs to me that this process could be automated. I wondered whether it could be entirely automated or would be best effected with a button on the main Entry Form, such that on completion of data entry of personal details the button would be activated to do the necessary deletion and addition.

The [Foreigner] Table is an entirely stand-alone table, having no relationship with the other concerned tables. The only common factor will be the Member Name, which in the main table is a concatenation of First Name & Surname..

View 8 Replies View Related

Addition Of Data In Two Tables

Sep 9, 2007

i have two tables - all fields are same in two tables.

Table1.salary, Table1.Interest, Table1.Bonus
Table2.salary, Table2.Interest, Table2.Bonus

now i want to add these values and put in a thirs table.

Table3.salary=Table1.salary+Table2.salary
Table3.Interest=Table1.Interest+Table2.Interest
Table3.Bonus=Table1.Bonus+Table2.Bonus

pls help me.
can i do it with help of Query, Macro or any other method.

View 1 Replies View Related

Addition Of Data In Two Tables

Sep 9, 2007

i have two tables - all fields are same in two tables.

Table1.salary, Table1.Interest, Table1.Bonus
Table2.salary, Table2.Interest, Table2.Bonus

now i want to add these values and put in a third table.

Table3.salary=Table1.salary+Table2.salary
Table3.Interest=Table1.Interest+Table2.Interest
Table3.Bonus=Table1.Bonus+Table2.Bonus

pls help me.
can i do it with help of Query, Macro or any other method.

View 2 Replies View Related

Tables :: Make Calculated Field In One Table That Calculates Values From Another Table Linked By Order ID

May 13, 2015

I have what is probably a stupid question but I've been struggling with this one for a while. I have an ordering database which has an Orders table (containing Order ID, Date, Supplier etc) and an Order Line table within which I have a combo box for Product name, supplier, price, VAT rate, Line price etc. At the moment, I have the order line table as a subform within the Order form (run from the Orders table). The problem I'm having is the subtotal and total fields. At the moment these are in the Order Line table as I cannot figure out how to get these in the Orders table. In summary, can I make a calculated field in one table that calculates values from another table (linked by Order ID)?

View 3 Replies View Related

Column Names. Can I Make The Name Field "higher"? (to Make Room For More Lines)

Sep 25, 2006

I'm currently working with a form, which is in datasheet view. I have many rows which are combo boxes (yes/no), and the name is rather long. So each line (each row) spreads on to 2-3 pages to the right.What I would like to do is make the namebar, on top of every column, a little bit higher, so the name would be split into two lines, or three. Allowing me to make the width allot smaller.Here is an example of my problem:http://213.213.137.96/~terminal/columns.jpgSo my question is, can I change the height of the column name? Or is there some trick I can use?regardsFrímann Kjerúlf

View 1 Replies View Related

Addition To Table Messes Up Query

Feb 23, 2007

Hi all,
i have a table called expense that i have tied to a case table... i also want this tied to the employee table, but when i add the employeeID field to the expense table it messes up all my queries that i had previously created... the queries merely reference the expense amount that is located within the expense table... is there something that i am doing wrong? (obviously there is) but i would like to know why this is happening

View 14 Replies View Related

Combining Tables To Make One Big Table?

Oct 11, 2006

Hi

I have several small tables that I want to make combine into a big table.

How do I do this - is the only way by using a query?

Maria

View 2 Replies View Related

Tables :: Column For Every Row In Another Table?

Feb 19, 2014

I have 2 tables:

Trainers
-> Name
-> Date of Birth
-> Address
etc etc.

Courses
-> Name of Course
-> Course approval expiry date
-> Type
etc. etc.

I now need to make a table whereby I can have the list of trainers and tick the courses that they are allowed to teach in each column.

I can forsee the columns are being:

-> Trainer
-> Course 1, course 2, course 3, course 4 etc etc.

The problem is that courses can be added/changed/deleted.

View 10 Replies View Related

Tables :: Make Table Queries - Indexing?

Jan 2, 2014

I have a complex series of calculations to perform, and I have found the best way to achieve my end is to create new tables by the Make Table queries.

The trouble is I have many tables to create and the downstream tables refer to the previously created tables; I have recently discovered that queries perform much quicker if they are indexed (duplicates OK). I've looked at my tables created by the MakeTable queries, and they all seem not to be indexed.

How do I make them indexed automatically?

View 2 Replies View Related

Tables :: Make Query Temp Table

Oct 9, 2013

All using access 2010. I have a multiuser database that I feel would benefit from splitting into a backend with multiple user frontends. My problem is that there are tables from make table queries processed every two weeks that all users need access to. As far as I know; you can not put a table in the backend that you will delete and remake or a temporary table and link to it in the front end. Is there any other way I would be able to split the database and have temporary tables linked from backend to frontend that I am not aware of? Is there another way to creating temporary tables and tables from make queries? This database has 9 users and counting and really needs to be split. r

View 14 Replies View Related

Tables :: Calculated Column In Same Table

May 19, 2014

I have a table with columns as

1- Name

2-Marks in Subject 1

3-Marks in Subject 2

4-Marks in Subject 3

I want to create more columns in same table as

5-Total Obtained Marks

6-Maximum Marks

7-%age of Obtained Marks

How can I do it in one table

View 3 Replies View Related

Tables :: Column Width In Table

Aug 19, 2015

One of the Tables in my membership database is named [WaitList] and has a linked Form.

The Form is configured to pull data from another Table named [Groups]. The fields are [Group ID], [Group name] and [Leader].plus others from a second Table.

When the [Group name] is selected from a Form Combo Box it succesfully records the [Group ID] in the Form and Table, but repeats the [Group ID] in the [Group Name] column of the Table. I am convinced that the problem lies with the Column Width setting on the Property Sheet which is currently set at 0;2.54, but trying various combinations has not solved the problem.

The Row Source for the [Group Name] field is
; SELECT [Groups].[Group ID], [Groups].[Group Name], [Groups].[Leader] from [Groups] and the Column Count is set at 1 (2nd in Table)

I believe the [Leader] field is a different problem in that the Form correctly finds the ID and the Name but not the Leader. I have checked the property sheet for anomalies, but without success.

I have built this type of Table/Form relationship many times but have failed on this occasion.

View 9 Replies View Related

Tables :: Copying Column From One Table To Another

May 4, 2013

Query:
I have two tables : Table1,Table2.
Table1 has columns : A,B
Table2 has columns: A,C

What I want to do is to copy all data of "C" from Table2 to Table1 so that Table1 has columns: A,B,C..(Column "A" is common in both Tables).

View 4 Replies View Related

Tables :: Make Table Returns Multiple Records

May 11, 2013

I have two tables with compatible data. Table 1 has 23 records and table 2 has 5 records. I am trying to make a "make Table". But instead of a table with a combined 28 results, I get 115.

View 1 Replies View Related

General :: How To Combine 2 Tables With Same Primary Key To Make One Table

Oct 18, 2012

How to I combine 2 tables with the same primary key to make one table? I have seen several thigns but none have worked. I seen inner and outer joins. All 4 of my tables have the same primary key. I just want to combine all the tables to make one table. I have a form with subforms but if I can combine all the tables and work off one rather then 4 I will be happier. Every week to 2 weeks I upload new data from excel. How would I after I add the new data combine all tables to one super table?

View 7 Replies View Related

Tables :: How To Make Table Not To Fill Entire Screen

Nov 11, 2013

No matter how much I maximize or minimize Access (2010) my tables fill the entire screen. This happened once before but I don't recall the fix. It was something very simple. How to make the table not fill the entire screen?

View 9 Replies View Related

Tables :: How To Make Constraint When Putting Records Into Access Table

Sep 29, 2014

I am developing a simple database for students to register courses using Microsoft Access 2010. I have 4 tables: Student, Register, Course, and Section (1 Course can have many Sections).

Then, there is a criteria that a student can only take up to 6 courses. Hence, may I know that where and how can I include this constraint? I believe that it should be in the Macro (Before Change) of the table Register...

My relationship is: Student -> Register <- Section <- Course

View 1 Replies View Related

Tables :: Password Protect A Linked Table Or Make It Read Only

Nov 14, 2012

I have a table that I imported from another database. I used import Access - Link to the table source by creating a linked table. - then downloaded in my database.

I want to use the linked table to create relationships and forms but do not want to even accidently edit it. The table gets updated in the database on a weekly bases and I am hoping it gets updated automatically in my database as well. does it automatically get updated or do i have to set up something?

Also, I want to protect the data in that particular table and either password protect it or make it read only. Can I do that? If so, how?

View 4 Replies View Related

Tables :: Relationship Linking Row And Column In A Table

Nov 12, 2013

i am making a database from which i can calculate fuel required from one point to other in any particular type of vehicle.the problem is fuel from Pt A to Pt B is not same as from Pt B to Pt A.A sample table is attached as zip. qp.bmpis there any way i can cross refer field values with that of rows .

View 9 Replies View Related

Tables :: How To Alphabetize Column Names In A Table

Jul 31, 2014

My employer wants me to update and revise a form with almost a hundred controls. All of the information is stored in a single table.

Is there a way that I can (easily) sort the order of columns in the table to alphabetize them? I know how to sort and filter records, is there a way to sort the columns other than the manual click and drag solution?

Note: I know that the database I'm working on for this project is not normalized. My employer isn't concerned with normalization. I've made as many corrections to the table as possible, already, but some things just won't be fixed.

View 10 Replies View Related

Tables :: Change Table Relationship Column

Aug 18, 2013

When I originally created my access database, I used a text field/column to connect 2 tables together. I would like to change this to reference the Primary Key/ID column instead of the text field.

Is there an easy way to go about doing this? My original thought was to create some vba code to replace the data in the column of the sub table with the autonumber in the primary table but I cannot figure out how to do it.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved