Go Back   DeveloperBarn Forums > Databases > Microsoft Access

Sponsored Links

Discuss "Form for multiple tables and queries" in the Microsoft Access forum.

Microsoft Access - Microsoft Access is a database for small to medium applications. Learn tips and tricks and best database practices here.


Reply « Previous Thread | Next Thread »  
 
LinkBack Thread Tools Display Modes
  #1  
Old August 21st, 2008, 05:06 PM
Barn Regular

 
Join Date: Jul 2008
Location: Philadelphia, PA
Posts: 76
Thanks: 8
Thanked 0 Times in 0 Posts
Rep Power: 1
nboscaino is an unknown quantity at this point
Default Form for multiple tables and queries

I made an entry form with the wizard
It has all the fields for for entry
I have queries process that information and I would like to have it read back on this form. I understand that the query will not automatically update to subsequent information so I imagine I will enclose a button "Save and Recalc" that will rerun the query with this need infomation

Example

Table
Date
Income
Expenses

Query
average income 180 days

I want that to be featured on the form. how do i make it available

the text box only allows me to display info from the table. How do I open it up to other things?
Reply With Quote
Sponsored Links
  #2  
Old August 21st, 2008, 06:55 PM
Barn Regular

 
Join Date: Jul 2008
Location: Philadelphia, PA
Posts: 76
Thanks: 8
Thanked 0 Times in 0 Posts
Rep Power: 1
nboscaino is an unknown quantity at this point
Default

This is in addition to the post above

This is the sample of the database that I am making. I want to query the checking and then read out on the entry form the current tally
Attached Files
File Type: zip LifeManagementDB.zip (55.1 KB, 6 views)
Reply With Quote
Reply

  DeveloperBarn Forums > Databases > Microsoft Access

Bookmarks

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Having real trouble with update queries nboscaino Microsoft Access 1 August 4th, 2008 02:26 AM
Multiple Updates Shem .Net Development 4 July 8th, 2008 01:29 PM
Preventing Multiple Logins richyrich .Net Development 17 July 4th, 2008 04:33 PM
Dynamic dropdown list with multiple records Rebelle ASP Development 4 April 30th, 2008 05:33 AM
Permissions on Tables, Stored Procedures, etc. theChris Microsoft SQL Server 2 March 24th, 2008 11:49 AM


All times are GMT -4. The time now is 12:27 PM.



Content Relevant URLs by vBSEO 3.2.0