crosstab -please help

[ssoltic]

I have a form based on crosstab query. when I want to change data that's not possible beacuse qrosstab isn't editable. I create another form to open when I double click on record where I want to change data. When I go back to main form how to move focus to the record where I was.

 

[BLeslie88]

what I used to do...

when I had this problem...

dump the c-t into a temp table... / rst too if you know the code...

work with it... then delete * it ...

while it is populated, you can run update queries to make any changes you want, build work forms on it ...

what ever you want...

 

[ssoltic]

I dont now how to get data from temp table to original table.
With update query surely.
But how to "rotate" data, because my "productId" become column headings in temp table.

 

[BLeslie88]

Run an append query

Run an append query calling your c-t and append it all into a table m8...

 

[ssoltic]

thanks Leslie...

--------------------------------------------------------------------------

Run an append query calling your c-t and append it all into a table m8...
__________________

I have done this. I have form based on that tblTemp

but problem is... how to transfer data back to source table.

If help here's structure of database.

tables: tblDelivery, tblDelivery_details, tblCustomers, tblProducts.
querys: c-t is based on that tables (c-t append data to tblTemp )
forms: frmDelivery based on tblTemp

after I append tblTemp and edit some data in frmDelivery, change is made on tblTemp. My problem is how to update this changes to tblDelivery_details

 

[BLeslie88]

Run an update query....

docmd.runsql(update "code you would get from sql when running the query normallly...")

just run this code on the event required....

It isn't more complex then that.

If you have the rest ready. zip the file and post it. I will find a way to update it doing what I have said and you can see the code.

Maybe I am just not explaining myself well, or you don't understand what I mean, either way, let me fix it and make it so, it will be faster.

Gimme the zip db, and explain what you would like to happen on what event. To further help me, you could add comments in the place where the event should take place ok.

Thanks

 

[ssoltic]

I send you a copy of db.
on Main form click on "Pregled isporuke" to open form on which I working.
form is based on tblTemp, tblTemp is created by "c-t" make table query.
I want to update tblIsporuka_details with changed data from tblTemp.

I hope you come upon in the mess in db.

 

[BLeslie88]

Grrrrr....

look bro.

I wanna help.

U got it zipped.

I can't open 2 IE windows for some idiotic reason, nor do I have time, nor does the techy have time to fix this problem.

So e-mail it to me at :

brian@nbsprinting.com

I will reply asap ok...

Sorry about this.

 

[BLeslie88]

Here ya go...

docmd.runsql("UPDATE tblTemp INNER JOIN Isporuka_details ON tblTemp.ID_isp = Isporuka_details.ID_Isp SET Isporuka_details.Cijena =tblTemp.Napomena ;")

This is an example of how to update a table based on values in tblTemp.

You can update any field from any table running update queries like this.

If you have the values you want in tblTemp, these type of queries should allow you to "update" any fields you want.

If you have more then one table to update...

Run 1, 2 or 3 update queries to acheive your desired updates, all you need to do is run inner joins on the "unique values" between tables...

Hope this helps.

 

[ssoltic]

Thanks Leslie

This is what I'm looking for.


Thnaks a lot