Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: HFloyd
  • Content: Threads
  • Order by date
  1. HFloyd

    Problem with drill-through report parameters

    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>...
  2. HFloyd

    ASP.Net on a Tablet PC?

    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...
  3. HFloyd

    How do I get the number of sections in a report?

    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...
  4. HFloyd

    SqlDataReader - Can't .Read() -Object reference not set to an instance

    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...
  5. HFloyd

    Synchronization failed - Could not update; currently locked

    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...
  6. HFloyd

    Slow code - any suggestions?

    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...
  7. HFloyd

    &quot;Docmd.Gotorecord&quot; no longer functions

    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...
  8. HFloyd

    NoData Event not firing?

    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...
  9. HFloyd

    Ellipses (...) not displaying in forms or queries

    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...
  10. HFloyd

    Access Reports To Adobe PDF Via VBA code?

    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...
  11. HFloyd

    VBA Function to do Find/Replace in records

    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...
  12. HFloyd

    Keep Certain Controls on Same Page in Detail Section?

    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...

Part and Inventory Search

Back
Top