stuck

[mnghost]

hello all, im very new at access and i have been watching the videos on youtube to learn how to use access. I have access 2010. I have a few question which i need help on.
I have made a navagtion form with 9 taps.All the tabs have a table and form tied to it. What I would like to do is if i open it up and type in case 1 all the information that is tied in to case one should appear in all 9 tabs, if i type in case 2( which will have info from another case) should appear. ect ect.
The other question is how do i make it so its set up like a program, where i can click on a file and have a new file, open file save, export inport files.
What im trying to do is build a database that I can use while conducting paranormal investigations


In the end I would like to have this on my website so the other investigators and upload the reports to it. any help will be greatfull.

[June7]

Why should this same data appear on all tabs? Are you duplicating data into various tables? A principle of relational database is to NOT duplicate data.

What do you mean by 'set up like a program, where i can click on a file and have a new file, open file save, export inport files'? New file of what? Export/import what?

Web database is currently beyond my experience. You could try Sharepoint or ASP.net web pages.

[mnghost]

Why should this same data appear on all tabs? Are you duplicating data into various tables? A principle of relational database is to NOT duplicate data.

What do you mean by 'set up like a program, where i can click on a file and have a new file, open file save, export inport files'? New file of what? Export/import what?

Web database is currently beyond my experience. You could try Sharepoint or ASP.net web pages.

putting on the web is way down the road. Im adding a screen shot of what im doing and it might help out on what I'm trying to do. What i'm trying to do is when we get a case we then will fill in all the fields in each tab and then save it. So if we have 10 cases and i want to go back and add to case 2 i would like everything that is tied into case 2 to show up.
is this something that access can do or do i need something different?

[June7]

You bind the forms to data (RecordSource property) and bind controls to fields (ControlSource). Binding can be directly to table or a query. This is basic Access functionality and Help has guidelines.

Then either use code to open form filtered to the desired record or use the Access intrinsic tools to search/filter on the form.

[mnghost]

ok... now being a newbie to all this, how do i do that?

[June7]

Building bound forms is very basic Access functionality. Access Help has guidelines. Search Help on 'create form'.

[mnghost]

or i got a feeling that this is out of my leage, if i gave you the file can someone do that for me?

[June7]

You can post the file but I doubt anyone will build for you. I would look at and see if I can figure out what you need to do, but not going to build for you. This is basic, you should learn.

How did the navigation form get built to begin with? If you used wizard, should already be bound.

[mnghost]

I'm all for learning. I just started today but watching the video on youtube on how to use access, but it seems that they do gloss over a few things. When i made that navagation i went into create and then i went to navigation and clicked on that and then went to town. What works for me is someone tellimg me what icon to use and what to look for when im doing this. Right now I'm just hacking my way thru without a map.

[June7]

Then suggest you get a map. An introductory book on Access with tutorials should get you familiar with basics. A forum is not the place to learn basics.

[mnghost]

well sorry for being new at this and asking questions. not all of us have the full understanding. i would have thought a forum would be a great place to learn and ask questions,but i did not realise that prior knowledge is needed. i will go elsewhere where other people would be more helpful than be talked down to.

[June7]

I did not mean to insult, but I was being direct. (And I did offer to analyse your db if you would provide.) Most responders here (and in any forum) are volunteers and don't have the time nor inclination to provide step by step instruction for basic concepts that should be understood before attempting database development. As you didn't understand how a form is bound and didn't even know if your form is bound, indicates lack of basic knowledge. You did not seem to understand even after I directed you to properties (RecordSource and ControlSource) that are used for binding.

You need a fundamental understanding of relational database principles, Access functionality, and programming (macros and/or VBA). Attempting to build a database after barely 1 day of learning is guaranteed to be frustrating for you and anyone helping. You attempted a big leap with creating a navigation form so soon. Also, letting the wizards do work for you is convenient but subverts gaining deeper understanding of design.

There are already plenty of resources for learning basics that make repetition in forum posts redundant. The best preparation you can do is to complete an introductory book, working through all exercises, and gain the basic knowledge before attempting custom db design. However, if you want to stay with web-based learning, try:
http://databases.about.com/cs/tutori...accessgup4.htm
http://www.functionx.com/access/
http://office.microsoft.com/en-us/ac...010232684.aspx
http://office.microsoft.com/en-us/ac...010341717.aspx