A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Form title



 
 
Thread Tools Display Modes
  #1  
Old October 15th, 2008, 07:24 PM posted to microsoft.public.access.tablesdbdesign
Anthony[_8_]
external usenet poster
 
Posts: 41
Default Form title

I created a simple form based on a table called Soldier Personal Data
with fields called Last Name, First Name, Rank. The table has 47
records in it at this time. The form is simply called Soldier Personal
Data Form but I would like to show the individual Soldier's Rank,
first and last name, when I as I look at. Can I do this? Thanks for
your assistance.
  #2  
Old October 15th, 2008, 09:36 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Form title

How is this a .tablesdbdesign question?

If you want a form to display data in an underlying query (preferred) or
table, open the form in design view and add a control to display that field.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Anthony" wrote in message
...
I created a simple form based on a table called Soldier Personal Data
with fields called Last Name, First Name, Rank. The table has 47
records in it at this time. The form is simply called Soldier Personal
Data Form but I would like to show the individual Soldier's Rank,
first and last name, when I as I look at. Can I do this? Thanks for
your assistance.



  #3  
Old October 15th, 2008, 09:41 PM posted to microsoft.public.access.tablesdbdesign
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Form title

Open the form in design view and drag the objects to where you want them
displayed.
--
KARL DEWEY
Build a little - Test a little


"Anthony" wrote:

I created a simple form based on a table called Soldier Personal Data
with fields called Last Name, First Name, Rank. The table has 47
records in it at this time. The form is simply called Soldier Personal
Data Form but I would like to show the individual Soldier's Rank,
first and last name, when I as I look at. Can I do this? Thanks for
your assistance.

  #4  
Old October 15th, 2008, 10:00 PM posted to microsoft.public.access.tablesdbdesign
Larry Daugherty
external usenet poster
 
Posts: 1,012
Default Form title

Yes, you can.

The simplest way to get started is to create your table first. Every
table should (read "must") have a Primary Key. Name a field SoldierID
and make its datatype Autonumber. Create fields for the other data
you will require. For ease of enhancement and maintenance of your
application, avoid spaces in field names.

Once your table is designed and saved, select it and click the
Autoform Wizard Icon at the top of the window. Answer the prompts and
make the choices and it will design a new form for you. You can do
that any number of times until you get a form that you like or
something close enough to what you want that you can later modify the
design.

When the wizard finishes you'll have a form suitable for adding or
editing records.

Using forms is a great leap forward for beginners. Another big step
will be when you buy in on the idea that you use Reports do display
and print data.

HTH
--
-Larry-
--

"Anthony" wrote in message
...
I created a simple form based on a table called Soldier Personal

Data
with fields called Last Name, First Name, Rank. The table has 47
records in it at this time. The form is simply called Soldier

Personal
Data Form but I would like to show the individual Soldier's Rank,
first and last name, when I as I look at. Can I do this? Thanks

for
your assistance.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:32 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.