Form for mealplan

E

Esrei

I have this query:

SELECT [Menu Header].MenuHeader_ID, [Menu Header].Weekstrating, [Menu
Header].Weekending, [Menu Header].Weeknr, Menu_Detail.Menu_Detail_ID,
Menu_Detail.Menu_Head_ID, Menu_Detail.Menu_Catagory, Menu_Detail.Weekday,
Menu_Detail.Recipe
FROM [Menu Header] INNER JOIN Menu_Detail ON [Menu Header].MenuHeader_ID =
Menu_Detail.Menu_Head_ID;


My problem is that if you design a menu (mealplan) for a week I would like
to see the days listed at the top and the menu catagories to the left, and
then select the recipe names. Like a pivot table only I can not enter data
into a pivot table.

On opening the subform menu_detail I want it to automaticly open 70 records
that is 7 days with 10 menu catagories for each day.

Please any sugestions will do.

Regards
 
K

Keith Wilby

Esrei said:
I have this query:

SELECT [Menu Header].MenuHeader_ID, [Menu Header].Weekstrating, [Menu
Header].Weekending, [Menu Header].Weeknr, Menu_Detail.Menu_Detail_ID,
Menu_Detail.Menu_Head_ID, Menu_Detail.Menu_Catagory, Menu_Detail.Weekday,
Menu_Detail.Recipe
FROM [Menu Header] INNER JOIN Menu_Detail ON [Menu Header].MenuHeader_ID =
Menu_Detail.Menu_Head_ID;


My problem is that if you design a menu (mealplan) for a week I would like
to see the days listed at the top and the menu catagories to the left, and
then select the recipe names. Like a pivot table only I can not enter
data
into a pivot table.

On opening the subform menu_detail I want it to automaticly open 70
records
that is 7 days with 10 menu catagories for each day.

Please any sugestions will do.

Regards
Click to expand...

Use a crosstab query.

Keith.
www.keithwilby.com
 
E

Esrei

There is no number fields in this query that I want to base a form on, i need
to be ale to enter the "recipe ID" and this is text

I woul like a form that looks something like this:

Monday Tuesday Wednesday
Breakfast Muesli

Where the column headings is the weekday field and the row headings dis the
catagorie field, this is standard of every mealplan, just the recipe names
(ie Musli) would change.

If you disign a mealplan this is the easiest way to do it adding data into a
datasheet does not give you a overall picture.

Thanks

Esrei
Keith Wilby said:
Esrei said:
I have this query:

SELECT [Menu Header].MenuHeader_ID, [Menu Header].Weekstrating, [Menu
Header].Weekending, [Menu Header].Weeknr, Menu_Detail.Menu_Detail_ID,
Menu_Detail.Menu_Head_ID, Menu_Detail.Menu_Catagory, Menu_Detail.Weekday,
Menu_Detail.Recipe
FROM [Menu Header] INNER JOIN Menu_Detail ON [Menu Header].MenuHeader_ID =
Menu_Detail.Menu_Head_ID;


My problem is that if you design a menu (mealplan) for a week I would like
to see the days listed at the top and the menu catagories to the left, and
then select the recipe names. Like a pivot table only I can not enter
data
into a pivot table.

On opening the subform menu_detail I want it to automaticly open 70
records
that is 7 days with 10 menu catagories for each day.

Please any sugestions will do.

Regards
Click to expand...

Use a crosstab query.

Keith.
www.keithwilby.com
Click to expand...
 
E

Esrei

Thank you will will search for that, this was the response to the link:

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

/Otherdownload.asp, line 32


Peter Hibbs said:
A Flex Grid Control will probably do what you want. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.

I have this query:

SELECT [Menu Header].MenuHeader_ID, [Menu Header].Weekstrating, [Menu
Header].Weekending, [Menu Header].Weeknr, Menu_Detail.Menu_Detail_ID,
Menu_Detail.Menu_Head_ID, Menu_Detail.Menu_Catagory, Menu_Detail.Weekday,
Menu_Detail.Recipe
FROM [Menu Header] INNER JOIN Menu_Detail ON [Menu Header].MenuHeader_ID =
Menu_Detail.Menu_Head_ID;


My problem is that if you design a menu (mealplan) for a week I would like
to see the days listed at the top and the menu catagories to the left, and
then select the recipe names. Like a pivot table only I can not enter data
into a pivot table.

On opening the subform menu_detail I want it to automaticly open 70 records
that is 7 days with 10 menu catagories for each day.

Please any sugestions will do.

