I have built a data viewer in C#.Net for the accounts department that allows them to dig through cubes of financial data and export sets to excel but my boss has asked for the ability to create and manipulate pivot tables (based on this data) within the application rather than having to export to Excel and do it there.
Does anyone know of a good add-in that will provide this graphical functionality?
QueenKirsty
Last Activity: Nov 5 '10, 01:33 PM
Joined: Jul 14 '09
Location:
-
Graphical Pivot Generator Needed
-
Woohoo!
You're a total star! I will try that as soon as I get in tomorrow!
Thank you :o) -
unable to run stored procedure using data from linked server via VBA
Setup:
1. I have a SQL Server 2008 db (called VantageTrans) with a linked server (a Progress db called VANTAGE - the back end of our financial system).
2. I have a stored procedure (spUpdateTblFor File) on VantageTrans (the SQL Server db) that pulls data out of the tables in VANTAGE (the linked server) and dumps the manipulated data into tables in VantageTrans.
Issue:
The stored procedure runs fine on when run... -
That's great. Exactly what I was looking for. :)...Leave a comment:
-
IDE / versioning software suggestions?
I have been asked to make a proposal for a new IT testing & development environment at work but I have no idea where to start.
We are a small team of 3-4 developers and will be developing in a variety of languages for a variety of applications, inculding:
- databases (Oracle & MS SQL Server),
- web services on a custom integration layer (as in SOA not Internet),
- SharePoint & web applications,... -
Copy filtered recordset
I want to export data from forms to excel. I can do the export to excel bit if I can get a copy of the recordset.
I have a form with a filter (that the user can turn on and off) and I want to copy only the filtered data to the duplicate recordset but when I do:
I get all the records not just the filtered ones. The filter being applied is:...Code:Set rs = Me.Controls("SubMiscSiteAccess").Form.Recordset -
Excellent. I'll try that!
Thanks.Leave a comment:
-
Find record on form with Composite PK
Hi. I am trying to move to a particular record on a form where the form has a composite PK.
The PK is made of 3 fields: ModuleID, Precedence and RecordTypeID
I have always used docmd.findrecor d before but I can't see how to do this with a composite PK.
Any suggestions?
Thanks
Kirsty -
That is a very good point. What I have actually done is created a facility to identify the tables that ought to be searched. I have populated this myself in the first instance and have set up a way of allowing the admin user to add more tables to this as needed. It also allows the user to search a subset of tables of their choosing....Leave a comment:
-
Thanks guys, all very useful. I have been pointed to the following sample db that works pretty much the way you were describing.
http://www.hitechcoach.com/index.php...d=11&Itemid=28
It assumes that the first field in each table is the PK (but it is in my case so that's OK) and gives me a semicolon delimlimited string. I can then use the PK and table name to open the correct...Leave a comment:
-
Perfect! Thanks!!!...Leave a comment:
-
I think I get the idea. Cycle through each field in each table and add any matching records to a recordset?
I though about this but didn't know how to concatenate a recordset from different tables with non-matching fields.
Any more hints? :o) I have quite a lot of experience with VBA but am not a full-on expert!Leave a comment:
-
"Google" style search function
I have been asked to create a "google" style search functon for my SQL server 2000 db using and access 2003 (.adp) front end form. I would like to be able to enter something into a text box and have all the records from different tables (where that string occurs in the record) shown in a popup form, from which the user can select one of the records to go to (i.e. they will double click on the record and it will open the proper form for... -
Hi There,
You mentioned in one of your posts a search function for access. I am developing a new interface for my company and they have asked for a "google" style search to find a keyword or id anywhere in the database. Is this the sort of thing your search does and if so please could you point me in the right direction of how to do this? Any and all help would be gratefully appreciated!
Thanks
Kirs... -
on right-click, open in new tab
I am creating an Access 2003 interface (.adp) for a SQL server 2000 backend and want to have some web browser-style features. I currently have a side panel that has the menu structure that can load various forms into a main panel but would like to have a tabbed pages feature like on web browsers. I.e. on right click have an option to open form in new tab. There are serveral questions surrounding this:
1. How do you alter the list of options...
No activity results to display
Leave a comment: