Threads Replies Last Post 253 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Report based on Crosstab query I'm buiding a report (that has subreports, unfortuneately) that i had to resource to a Crosstab query - when I try to make changes in design view, it is REALLY slow - is there a work-around for this ? I don't think you can make a table off a crosstab - I was thinking about exporting the crosstab results to Excel, and then linking, but that seems too convoluted... -- Message posted via ht... 3 29.09.2006 15:42:54 Lebans Report2PDF not Embedding fonts I am having a problem getting Stephen Lebans excellent Report2PDF function to embed fonts in the PDF. It is the core of our Store Signage project, but for simplicity, I am using his sample app in Access 2k just changing a font in one of the reports. (I have not set the PDFNoFontEmbedding flag, just left it as the default False). The PDF gets created ok and displays the correct font, but not... 3 29.09.2006 15:29:29 Calculating "maturity" with queries Hi! I'm having trouble preparing a query (in order to make a report chart). Here is the situation: I have a table where I have each worker, it's admitance date and it's firing date (Fields: ID; Name; AdmitDate;FiringDate). Some workers were hired in previous years, others were hired sometime this year. On firing dates there is a mixture, too: some were fired in previous years, others, duri... 2 29.09.2006 15:24:01 Testing DotNetNuke Project with NUnitAsp Hi all. I am stuck in testing my project developed in DotNetNuke. I am tetsing the project with NUnitAsp, a free testing tool for testing the Asp.net projects. When I compile the project and add its dll to the NUnitAsp, it searchs for Dataprovider, which comes dynamically in dotnetnuke. Though my Application is compiled and runs nicely but it gives an error in NUItAsp as at DotNet... 2 29.09.2006 13:53:40 Need Help Adding a 2nd Where Condition Hello: I have a little script on a command button that prints the Class Attendance sheet for the current class from a One to Many form that works great. However, I want to add another condition to the report’s strWhere condition. That condition is based upon a child table field: IsNull([Attend_Status]) Here’s the current script that works perfectly. Private Sub cmdClassAtten... 11 29.09.2006 11:48:01 Report page layout I have three sub reports in one report. I have separated the reports with a page break, so each report starts on a new page. Here's the question. I want the each report to out put with a different orientation, e.g, 1 report as Portrait, 2nd report as Landscape. Is this possible?? -- Learning SQL and Access... 5 29.09.2006 09:35:02 copy and paste Hi, I copy words from a word document, Eng 97, which include double-quotation mark and paste it to a Access 97 form which field type is memo in Eng Win Xp. After this, when I press the backspace key, chinese character will appear in the place of double quotation mark and when I print, Chinese appears as well. Can you please help? Thanks. ... 4 29.09.2006 06:38:03 User selectable fields in a report. Hello all you friendly people. I need to create a report that enables the users to select the fields they want to see from a form. Problem is i don't want to just hide/unhide the selected fields as this would create empty spaces in between selected fields. I want the report to space and align the selected fields as the report is generated. This should be possible but i recon it would in... 4 29.09.2006 05:54:01 Date Display... The bank wants it that way... Hey all, thanks for listening. My brain teaser is that I need to show a date when I print a Cheque. The issue is the bank has 8 spots on the CQ ... D D M M Y Y Y Y There can be no slashes or dashes.... 9 point font... and no moving(shifting) of Numbers. Probably as I finish writing this I will think of an answer, but if anyone can come up with a way to do this I would apprec... 5 29.09.2006 04:08:02 Print Preview shows 2 horizontal scroll bars When I do a print preview of a report in Access 2007, it pops up in its own window with a horizontal scroll bar. If I then maximise this window the scroll bar appears about 3/4 of the way down the page, and if I then zoom in on the preview, the proper scroll bar appears right down the bottom of the page, but both are usable for scrolling. I'm pretty sure the one 3/4 of the way down is n... 1 29.09.2006 02:15:02 Display the name of the record source (i.e. query's name) in report's footer? I've searched & searched the archives, but no cigar! Your help would be appreciated. (I have very quickly found out how to put the database name in a text box!) Thank you. -- Live Dangerously, but within the law... Message posted via http://www.accessmonster.com ... 3 29.09.2006 00:26:30 Need total of orders in report In the report footer I inserted =Count([OrderID]). Instead of getting total orders, I am getting the total of line items for those orders. The OrderID is in a group named OrderID. I would appreciate it if someone would give me some direction. Thanks, Ron... 3 28.09.2006 22:36:02 Adding a chart to a report with a parameter query I have a report that uses a parameter query. The reports lists ProjectName, ProjectType and FiscalYear with the parameter being FiscalYear. I want to add a pie chart to this report in the report footer that shows the various ProjectTypes as a pecentange of all ProjectTypes in a given FiscalYear. The "Enter Parameter Data" dialog box appears several times and when I get through all of ... 6 28.09.2006 21:34:18 Database freezes when opening reports using VB code Hello, I am using Access 2003 on XP Professional with SP2, split back end/front end. The database freezes when I open reports using VB code but if I open the report via a control's hyperlink subaddress instead of VB everything is fine. This is problematic because I need to run some code when the report is opened so I have to use VB. Does anyone know why this is happening? This occurs on c... 1 28.09.2006 20:57:03 Filtering data I have a report that gets data from a select query. There are three columns of dates. Some columns do not have any dates for some of the rows and some of the rows only have one date in the column. How do I filter out the rows that do not have any columns with dates? Note: my select query is created from three other tables which are also created from three separate make-table querys. ... 3 28.09.2006 20:49:34 sentencias sql para cuadro combinado Saludos amigos, tengo la siguiente inquietud.. he creado un cuadro combinado que me presenta mi listado de todos mis reportes (informes) , y luego, al hacer clic en un boton me presenta el informe La sentencia SQL que utilice para el origen de datos de mi cuadro combinado es: SELECT MSysObjects.Name, MSysObjects.Type From MSysObjects WHERE ( MSysObjects.Name Not Like ""*~*"" A... 1 28.09.2006 20:37:10 Save report to Snapshot I am trying to use the OutputTo macro to save my reports in snapshot, which is working fine. Each report is for indivisual employees so I want to be able to have it save reports as "employees name" & "report name" automatically. How is this done? ... 5 28.09.2006 19:33:59 Date picker trouble I am using the Microsoft Date and Time Picker Control 6.0 (SP4) with MS Access 2002 (SP2) and it is not working. I am using the below code which works fine until I replace the txtDate textbox with the date picker named DTPicker9. Then, the On No Data event fires in the report. Using the same criteria, except with a Date Picker instead of a text box. Dim stDocName As String st... 4 28.09.2006 19:16:00 Combine 3 queries into ONE REPORT. PLEASE HELP! I have three separate queries with some of the same tables in each query. How would I get all three queries to work together to make one report? I had to break down the queries this way because they were too complicated for one query. There are 14 fields to this report over three queries. Now the catch is. The need to be exported to an Excel spreadsheet. How can or where do I begin to do... 1 28.09.2006 18:26:02 Access 2003 - Adding a field to an existing report and filtering d We have a database in our office that contains multiple tables, which are linked in various fashions. A report has been generated which includes a person's name, which department they are employed by, and their start date (this information is being pulled from a Table entitled "Personal"). I need to add a field from another table. I know how to do this, however, when I add this field ... 2 28.09.2006 15:57:47 Problems With Filter Syntax I have the following code but I am doing something wrong with the "if me.fitler" part of the statemenet since it always comes up with the label New Activities Report even when it is an Internal Reference. What is wrong with the syntax? If Me.Filter = "([Type] = 'IR')" Then Me.lblHeading.Caption = "Internal References" Else Me.lblHeading.Caption = "New Activitie... 5 28.09.2006 15:56:21 sum total for report date range I would like for my report to calculate the totals for each column based on the date range parameters entered, but instead I'm getting the cumlative total for each column. I've set up similar reports in the past, but I can't remember what I did to make it work. The formula that I'm using to total each column is "Total Traffic:=(sum([Community Traffic]))". The information will be liste... 4 28.09.2006 15:09:03 Change text before generating report Hello I have a textbox which contains the month and year. It calculates as =Format$([soldmonth];"mmmm aaaa";0;0) I´d like to obtain this information, august 2006 and convert it in another textbox, in something else, another language. something like if soldmonth.caption or value = "august 2006" then texttranslate.caption or text = abuztua 06 else if soldmonth.caption or value = "june2006... 2 28.09.2006 13:30:34 Report from query I have a report which uses results from a query of my database. Both the query and report use data(DUE DATE) that I have set up to input when I run the report. All works well with the report as long as the query has data to return. Sometimes however the query will not find records past the Due date. When this occures the header on the report returns as error. The report header is a textbox as... 2 28.09.2006 12:50:26 Linking from Access to an Outlook calendar. Hello, Is it possible to link (rather than import) an Outlook calendar to a table in Acces? I am using the the 2007 Beta and whilst I have been able to link to a calendar file, it only shows email fields rather than calendar fields. S... 3 28.09.2006 11:04:01 253 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>