By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,526 Members | 1,895 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,526 IT Pros & Developers. It's quick & easy.

User Information for report titles, etc.

P: 5
I have a church database set up with multiple forms and reports. I would like to have the user input their own church name, address, etc. into a form which is stored in an underlying table and which is then used to provide the church name and address automatically into various reports. Any ideas on how to set something like this up?

I have tried setting up a table with an input form, and then trying a query linking to the table, but when I insert it into a form or a report, it wants to insert the whole datasheet. I haven't figured out how to do just the church name or just the address.

Suggestions appreciated.

I am using Access 2003 with Windows XP in English.

Dec 7 '06 #1
Share this Question
Share on Google+
4 Replies

P: 33
a form which is stored in an underlying table
Can you elaborate on that statement? It seems odd to store a form in a table... My guess is that you have a table in the back, and a form in the front which simply populates the table and/or reads from it.
Dec 7 '06 #2

Expert Mod 15k+
P: 31,476
While you're about it, post the details of which fields are stored in which tables and how these tables (if more than one) are related (PKs FKs etc).
Which fields are to be shown on the form and which of those fields need to be stored.
Otherwise it's a bit confusing.
Dec 7 '06 #3

P: 5
Sorry for the confusion...I have a form called UserInfo which is used to enter only one record into the underlying table called UserInfo. the fields in the table include: churchname, churchaddress, churchcity, churchstate, churchzip. The form is used to enter the information that is then used to personalize the main MembersForm, and various reports, using the churchname, etc.

I only want the church to enter its own data into the one record so that they can personalize it for their use. There is no need for additional records in that table. I would like the name of the church to show up on the main Members Form, which is the main screen that opens up first. I would also like to somehow link my report titles to that information so that they automatically enter the church name and address into each report when they are viewed and printed.

If there is an easier or better way of doing this, I'm willing to try that also.
Thanks Again
Dec 9 '06 #4

Expert Mod 15k+
P: 31,476
It starts to make sense :).
You need a form for your 'Church' table but once it has been created by the wizard you can easily remove any fields you don't want. Make sure the 'Data Entry'; 'Allow Additions'; 'Allow Deletions' are all turned off but the 'Allow Edits' is turned on for this form (after you have a single record at least). You can enter a blank record for any church as part of the design before sending it out.
Other forms and reports can quite happily use the Domain Aggregate function DLookup() to get data from this table as the overhead of that function with a one record table is minimal.
Does this answer your question?
If you need further info/help please just ask.
Dec 9 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.