access crash even all problems solved

[ano]

the form with subforms did show as expected so dynamic cross is working!!
without manual creating the fields
if access crashed i could just restart and continue programming.
but na remove forms repair create forms unexpected parameter popup even filled in crash (was not in past)
creating form b by wizard bought.week,items.item,bought.price,used.used,used .rating this create also form b0 (change create form name) in design view
add code from b4 option2_click to b open_form and close b with save
check if the first few records price 0 not 1 , later 1 to add a column automatic
creating form b1 by wizard query b1 in designview (parameter=11/11/2023)
creating form b2 by wizard query b2.unused in designview (parameter=11/11/2023)
creating form b3 by wizard query b3 resize colunms to minimum readable
close all with save
open form b in designview
add b1 & b2 & b3 to b
close all with save


open form b4 and click option0 to arrange all fields
open form b if popup parameter and or crash thats my problem
no popup expected some colums need smaller not found yet

[Welshgasman]

You have this on form b open
Forms("b").Recordset.MoveLast

Not sure data is available then?, I tend to use form load for any form data when form opens.

I also have no clue what you are trying to do?

[Gicu]

@ano: I don't think you got what I was trying to explain in your previous post; there is no need for the form b3 if you want dynamic columns/rows, just use the actual crosstab query (which you also named b3) as the source object of the "b3" subform control on the "b" form.
Please see attached.

Cheers,

[ano]

You have this on form b open
Forms("b").Recordset.MoveLast

Not sure data is available then?, I tend to use form load for any form data when form opens.

I also have no clue what you are trying to do?

to learn access i decide to track my meals buying and see if i use as least as possible the same vegetables
the move last works fine from beginning
the dynamic crosstab was the problem before (manual creating the needed fields came not up in my mind, till i finally tryed but that is not dynamic ) the many trouble with parameter ( delete/recreate week was no solution) deleting forms did work well before
so i create procedure to arrange the fields (b4 option0) thats working fine to. b4 option2 test dynamic crosstab working fine to, only need remove the wrong first few columns and how to size the columns, but 1st need to get access running again crash on form b after fill in parameter

[ano]

thanks very much vlad
dont understand all those dynamic crosstab solutions
you mean the code let access crash even it run well before
ahhhh it crashes because i close and open, b4 is needed to create or need create form add form delete form
, because you also solved my crash problem.
but why access create subform if i add query.b1 and query.b2? cancel and add source created same as crosstab

[Gicu]

So are you all good now? Make sure the source object property of the subform control is set to Query.qryCrosstab (whatever your actual name is) and not the form created by Access.
Here is some more reading for you:
https://www.access-programmers.co.uk...-query.321026/
Cheers,

[ano]

So are you all good now? Make sure the source object property of the subform control is set to Query.qryCrosstab (whatever your actual name is) and not the form created by Access.
Here is some more reading for you:
https://www.access-programmers.co.uk...-query.321026/
Cheers,

just movelast not working any more
not in open and not in load event
trying to get form only with sql but i think query not allow update its not a view i guess
and even i bind bought and used query cannot bind both query in form ;(
so form b0 is needed only in form b

[Gicu]

Sorry, but I can't follow you, if you need to go to the last record just add only that line. What do you mean by

trying to get form only with sql but i think query not allow update its not a view i guess

?

Maybe you can take the time to explain what exactly do you want to do in this form and each of its subforms.

and even i bind bought and used query cannot bind both query in form ;(

? Not very clear what you mean and what are you trying to achieve. Please take your time to explain in more detail and I'm sure you'll get a lot more helpful and pertinent answers.

Cheers,

[ano]

never mind just back to ur solution perfect job perfect answer
its my style to look for better simplerer solution take time to create but win lots of time solving problems later
answer ur questions:
- if no form needed for crosstab why form needed for union query with parameter
- bought and used seems to use view but cannot find view (query with update possibility)
- did bind during modify form possible to late, but as i said i stick on ur solution

thanks very much for your energy in understanding and solving
enjoy life take care

[ano]

its not dynamic your solution. it not add a column it only update columns. work around is the "IN" so you see empty columns getting updated. the "IN" is also a filter what is displayed so you can have the relevant columns only by lack of scrollbar needed with the freeze option. my solution will work probably if only b3 is closed and opened b4 option0 is still handy if need rebuild forms
cheers enjoy your weekend tc