Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-25-2005, 01:51 AM   #1
Justchris
Registered User
 
Join Date: Feb 2005
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Justchris is on a distinguished road
Help with a command button on a userform

I have 2 questions here, First I have a lot of info to enter a night. Should I make 3 seperate tables for my data and use 3 seperate forms or should I make 1 Large table using 3 forms to input data to it?

How can I link the forms using a command button? All 3 forms are made from the same table at this point, but when I use the toolbox to make a command button it only has an open form. This creates new records for each form.. I need it to all be linked, When I push the page 2 button i need it to open the other form for continues editing for the current day im working on without it starting a new record on the table.

Any help would be awesome
Thanks
Chris

Justchris is offline   Reply With Quote
Old 02-25-2005, 03:29 AM   #2
ColinEssex
Old registered user
 
ColinEssex's Avatar
 
Join Date: Feb 2002
Location: Essex, UK
Posts: 8,126
Thanks: 2
Thanked 26 Times in 24 Posts
ColinEssex will become famous soon enough
Quote:
Originally Posted by Justchris
First I have a lot of info to enter a night. Should I make 3 seperate tables for my data and use 3 seperate forms or should I make 1 Large table using 3 forms to input data to it?
It depends on what you are doing. For example, you could have customers (one table) and Orders (2nd Table) linked by CustomerID (autoNumber)
You don't have Customer demographic details and Order Details in the same table otherwise you're up a creek if a customer changes address for example.

Decide which is a "One" (like customer) and which is a "many" (like orders)

You should use a query as the recordsource for a form, not a table.

Tell us what your database is recording, that'll help people decide which way is best for you. Be aware though that you need to get this bit right or you'll have problems further down the line when you want to do reports and queries on the data.

Col
__________________
"America is pregnant with promises and anticipation, but is murdered by the hand of the inevitable."
ColinEssex is offline   Reply With Quote
Old 02-25-2005, 04:34 AM   #3
Justchris
Registered User
 
Join Date: Feb 2005
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Justchris is on a distinguished road
Actually, this is to keep updated records of financial info. I get a print out of numbers every night with things like total room revenue, total restuarant revenue, taxes and basically all revenue for the day. I get a nice long list from 1000 to 9000 of diffrent stuff ranging from banquet receptions to rollaway beds. I'm a night auditor at a hotel and ive been asked if i could design a system to keep updated records on a daily basis that can be changed if need be. I figured the query would be for the calculations such as figuring out taxes and summing room revenue and so on. I dont need indivual profiles or anything like that. All I need is a way to sort my information by date and date alone. I was doing all this in excel untill they told me that I have to keep a running total. And I have to be able to edit previous days information changing that running total. I'm totally new to access and im not even sure if i should be using it.

Thanks
Chris


Last edited by Justchris; 02-25-2005 at 04:39 AM.
Justchris is offline   Reply With Quote
Old 02-25-2005, 10:45 AM   #4
Justchris
Registered User
 
Join Date: Feb 2005
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Justchris is on a distinguished road
Should I be using access?
__________________
In an infinite universe there are infinite possibilities.
Justchris is offline   Reply With Quote
Old 02-25-2005, 12:10 PM   #5
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,271
Thanks: 15
Thanked 1,595 Times in 1,515 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Access is the ideal tool for managing data. You only need one form and one table to hold the data. You can use a combo box on the table to enter the three types of data, room revenue, resturant revenue, and tax. But I would actually create a small table to hold these lookup values. It will be easier to manage in the long run. Then on the form, you would use a query of this lookup table as the RowSource for the combo. You should also create a relationship between the main table and the lookup table so you can enforce referential integrity.

Given the nature of your data entry, you probably want to copy certain values from the previous record such as the TransactionDate and TransactionType. So to speed up the data entry, you can change the field order on the form to Amt, TransactionType, TransactionDate. Then in the BeforeInsert event of the form, get the value from the previous record for the Type and Date fields. Then you only have to type data in them when they change.

Create queries and reports to analyze the data once you have entered it.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 08:56 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World