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 / Forms Programming / July 2007

Tip: Looking for answers? Try searching our database.

Building Form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
gatarossi@ig.com.br - 05 Jul 2007 11:34 GMT
Dear all,

I have tables with this fields:

expenses_control: expenses_code, profit_center, date, value.
date: date
profit_center: profit_center_code, profit_center_description
expenses: expenses_code, expenses_description

The relationship between the tables are:

expenses_control.expense_code = expenses.expense_code
expenses_control.profit_center = profit_center.profit_center_code
expenses_control.date = date.date

Now I'm trying to do a form to imput, to include and to exclude data/
values (not for consults!), like that:

---------------------------------------------------------------------------­---------------------
                              EXPENSES CONTROL
Form:
profit_center:__A______________(it's a combobox where the user will
select the profit center).

profit_center_description:_industrial_(it will change according to
profit_center combobox).

date:____________(it's a multiselect combobox where the user will
select the dates - below I will explain better how it must work!!!)

Subform:

expense   expense_description    01/01/07    01/02/07    01/03/07
10             salary                            10
10,5          11
20             other expenses                2
1,5           3

---------------------------------------------------------------------------­----------------------
Now it's my problem: We can see in the column of the subform whith
the
dates, before I describe my problem, the information in the table is
like that:

expenses    profit_center      date           value
10                A                    01/01/07      10
10                A                    01/02/07       10,5
10                A                    01/03/07       11
20                A                    01/01/07        2
.
.
.

Can I choose dates in the multiselect combobox of my form and it's
appear in columns in my subform? (to include values, etc - not only
to
consult).

Thanks!!!

André.
Dennis - 05 Jul 2007 19:18 GMT
I hate to say this, but I have NO IDEA what he asked.

> Dear all,
>
[quoted text clipped - 57 lines]
>
> André.
John W. Vinson - 05 Jul 2007 21:12 GMT
>I hate to say this, but I have NO IDEA what he asked.

I have read it three times and I have no idea either.

            John W. Vinson [MVP]
gatarossi@ig.com.br - 06 Jul 2007 11:51 GMT
Dear all,

Let´s think in a form like a pivot table (but not exactly a pivot
table, because I have a problem: I will use this form to include to
alter or to exclude values - not for consults) :

In the page (form) we have the filters: profit_center and date*
In the column (subform) we have the dates that I selected in the
filter-field date
In the lines (subform) we have the expense_code, expense_description
and values

* date: it will be a multiselect listbox or combobox that consist in:
when we select the date, the date will appear in the column's position
in my form

Then what the user will do (for example):

I would like to include values in 01/02/07 and to alter values in
01/01/07 in the industrial profit_center:

Then in the combobox/listbox profit_center in my form I will select
the industrial profit_center.

After I will go to my second filter in my form: the dates. Then I will
select the months 01/01/07 and 01/02/07 (when I select this two months
it will appear in my subform two columns referring these months) yes -
it´s like a excel sheet or a pivot table!

Then I go to my subform (it's like that):

expense_code    expense_description       01/01/07         01/02/07
10                       salary
10*                 11*

* these are the values that I need to include, to exclude and to
alter!

It's clear now?

Thanks a lot!

André.
 
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.