Search results for query: *

Hi All, Hope someone can help..... I am designing an application that will allow users to select different aggregate levels and display the results. For instance, sales at my company can be aggregated (grouped by) store, region, buyer, department, week, quarter, etc. I want to give my users...

I am using Adobe Writer and unfortunately there is no setting like there is in Distiller (at least that I can see)...darn! If I could switch to Distiller, I would, but my program (in Access) seems to bomb when I try. But, I was able to set the bExecViewer registry setting to 0 and this did the...

Hi, I hope someone can help. I am using VB in Access to automatically create pdfs. All works well, except each time a pdf file is created, Acrobat will open the file for viewing. Is there any way I can suppress this launching of Acrobat as my program churns out pdfs? I suspect there is a...

Yes, there is that annoying Excel limit. But actually, my primary goal is to get the data into Access, so .txt, .csv, and .dbf would be fine. The solution our IT department settled on is to open up the datamart so I can write tables of any size. Thanks for all the feedback. D

Hi, Do you mean export it directly into an Access database? When I try that, it still cuts off records beyond 65k. I am begining to think it can't be done unless that Datamart limit is reset - which my administrator indicates will require an upgrade. May have to cut this report into chunks -...

I am running a report which return more than 65,536 rows of data, which seems to be the limit default in the datamart. Is there any way for me to export all rows of data to a .txt, .xls, .dbf, etc format? When I try, it seems that all rows beyond 65, 536 are lost. TIA. D

The reports I am running are at the lowest levels of data - down to the SKU/store level and over time. Not everyone has Microstrategy access here so until they do, I need to extract this data to feed the old reports which are still in Access. The datamart solution sounds viable and I will have...

I am trying to automate a file download process using Microstrategy (v.7.2.1) and Access (v.97). I have multiple reports set up which run fine, but do take several hours. I currently schedule them to run overnight so that they are waiting for me in the morning. However, to export the results...

Thanks for your help, Stickarm and Kyle. I got it working - I knew someone would know how to do this. Doug

I can't seem to remember how to wrap a long sql statement. I am using DoCmd.RunSQL and sql cut and pasted from a query, but the line is too long. I seem to remember a way to effectively wrap this with underscores and ampersands, but it's not working. Help!

Hi Doug, There are about 10 reports, but I'll try your suggestion - nothing else seems to be working. Thanks! D

I have a report bound to a table that will change with each new parameter. The table is created with a make-table query off of a crosstab, so the number of columns may vary. The fields in my report are bound, so when the report is run, if columns of data are missing, I get the parameter prompt...

Yipee! That did the trick, Nick! Now I can finish my report and look like a hero! You get my vote for tipmaster! D

Okay, Nick, looks like I got her ALMOST working. The above error was because I didn't restore all the proper table names (Duh!). Now the field names are changing, but the old data is not being dumped into the new field. Instead, the old field name is being dumped there, repeated over and...

Thanks for responding! Nick, I like your improvements but for some reason I still get hung up on the same line: iPosition = db.TableDefs("table1").Fields(OldField).OrdinalPosition I get an "Item not found in collection" error. Could it have anything to do with the way I am...

I am trying to rename the field names of a table in code. This table (I'll call ChangeTable)is the result of a make table query off of a crosstab, so the field names will always vary, but I do list these fieldnames in a second table (FieldTable). To rename my fields, I am looping through code...

Thanks! I've been wracking my brain trying to figure this out and this solution is so simple I don't know why I didn't think of it! Thank you, thank you, thank you!

Is there a way to change a tables field names with code? I would like to automate a report based on a crosstab query, where the heading will change constantly. Because there are over 400 possible column haedings, using the columns property is out. I tried creating a report with unbound...

Shanti, Thanks for responding! The only thing you are missing is that I am a VB amatuer in over my head. Here's what I have: Dim intX As Integer Dim ColumnTotal(1 To conTotalColumns) As Long Const conTotalColumns = 12 For intX = 2 To intColumnCount 'Column 2 is where the actual data starts...

Can any anyone show me how to sum a column of data in VB on a report? I have a report (based off of a crosstab) using unbound columns which assigns the values to the text boxes at run time. This is done for flexibility and control reasons. So, I can't sum the usual way (assign a value in the...