Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / February 2006

Tip: Looking for answers? Try searching our database.

easy question on forms/tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kaosyeti<[at]>comcast<[dot]>net - 03 Feb 2006 23:12 GMT
it may be because i'm having a BAD day but i can't come up with an easy way
to do this...
i want to have a form for recording one department's yearly forecasted data.
what i have is a column of months, to the right of which i have two text
boxes for entering units and gross.  the thing is the only way i could think
of to get this into a table was to have a table with a field for each
separate text box.  so i have:

form:

Month                            Units                       Gross
January                  ___________        ___________
February                ___________        ___________
etc...

for a table that has fields defined as:

janunits             number
jangross           currency
febunits             number
febgross           currency
etc...

when what i want is a table with these fields:

month              text
units                number
gross              currency

i've only ever worked with forms where the control source of each box is a
single field in a table.  i KNOW there must be a way to do this because it's
so simple.  i'm just out of it today.  thanks for looking.

Signature

Greg

Rick Brandt - 04 Feb 2006 11:53 GMT
> it may be because i'm having a BAD day but i can't come up with an
> easy way to do this...
[quoted text clipped - 29 lines]
> because it's so simple.  i'm just out of it today.  thanks for
> looking.

Use a continous form with a record per month...

ComboBox     TextBox        TextBox
for Month      for Units       for Gross

Signature

I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

kaosyeti<[at]>comcast<[dot]>net - 04 Feb 2006 15:35 GMT
ah-ha.  never heard of continuous forms before... is there any way for it to
automatically select the 12 months in the combo box upon opening the form so
that 12 records are showing and the combo box has the months pre-filled for
the user?  not exactly necessary but you don't know how SIMPLE this has to be
for the end users that i have in mind at my company.  some are just plain sad.
..8)

>> it may be because i'm having a BAD day but i can't come up with an
>> easy way to do this...
[quoted text clipped - 6 lines]
>ComboBox     TextBox        TextBox
>for Month      for Units       for Gross

Signature

Greg

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.