1)VB code or Wizard? 2) Subform or filter? 3)combo box problem

[Guest]

I am a new user, I wish i can get some answer over here, I think it is easy
but i really new and know nothing.

1) Using wizard to create database or VB code ? Which 1 better? and Y?

2) I using wizard to create a form c/w subform as per below
Main Form
[YearMonth] : 200609 =>[YearMonth] is a field from table period
Subform
[Transaction]
(detail or all fields from table Transaction excluding field YearMonth) Year
2006 Sept will appear.

Wat diff if I using filter to list out all transaction for Year 2006 Sept?

3) Inside Transaction I have many customer so i using filter to filter the
transaction base on customer i selected from a Combo box (which row source
from table customers, field customerID) because of this the combo box will
list out all customer i have even some customer didnt have any transaction
on
200609 it still will show inside combo box

So can my combo box only list out those customer who has
transaction on the patricular yearmonth? but only once although that
customer might have more than 1 order on the patricular yearmonth.

 

[John Vinson]

I am a new user, I wish i can get some answer over here, I think it is easy
but i really new and know nothing.

1) Using wizard to create database or VB code ? Which 1 better? and Y?

I'd say neither. I'm not aware of any wizards to create an entire
*database*; there are form wizards, report wizards, etc. to create
objects in databases and they can indeed be useful. Creating a
database from scratch using VBA code is possible but requires an
advanced knowledge of VBA and at best is MUCH harder than creating it
from scratch.

Design your tables (on paper, using a pencil and a good eraser) with
proper normalization; create the tables just using the New Table
command; set their relationships in the relationships window; then, if
you wish, use wizards to create Forms for data entry and editing.

2) I using wizard to create a form c/w subform as per below
Main Form
[YearMonth] : 200609 =>[YearMonth] is a field from table period

What's the datatype of this field? Any reason not to use a Date/Time
field instead? What's the Table for this form?

Subform
[Transaction]
(detail or all fields from table Transaction excluding field YearMonth) Year
2006 Sept will appear.

Wat diff if I using filter to list out all transaction for Year 2006 Sept?

I don't understand. I would recommend basing the Subform on an
appropriate Query, rather than using a complete table and then
filtering, if that's what you're getting at.

3) Inside Transaction I have many customer so i using filter to filter the
transaction base on customer i selected from a Combo box (which row source
from table customers, field customerID) because of this the combo box will
list out all customer i have even some customer didnt have any transaction
on
200609 it still will show inside combo box

Again... I don't understand. Can't you add another criterion to
exclude that month?

So can my combo box only list out those customer who has
transaction on the patricular yearmonth? but only once although that
customer might have more than 1 order on the patricular yearmonth.

Set the Query's Unique Values property to True.

John W. Vinson[MVP]

 

[Larry Daugherty]

John,

I think OP may be referring to the template databases that jump up
when you open Access and elect to "create a new database".

HTH
--
-Larry-
--

I am a new user, I wish i can get some answer over here, I think it is easy
but i really new and know nothing.

1) Using wizard to create database or VB code ? Which 1 better? and

Y?

I'd say neither. I'm not aware of any wizards to create an entire
*database*; there are form wizards, report wizards, etc. to create
objects in databases and they can indeed be useful. Creating a
database from scratch using VBA code is possible but requires an
advanced knowledge of VBA and at best is MUCH harder than creating it
from scratch.

Design your tables (on paper, using a pencil and a good eraser) with
proper normalization; create the tables just using the New Table
command; set their relationships in the relationships window; then, if
you wish, use wizards to create Forms for data entry and editing.

2) I using wizard to create a form c/w subform as per below
Main Form
[YearMonth] : 200609 =>[YearMonth] is a field from table

period

What's the datatype of this field? Any reason not to use a Date/Time
field instead? What's the Table for this form?

Subform
[Transaction]
(detail or all fields from table Transaction excluding field YearMonth) Year
2006 Sept will appear.

Wat diff if I using filter to list out all transaction for Year

2006 Sept?

I don't understand. I would recommend basing the Subform on an
appropriate Query, rather than using a complete table and then
filtering, if that's what you're getting at.

3) Inside Transaction I have many customer so i using filter to filter the
transaction base on customer i selected from a Combo box (which row source
from table customers, field customerID) because of this the combo box will
list out all customer i have even some customer didnt have any transaction
on
200609 it still will show inside combo box

Again... I don't understand. Can't you add another criterion to
exclude that month?

So can my combo box only list out those customer who has
transaction on the patricular yearmonth? but only once although that
customer might have more than 1 order on the patricular yearmonth.

Set the Query's Unique Values property to True.

John W. Vinson[MVP]

 

[John Vinson]

I think OP may be referring to the template databases that jump up
when you open Access and elect to "create a new database".

Thanks - quite likely. This will be a much more FAQ in 2007 obviously!

John W. Vinson[MVP]

 

[Guest]

Set the Query's Unique Values property to True.
but
Still cant...... return nothing
which query to set?

I am a new user, I wish i can get some answer over here, I think it is easy
but i really new and know nothing.

1) Using wizard to create database or VB code ? Which 1 better? and Y?

I'd say neither. I'm not aware of any wizards to create an entire
*database*; there are form wizards, report wizards, etc. to create
objects in databases and they can indeed be useful. Creating a
database from scratch using VBA code is possible but requires an
advanced knowledge of VBA and at best is MUCH harder than creating it
from scratch.

Design your tables (on paper, using a pencil and a good eraser) with
proper normalization; create the tables just using the New Table
command; set their relationships in the relationships window; then, if
you wish, use wizards to create Forms for data entry and editing.

2) I using wizard to create a form c/w subform as per below
Main Form
[YearMonth] : 200609 =>[YearMonth] is a field from table period

What's the datatype of this field? Any reason not to use a Date/Time
field instead? What's the Table for this form?

Subform
[Transaction]
(detail or all fields from table Transaction excluding field YearMonth) Year
2006 Sept will appear.

Wat diff if I using filter to list out all transaction for Year 2006 Sept?

I don't understand. I would recommend basing the Subform on an
appropriate Query, rather than using a complete table and then
filtering, if that's what you're getting at.

3) Inside Transaction I have many customer so i using filter to filter the
transaction base on customer i selected from a Combo box (which row source
from table customers, field customerID) because of this the combo box will
list out all customer i have even some customer didnt have any transaction
on
200609 it still will show inside combo box

Again... I don't understand. Can't you add another criterion to
exclude that month?

So can my combo box only list out those customer who has
transaction on the patricular yearmonth? but only once although that
customer might have more than 1 order on the patricular yearmonth.

Set the Query's Unique Values property to True.

John W. Vinson[MVP]

 

[John Vinson]

but
Still cant...... return nothing
which query to set?

I'm sorry, Kaoli, I have no idea what you mean.

Please post with a bit more information - the SQL of the query for
example. Remember - *you* can see your computer. We cannot.


John W. Vinson[MVP]