Question Guidance on An Access 2007 application project

[msaccesspatc]

HELP, I'm trying to create my first MS Access 2007 project that provides the user the ability to update Linked sql server tables. I've created forms, subforms, linked tables, queries, but have nothing to give my project leader which is embarrassing. I have a basic knowledge of access but need a high level view and understanding in order to design the app. So in general, I need someone who has done a project like this to guide me on what is the best/simplest way to first present (meaning, navigation form,switchboard,main form) all the options that the app user must be able to do. Described below :

First , there are 3 tables and 3 different environments(development,test,prod). In development the user has full update authority(insert,delete,update). In test and prod, they can only insert( or delete then insert),, my project leader calls this "promote". So a promote can be done whether the record is in the sql table or NOT. The user should also be able to view(read) test and prod.

Besides the environment choice that needs to be chosen, two search fields are needed to query the table(S) to be presented on the form.

Once the environment is known and the search field is known, a query of the 3 tables must be done and a display of all the pertinent records. There is a one to many relationship, and all three tables and rows must be displayed on the form(per the search criteria). The user will then view the records for information, or view and promote or view /change and promote.
Can this be done all in access with property changes on a form (readonly vs editable), since some environments are non-updatable.?
So, first question is how should I best present the application. If you say navigation form, I can search/teach/view a tutorial. If someone has done this simple project, I’d like to imitate it !! Thanks,, a freaked-out dba who wants to learn MS Access.

 

[CJ_London]

This sounds like homework

1. put in writing what the application is required to do
2. put in writing how it is going to do it
3. now design the tables with regards 1 and 2
4. then design the queries and forms/reports

You may need a navigation form or you might find all can be accomplished on one form - it all depends on how you design it

This

I've created forms, subforms, linked tables, queries

says you should know the answer to this

Can this be done all in access with property changes on a form (readonly vs editable), since some environments are non-updatable.?

of course the answer is yes

 

[spikepl]

And with just a little more effort you can make your post almost unreadable .

 

[msaccesspatc]

Don't understand your reply Too cynical for me to reply intelligently, But thanks for your time.

 

[msaccesspatc]

This sounds like homework

1. put in writing what the application is required to do
2. put in writing how it is going to do it
3. now design the tables with regards 1 and 2
4. then design the queries and forms/reports

You may need a navigation form or you might find all can be accomplished on one form - it all depends on how you design it

This
says you should know the answer to this

of course the answer is yes

Hi CJ_London, I appreciate your quick reply and like the simple steps to be used on any upcoming project. I did steps 1 and 2 as you describe above and 3.4 will take time of course. But wanted to respond as quickly as possible... THANKS, you're very kind
msaccesspatc

 

[msaccesspatc]

CJ London helped and I have a direction. I have 3 subforms showing records from 3 related tables (readonly). Now I want to change mode: I have a label called MODE and combo Box with read,Edit , Insert.

On an insert the user wants several drop downs with all the choices that exist from the table ..(I'm fine there ....select distinct Ycolumn from Xtable). But NOW , the edit and readonly mode have a blank on the form/field when I want the value displayed from the table.

QUESTION... Do I need to open the one form for a read or edit.. AND create a different form with a bunch of combo Boxes for an insert? Or is there a simpler way? I also thought I can have JUST one form for either mode, that is making the label/text fields invisible for an insert , and making the comobox visible and for a read/edit do the opposite.. seems like a lot of work , is there another tool I am not thinking of and can research?
thanks for your idea
msaccesspatc

 

[CJ_London]

you only need the one form in principle, I just don't understand what the bunch of comboboxes is all about

the edit and readonly mode have a blank on the form/field

sounds like you have set the form as data entry

 

[msaccesspatc]

Thanks CJ_London for your help. The combo boxes were NOT necessary in readonly. I used the table column values to fill-in the text box by finding the record searched on.. Now, the need is to allow a new record to be entered. I am asked to display all the available values from the table, that is where the combo box comes in . I select distinct on all columns that want a drop down displayed , for example, applicationName, RecipientName,etc. I hope that gives the idea. So , going back to my previous post, my dilemma is , when i eliminated the "text box" for readonly, and created the combo box for recipient, now for a read, the recipient has no value in it, but the drop down exists. I don't want the user TO PICK the recipient from the combo, I want my application to get the value from the table when reading.

 

[CJ_London]

sorry, still as clear as mud