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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Tables



 
 
Thread Tools Display Modes
  #1  
Old April 7th, 2010, 09:33 PM posted to microsoft.public.access.gettingstarted
Deedee27
external usenet poster
 
Posts: 1
Default Tables

Ok, I have a projects table and I need to make a form(not a query) because I
need it to be able to store the data. I don't know how to make it do what I
want it to do.


Project Catagory needs to be populated when hours on project are withih a
specific range.
ex: Project between 0-100 hrs = A


Project Catagory when chosen needs to show a list of items that need to be
marked as completed.
ex: If A then must complete 1, 2, 3, 4 ( check boxes need to store the
information of completed)

All fields are in 1 project table. I can create the form in design but can't
figure out how to make it all come together. any help would be greatly
appreciated!!

Dee

  #2  
Old April 8th, 2010, 12:18 AM posted to microsoft.public.access.gettingstarted
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Tables

I need to make a form(not a query) because I need it to be able to store
the data.
Forms do not store data. Data is stored in tables.

check boxes need to store the information of completed

Check boxes only display.

All fields are in 1 project table. I can create the form in design but can't figure out how to make it all come together.

What does 'make it all come together' mean? Normally forms are connected to
tables using a query or a source select statement that is actually a query as
it is written in SQL (Query Structured Language).


--
Build a little, test a little.


"Deedee27" wrote:

Ok, I have a projects table and I need to make a form(not a query) because I
need it to be able to store the data. I don't know how to make it do what I
want it to do.


Project Catagory needs to be populated when hours on project are withih a
specific range.
ex: Project between 0-100 hrs = A


Project Catagory when chosen needs to show a list of items that need to be
marked as completed.
ex: If A then must complete 1, 2, 3, 4 ( check boxes need to store the
information of completed)

All fields are in 1 project table. I can create the form in design but can't
figure out how to make it all come together. any help would be greatly
appreciated!!

Dee

.

 




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 12:39 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.