Jump to content
Sign in to follow this  
topshelfva

Access

Recommended Posts

Hi everyone: smile.gif

 

I am hoping someone can help me. I have not used Access for years and now have to develop a database. I am trying to figure out how to take the six tables in the database and put them all onto one form. Here is what I am struggling with.

 

1. The database is Churches

 

2. The tables are Location, General, Funding, Assets, People Served, Programs.

 

3. I made the Church the primary key on all the tables (is this correct)?

 

4. I want to make one form with all the tables' information on the form; however, I would like to enter the Church name only once and have it appear on all tables. That is not happening. What am I doing wrong?

 

Help!

Share this post


Link to post
Share on other sites

Okay, I think I have answered my own question. I have to set up a query first, then develop the form from the query. So far, it looks like all the church names can be entered once and go to all the tables.

 

If I am off base on this, oh ye Access Expert, whomever you may be, please let me know. smile.gif

Share this post


Link to post
Share on other sites

Well, shoot, I am still doing something wrong. When I tried with three it worked, when I tried with six it didn't. Sigh, I still need help. smile.gif

Share this post


Link to post
Share on other sites

Okay, this is where the face becomes red and I have to say, it is 5:00 p.m., I better close shop soon. I thought you would like a laugh. Even though the form has the fields, if you do not fill in at least one of the fields for that particular table's information, then guess what, it's not going to transfer the Church's name. Oh well. It only took me an hour and a half to figure out that no brainer. (I did say that it has been several years since I even looked at Access, right?) Sigh, I'm going to go walk around the neighborhood. LOL

wacko.giflaugh.gif

Share this post


Link to post
Share on other sites

hehe Naomi...isn't that always the way? I had a formatting problem today in Excel myself and spent half the day trying to figure it out...still with no answer. I am trying to design drop down lists in the top of each column to sort the columns by if that makes any sense. I have an example of what I want in another spreadsheet but can't figure out how they did it yet. Live and learn. (still in learning stage and won't LIVE until I figure this out HA!)

 

Tawnya

Share this post


Link to post
Share on other sites
Guest

Hi naomi

 

I am a reluctant access vetran, actually more of a battle hardened warrior. You are correct you will need to set up the relationships first.

 

For example your church to Parishioners is a one to many relationship. The next step is to use a form with a subform. The form will be for the church and the subform contains the parishioners. Subform/Subreport is one of the items you can choose from the toolbox when you are in form design mode. When you chose this tool a wizard will guide you through the process.

 

It may be easier to work from an example. If you take a moment to create a "new" database and use the "Ledger wizard", it has an example of a form with a subform. The "Account" form contains a subform with "transactions" that relate to the account. So when you view a particular account. All the transactions for that acount will show up in the subform.

 

Tawnya,

 

I belive you may be looking for an autofilter. Highlight the cells you want to sort leaving a blank row at the top then select Data/Filter/Autofilter and one of those drop down lists will be created.

 

 

Therese

Share this post


Link to post
Share on other sites

Oh that is so kewl and soooooooo simple to do...thanks Therese!

 

(May I add, I've spent hours trying to figure this out and in seconds I just got the answer here....geesh, I should have come here first instead of being so stubborn headed) wink.gif

 

Tawnya

Share this post


Link to post
Share on other sites
Guest

Glad I could help.

 

You guys help me all the time. Coming here to the forum in the mornng

starts my day. I am in a bit of a procrastination rut at the moment and this

is a great place to help me get enthused and busy on my projects.

 

Ok enough with the sappy.

 

I have had a good sleep and had another thought about Naomi's database.

I know that a CRM database application would do everthing you need and more. I am familiar with maximizer which is quite expensive and complicated. However, it has user defined fields to capture the info you require. A church is a company and a parishioner is an employee. (just change the names) CRM applications also have marketing programs which would correlate to the church programs.

 

So my thought is perhaps purhasing an inexpensive simple CRM such as ACT! may save you some time and give your client a better system in the end.

 

my .02

 

Therese

Share this post


Link to post
Share on other sites
Coming here to the forum in the mornng

starts my day. I am in a bit of a procrastination rut at the moment and this is a great place to help me get enthused and busy on my projects.

I am with you here Therese! I start my morning here too, gets me motivated as well for my day.

 

T.

Share this post


Link to post
Share on other sites

Thanks Therese for your suggestion. However, ACT! does not work in this situation. My client is a professor and we are subjegated to the software the university uses. She is now thinking of going back to an Excel spreadsheet. I still could not get that form to work properly and since she needs this information pronto, I have told her I would do the database all in one table. Yes, I know that is not the best choice; however, since she says she needs the information now (her parameters of what information keeps changing), I think it would be best just to input it, get it to her, and her person there can run their queries.

 

Thanks for the suggestion. I am looking for a simpler book on Access, other than the MS book I have, which is not written for the end user in my opinion. Thus far I have received suggestions for the "Dummies," "Bible," and "Quest" books. I am going to check them out.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Want to Become a VA?
    Invest in The VAC!
    How Do YOU Startup A



    Are You a VAinsider?
    Virtual Assistant Organization Association
    Upgrade Your FREE Account & Receive Today...
    * Access to Our Job Board *
    * VA Training Tracks*
    * Group Coaching *
    * Private Mastermind Area *
    * Business Templates *
    * Contracts & Forms*
    *Checklist & eBooks *
    * Seminar Archives *
    * Plus VAinsider Perks! *
    UPGRADE HERE

    Virtual Assistant Organization Association





    HootSuite - Social Media Dashboard


    Click to see your AD here!


    Cool Virtual Assistant of the month!

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.