Question about Microsoft Office Standard for PC

1 Answer

Access Pasting Multiple data in the table

I could not paste multiple data in the table of access from the other tables which i want to transfer.

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Legend:

    An expert who has written 200 answers of more than 400 characters.

  • Expert
  • 359 Answers

When pasting data between tables, you have to make certain to select the exact number of rows and columns that you are going to paste into. For example, if you are pasting ten rows and ten columns of data, select (highlight in) from source table, Control C to copy, then go to destination table, select (highlight) ten rows and ten columns, then paste, either by right click and paste, or Control V.

This should solve your issue, but if not please post back. Thanks for rating FixYa!

Posted on May 05, 2008

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Casio pcr 308 cash register


Hello,

Per the instructions on the Casio4Business Support website, you can do the following:

PCR 308, 350, 355, 408, 450
TO PROGRAM STATUS OF DEPARTMENT KEYS:

1. TURN KEY TO Z MODE
2. PRESS SUBTOTAL
3. PRESS 02 FOR TAX TABLE 1, 04 FOR TAX TABLE 2, 06 FOR BOTH TAX TABLES, AND 00 FOR NO TAX
4. PRESS DEPARTMENT KEY
5. REPEAT STEPS 3 & 4 FOR MULTIPLE DEPTS.
6. PRESS SUBTOTAL

You can access additional information at the main support site: http://www.casio4business.com/sa/support/taxtable_programming.html

Regards!

Dec 17, 2013 | Casio Parts Cash Register PC Desktop

4 Answers

Where can i buy a chiropractic table?


there are many sites and shops that sell chiropractic tables. you should figure out first of all what kind you are looking for. Here is one good site where you can personalize your table;
http://www.elite-chirotables.com/index.php

Jan 14, 2013 | Medical

2 Answers

Access database was copied now no tables in dropdown list


Your version of Access may require slightly different menus and clicks than mine, but the procedure is straightforward and should be very similar to what you will need to do. Read the whole post first!

Make sure you have permission to modify the database, then go to the form (I assume the drop-down table is in a form) and go to design view.

In design view, click once on the dropdown box you are having a problem with, and a properties screen with several tabs should pop up; click on the data tab, and look at 'data source'. In the list look for 'row source type' to see if the source of your data is a) a table or a query, b) a value list or c) a field list. Most dropdown boxes use either a value list or data from another table or a query (based on a table).

Check the source of data by going down to the next line in the list titled 'Row Source' (this is the list on the data tab that popped up when you clicked on the dropdown box in design view).

If the source is a table/query type you should see some code in the Row Source box like "SELECT....". Without changing anything, click once immediately to the right of the box, and whatever source the rows are coming from should pop up--if a query, for instance, it will pop up the underlying query in design view.

You should be able to troubleshoot the underlying query to see why no data is given in the dropdown box.

Another point where underlying query or table is used: If the table was based on a query that pulls data from the records in the current database, the drop down list will be blank until new records are added so the query has something to list.

And if the source is a 'value list', the values should be included in the row source box below, separated by semicolons. If not you simply need to add them in.

If your source is a field list, go back to whomever copied the database and tell them you need help with the copy they gave you...

Sep 13, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

7 Answers

Undelete records from access table


ou can try to use third party Access recovery utility to restore your lost and damaged data from .mdb files. For more details about this software:-
Access File Recovery

Apr 17, 2009 | Microsoft Access 2000 (077-01277) for PC

1 Answer

Application and example of relationship in access


Relationships

After you've set up multiple tables in your Microsoft Access database, you need a way of telling Access how to bring that information back together again. The first step in this process is to define relationships between your tables. After you've done that, you can create queries, forms, and reports to display information from several tables at once.

A relationship works by matching data in key fields - usually a field with the same name in both tables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the other table. For example, teachers can be associated with the students they're responsible for by creating a relationship between the teacher's table and the student's table using the TeacherID fields.

Having met the criteria above, follow these steps for creating relationships between tables.
  1. In the database window view, at the top, click on Tools ---> Relationships
  2. Select the Tables you want to link together, by clicking on them and selecting the Add Button
  3. Drag the primary key of the Parent table (Teacher in this case), and drop it into the same field in the Child table (Student in this case.)
    relationshipdrag.jpg
  4. Select Enforce Referential Integrity
    refintegrity.jpg
    • When the Cascade Update Related Fields check box is set, changing a primary key value in the primary table automatically updates the matching value in all related records.
    • When the Cascade Delete Related Records check box is set, deleting a record in the primary table deletes any related records in the related table
  5. Click Create and Save the Relationship

Apr 09, 2009 | Microsoft Computers & Internet

1 Answer

Hi, Need to create multiple running auto numbers in one table in one field, can anyone help?, am using access2000.


you can add page #'s in reports, insert, page #
you can't add auto #'s in the table without just adding the # in one field for each one
Access is a database program, the report option is where the page or file # is entered
I hope this helps

Apr 08, 2009 | Microsoft Access 2000 Step by Step...

1 Answer

How to export table in ms access to excel


yes you can export your access data into excel, follow steps on how to export.

1. open your access database
2. open the table data you to export
3. under table data view click tools menu
4. select analyze
5. select ms excel
6. this will open your seleted access table in excel

hope this will help you..

Dec 13, 2008 | Microsoft Access 2002 for PC

2 Answers

Wizard unable to create form


i had this problem and it was because a computer class was installing multiple kinds of access on one computer. they wanted to teach all of them, but are now screwing them all up. ha.

Nov 10, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Access 2007 forms wizard


If you run a repair install of office 2003

Jun 04, 2008 | Microsoft Office Professional 2007 Full...

3 Answers

Ms access


before this u should know what is databse.
ms access has various objects likw table,form,query,report etc..
table is a object which stores the actual data and form is used to enter the data in to the table and display the data from the table, while report is object which is used to desplay your data in required formate.Query is used to fetch the data from the table in customised formate.for that u should have knowledge of SQL.

Nov 14, 2007 | Computers & Internet

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

108 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2994 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...