Question about Microsoft Access 2002 for PC

1 Answer

How to print only selected fields in ms access.

I have a table, which has many fields like student id, name, roll num, Date of Birth, Date of Admission, Permant address, Present Address, Total Fees, Total Fees Paid, Balance etc.. Now i want the user should have the facility to select the field and print it.
please help me. is it possible. If yes tell me how?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 57 Answers

Open your table in query, follow steps to do this...

1. open new query in access
2. locate the table
3. once table selected, select field name in selected table you only want to include in query
3. once finished selecting the field save the query
4. you can now view selected field in your table and print as well
5. you can edit the query anytime if you want to add or remove field
6. query will not affect your table since this is only query.

hope this will help you....

Posted on Dec 16, 2008

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

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

WANT TO SET UP AN EMAIL


1. Visit the Yahoo Mail home page 2.Click on the 'Sign Up' link that appears somewhere near the top of the Yahoo home page3.Enter your name and other requested information in the fields provided. and Create a username.
5.
Type the username you choose in the field provided. 'Check Availability of This ID.'
6.if available
Choose a password You will be asked to type your password twice to ensure accuracy.
7.
Select your security question. Yahoo will ask you this question if you should forget your password in the future, in order to verify that you are the correct user. 8.Type in your answer to the question in the field below.
9.Enter your birth date, zip code and any other requested information in the fields provided. t.
10.Verify your registration by typing the characters you see shown in the last section of the registration page into the field provided
11.Read the Terms of Service thoroughly and print a copy for your records. 12.Select 'I Agree.' You have successfully set up your Yahoo email account.

CONTACT ME IF ANY PROBLEM OCCURS.

Apr 24, 2011 | Yahoo Search

Tip

HOW TO REMOVE ALL FIELD CODES FROM MS WORD DOCUMENT


The Field Codes always creates issues they are being printed.
To find and see if the field codes are in a document of not, first of all Field Codes needs to be visible.
To make them visible.
Open and MS Word Document.
Go to Tools --> Options
Select 'View' TAB over there.
either in Second or Third column an option would be available with name -
Field Codes - Check mark that option and below there will be an option that will ask 'When'.
There we need to select 'Always'
Hit OK at the bottom. Now all the field codes will be visible in a document if it is available.
To get rid of all the 'Field Codes' At once select the entire text by 'Ctrl+A'
--> 'Ctrl+Shirt+F9' (to remove the field codes at once)
--> 'Ctrl+S' (to save the documnet)

on Aug 08, 2010 | Microsoft Word 2003 for Students &...

1 Answer

What is the syntax for search in mysql database?


1.select * from tab;
will display all tables in database

2.if u know tablename then
select * from tablename;
It will display all data in the table

3.if u want specific information
eg : TableName:Students
Contains Fields: id , name.
select name from Students where id=1;

it will display name of student id=1

contact me for more information bhushan.softwaredeveloper@gmail.com

Rate It
Have a nice day

Mar 03, 2011 | Computers & Internet

1 Answer

I want to set up a facebook page


You can login to http://www.facebook.com then enter the fields given in the homepage like first name, last name, date of birth and email id. then select Sign up button

Jun 02, 2010 | Computers & Internet

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

MS Access-validation rule-for every value start with "E" or "V"


go to design view and select the Admission_Number field. At the bottom of the screen in the field properties section, select the 'Validation Rule' and input the following syntax: Like "E*" Or Like "V*"
The * indicates any character after the E or V.

Mar 21, 2009 | Microsoft Computers & Internet

1 Answer

How to use passwd character in a table in ms-access 2003


When you create table where you want to store passwords, go to Edit Table, then select a field where the password will be stored, go to Input Mask field in Properties and type Password in that field. That will set up the field needed for storing passwords.

Aug 18, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Hyperlink function in ms access


To Create a Hyperlink Field:


Display the table in Design view, create a new field to store the hyperlinks, click the new hyperlink field's Data Type box, click the list arrow, select Hyperlink, and save the table.
To Insert a Hyperlink:

Select the hyperlink field and then click the Insert Hyperlink button on the toolbar or select Insert , Hyperlink from the menu. Either select a file you want (use the Browse button to help you locate the file) or type a Web address for the hyperlink's destination and click OK.

To edit a Hyperlink: Right-click the hyperlink and select Hyperlink , Edit Hyperlink from the shortcut menu.


Is this enough?

Dec 21, 2007 | Microsoft Office Access 2003 (077-02871)...

1 Answer

How many primary keys in MS.Access


No, there cannot be two primary keys in one table. You can specify more than one value to make up the primary key. For example, instead of just the last name column - you can have the last name and employee ID fields make up the primary key. If you don't specify a primary key, MS Access will usually ask you if you would like them to create it for you. You may be thinking about foreign keys. A table can have two or more primary keys in them but they would serve as foreign keys. For example - lets say you have table A with primary key "A" and table B with primary key "B". You can create table C and have both primary keys from tables A & B in it, however, they would be foreign keys in table C and not primary keys (they are only primary keys in their respective tables).

Oct 02, 2007 | Microsoft Office Standard for PC

3 Answers

Viewing ms Sql Server database on Access


Are you familiar with "Linking" tables in Access? In Access: File --> Get External Data --> Link Tables. This will bring up a dialog box which allows you to browse to your SQL server and select the table you want.

Aug 23, 2007 | Microsoft SQL Server Standard Edition for...

Not finding what you are looking for?
Microsoft Access 2002 for PC Logo

Related Topics:

726 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...