Regards
Click to expand...
Click to expand...
 
E

Esrei

My computer tells me I do not have the licence to use that activex Control,
any other sugestions

Peter Hibbs said:
A Flex Grid Control will probably do what you want. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.

I have this query:

SELECT [Menu Header].MenuHeader_ID, [Menu Header].Weekstrating, [Menu
Header].Weekending, [Menu Header].Weeknr, Menu_Detail.Menu_Detail_ID,
Menu_Detail.Menu_Head_ID, Menu_Detail.Menu_Catagory, Menu_Detail.Weekday,
Menu_Detail.Recipe
FROM [Menu Header] INNER JOIN Menu_Detail ON [Menu Header].MenuHeader_ID =
Menu_Detail.Menu_Head_ID;


My problem is that if you design a menu (mealplan) for a week I would like
to see the days listed at the top and the menu catagories to the left, and
then select the recipe names. Like a pivot table only I can not enter data
into a pivot table.

On opening the subform menu_detail I want it to automaticly open 70 records
that is 7 days with 10 menu catagories for each day.

Please any sugestions will do.

Regards
Click to expand...
Click to expand...
 
P

Peter Hibbs

Esrei,

If you can find a copy of Visual Studio 6 (which includes VB6 and C++,
etc) and install that then you will automatically get the License.

Alternatively, try importing one of the forms from the demo database
into your project and then modifying the form and code to do what you
want. Make a back up first though, just in case.

If you have plenty of money you could also look at -

http://www.componentsource.com/products/componentone-vsflexgrid-pro/index-gbp.html

for a more comprehensive solution (although I have not tried it
myself).

HTH

Peter Hibbs.

My computer tells me I do not have the licence to use that activex Control,
any other sugestions

Peter Hibbs said:
A Flex Grid Control will probably do what you want. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.

I have this query:

SELECT [Menu Header].MenuHeader_ID, [Menu Header].Weekstrating, [Menu
Header].Weekending, [Menu Header].Weeknr, Menu_Detail.Menu_Detail_ID,
Menu_Detail.Menu_Head_ID, Menu_Detail.Menu_Catagory, Menu_Detail.Weekday,
Menu_Detail.Recipe
FROM [Menu Header] INNER JOIN Menu_Detail ON [Menu Header].MenuHeader_ID =
Menu_Detail.Menu_Head_ID;


My problem is that if you design a menu (mealplan) for a week I would like
to see the days listed at the top and the menu catagories to the left, and
then select the recipe names. Like a pivot table only I can not enter data
into a pivot table.

On opening the subform menu_detail I want it to automaticly open 70 records
that is 7 days with 10 menu catagories for each day.

Please any sugestions will do.

Regards
Click to expand...
Click to expand...
Click to expand...
 
E

Esrei

Thank you, I will try the importing this is a small job for a lazy housewife
not worht spending money.

Best wishes

Peter Hibbs said:
Esrei,

If you can find a copy of Visual Studio 6 (which includes VB6 and C++,
etc) and install that then you will automatically get the License.

Alternatively, try importing one of the forms from the demo database
into your project and then modifying the form and code to do what you
want. Make a back up first though, just in case.

If you have plenty of money you could also look at -

http://www.componentsource.com/products/componentone-vsflexgrid-pro/index-gbp.html

for a more comprehensive solution (although I have not tried it
myself).

HTH

Peter Hibbs.

My computer tells me I do not have the licence to use that activex Control,
any other sugestions

Peter Hibbs said:
A Flex Grid Control will probably do what you want. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.

On Thu, 21 Jun 2007 03:00:00 -0700, Esrei

I have this query:

SELECT [Menu Header].MenuHeader_ID, [Menu Header].Weekstrating, [Menu
Header].Weekending, [Menu Header].Weeknr, Menu_Detail.Menu_Detail_ID,
Menu_Detail.Menu_Head_ID, Menu_Detail.Menu_Catagory, Menu_Detail.Weekday,
Menu_Detail.Recipe
FROM [Menu Header] INNER JOIN Menu_Detail ON [Menu Header].MenuHeader_ID =
Menu_Detail.Menu_Head_ID;


My problem is that if you design a menu (mealplan) for a week I would like
to see the days listed at the top and the menu catagories to the left, and
then select the recipe names. Like a pivot table only I can not enter data
into a pivot table.

On opening the subform menu_detail I want it to automaticly open 70 records
that is 7 days with 10 menu catagories for each day.

Please any sugestions will do.

Regards
Click to expand...
Click to expand...
Click to expand...
 
Top