Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Updateable cross tab query

Posted on 2003-03-05
7
Medium Priority
?
224 Views
Last Modified: 2008-03-17
Can you have a Updateable cross tab query? Is there any way to build a form with an updateable cross tab type query?
0
Comment
Question by:dondi1
7 Comments
 
LVL 5

Expert Comment

by:bob_online
ID: 8074782
I don't believe there is -- by it's nature, a crosstab can have "cells" for rows that don't exist.  It is never updatable
0
 
LVL 5

Expert Comment

by:bob_online
ID: 8074786
That's not to say that you couldn't write something using vba that determines the row and column and updates the value in your source table.
0
 
LVL 1

Accepted Solution

by:
Geerd earned 60 total points
ID: 8075252
Perhaps you can use a macro with the query sequences in them. (you can make the most bizar calculations using hidden tabels and actionquries) You could set the event procedure in the form to executing the macro when an update takes place.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 1

Expert Comment

by:Geerd
ID: 8075261
But ofcourse VBA is allot better!
0
 
LVL 1

Expert Comment

by:Geerd
ID: 8075262
But ofcourse VBA is allot better!
0
 

Expert Comment

by:clinresys
ID: 8076023
check out
http://info.exeter.ac.uk/ukaug/i010100.htm

also, see if the PivotTable Wizard might do a better job.
0
 

Author Comment

by:dondi1
ID: 8076308
Thanks all.
I liked Geerd's suggestion. I'll try it.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question