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 2 / July 2007

Tip: Looking for answers? Try searching our database.

Unbound Subform

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

I known that is more or less easy to set up a unbound form and it is
possible to create, but I have never seen a unbound subform.
Is it possible to create a unbound subform (Datasheet layout)?

If it's´possible, I will be very grateful if I could have some codes's
examples explaining how to update/include/exclude datas in the table
form this "unbound subform".

A subform with datasheet layout is like a excel sheet, ok? Then I have
doubts about how to update the datas line by line, I don't have any
idea how do it!

Thank you!!!

André.
Baz - 27 Jul 2007 12:41 GMT
An unbound subform will show no data, whatever view it is in.

A form or subform in datasheet view is nothing like an Excel sheet, except
in superficial appearance.

Sounds to me like you are on the verge of making a lot of mistakes with your
design.  If you explain what you are trying to achieve in functional terms
I'm sure you'll get pointed in the right direction.

Dear all,

I known that is more or less easy to set up a unbound form and it is
possible to create, but I have never seen a unbound subform.
Is it possible to create a unbound subform (Datasheet layout)?

If it's´possible, I will be very grateful if I could have some codes's
examples explaining how to update/include/exclude datas in the table
form this "unbound subform".

A subform with datasheet layout is like a excel sheet, ok? Then I have
doubts about how to update the datas line by line, I don't have any
idea how do it!

Thank you!!!

André.
gatarossi@ig.com.br - 27 Jul 2007 14:35 GMT
Dear Baz,

In my database I have these tables:

1)    expense_code - fields: expense_code, expense_description
2)    profit_center - fieds: profit_center_code,
profit_center_description
3)    period - fields - fields: period
4)    expenses_control: expense_code, profit_center, period, values_USD

I made a relationship between the fields in the three first tables
with the last table, the name of the fields are the same.

Then I have tried everything to do a form/subform to update/include/
exclude values in my table expenses_control (since Mai/07!). My
problem is that I need that the form/subform has this layout (more or
less an Excel´s sheet):

Form:
profit_center (combobox): the user will select the profit center
period (multiselect listbox): the user will select as many dates as he
wish, and for each date selected will appear one column in the subform

Subform:
expense_code     first date selected    second date selected  third
date selected ...
salary                           100
110                              120
taxes                             50
60                                 70
.
.
.

Is it possible?

Thank you.

André.
Baz - 27 Jul 2007 16:21 GMT
That is absolutely not possible.  I'm afraid I still don't understand the
purpose/function of the subform, so I can't suggest an alternative approach.
However, you may be using the wrong tool: if you are trying to perform some
kind of financial analysis or make some kind of chart, you might be better
off in Excel, it isn't really what Access is for.  Or, investigate the
PivotTable view of an Access form, which is a bit of an Excel-type thing but
not as good as Excel.

Dear Baz,

In my database I have these tables:

1) expense_code - fields: expense_code, expense_description
2) profit_center - fieds: profit_center_code,
profit_center_description
3) period - fields - fields: period
4) expenses_control: expense_code, profit_center, period, values_USD

I made a relationship between the fields in the three first tables
with the last table, the name of the fields are the same.

Then I have tried everything to do a form/subform to update/include/
exclude values in my table expenses_control (since Mai/07!). My
problem is that I need that the form/subform has this layout (more or
less an Excel´s sheet):

Form:
profit_center (combobox): the user will select the profit center
period (multiselect listbox): the user will select as many dates as he
wish, and for each date selected will appear one column in the subform

Subform:
expense_code     first date selected    second date selected  third
date selected ...
salary                           100
110                              120
taxes                             50
60                                 70
.
.
.

Is it possible?

Thank you.

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



©2009 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.