Search results for query: *

Hello, I am using sales data from a cube (MS Analysis Services). I have a report that compares sales for the current day of the month for several years. It shows the data in a matrix like this: Parameters: <choose the month #> (aka "5" for May) (single value) <choose the years>...

I am considering a new laptop, and Tablet PC prices are coming down these days... I do most of my programming on my current laptop (Windows 2K) and I run MySQL, MS SQL Server, VS.Net and do ASP.net programming (so I use IIS (server) for development)... I know that Windows XP Pro includes...

Hello, all, I am trying to get the total number of sections on a report via VBA. Does anyone have experience doing this? This code doesn't work: iTotalSections = rpt.Sections.Count because there is no "Sections" collection. According to MS Help, report sections are an array, but this code...

Hello, I have been getting this common error: Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the...

Hello, I am working on a replicated database for a client located out of state. And have come upon a troubling error. The database is split (data/front end) and only the data part is replicated. The server situation is this: the client has the data "hub" replica located on a shared network...

Dear All, I have written a subroutine that formats a subform based on whether there are records to display or not - basically, it hides some controls if there are no records to display and instead shows a label with a message that there are no records to display. The only problem is that it...

Hello All, I am using Access 2000 SP-3. I have a form (recordsource: tblProjects), which has a subform (recordsource: tblTimesheets) linked on a ProjectID (autonumber). The subform displays as a continuous form. I had created a button in the header of the subform that would go to the last...

Hello, I have successfully used the NoData event for a report in the past, but now it's not working for me. I have a series of forms that gather information from the user before displaying the report: 1) Date range criteria 2) Grouping Option (Day, Week, Month, Quarter, Year) 3) Show the...

Hello, I'm not sure if anyone else has had this problem... I have a form that looks up data from a query and displays it in a text box. The data it is looking up consists of a shortened version of a memo field's text. ([ShortNote]) Since it is a shortened version, I want to display it with an...

This has had me puzzling around in circles for some time... How to have a command button on an MS Access form that will Open an MS Access report and &quot;print&quot; it via Adobe PDF Writer without any additional user intervention. Ideally I would like to be able to specify via my command...

Hi, I was interested in automating &quot;cleanup&quot; of data imported into a database. I was looking for a way to do find/replace operations from VBA code, or preferably, update queries. On this site, I found some code in a post by kramerica (Mar 7, 2002), which worked well, except for not...

Hello, I have a report with a fairly large Detail section (tons of data including a few subreports are included for each record). I understand that in many cases each record will take more than one page to print it all out. My question is this: Since I have the data visually grouped with...