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!

  • Congratulations SkipVought 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: *

  1. HFloyd

    Outlook 2003 Email Flag Follow Up Reminder Not working

    I am having a similar problem. This is what I came across in another forum: "Until Outlook 2007 you will only get reminders popping up from Inbox, Calendar, Contacts and Tasks (the default folders) unless you use a 3rd party addin. In all other folders reminders that are due only turn the item...
  2. 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>...
  3. HFloyd

    calculate median

    Dear Bob, Thanks for the code. I actually managed to locate some great code from the Access Cookbook, basically a DMedian() function in the same structure as the built-in domain functions - DMax, etc., which worked well in a query using an Expression column, even with multiple grouping fields...
  4. HFloyd

    calculate median

    Dear PHV, Thanks for posting the SQL for grouping. Just one question - I noticed that this doesn't work on groups where there is an even number of records. Is there some way to alter the SQL to fix that? Thanks Again! Heather [yinyang] Floyd Innovations http://www.floydinnovations.com...
  5. HFloyd

    ASP.Net on a Tablet PC?

    shatch, Thanks so much for your thoughts. You definitly answered my question about the operating system. Heather [yinyang] Floyd Innovations http://www.floydinnovations.com [yinyang]
  6. HFloyd

    ASP.Net on a Tablet PC?

    cas8msm, I didn't know Apache supported the .Net framework..., I do recall Web Matrix having the built in server, and also available on www.asp.net - Cassini Sample Web Server, which I haven't ever used myself... Still, the Tablet PC operating system... DougP, my current laptop has...
  7. HFloyd

    ASP.Net on a Tablet PC?

    Dear ca8msm, Thanks for your thoughts. Did you have a particular "free and lightweight web server" in mind? I would get a Tablet PC with enough juice to run VS.Net... It's more an issue of whether it's possible to install web servers and database servers into the Tablet PC operating system...
  8. HFloyd

    Visual Studio on a Tablet PC?

    I have cross-posted this question to the ASP.Net Forum as well: thread855-1050925 [yinyang] Floyd Innovations http://www.floydinnovations.com [yinyang]
  9. 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...
  10. HFloyd

    Visual Studio on a Tablet PC?

    A related question.... 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...
  11. HFloyd

    DLookUp() for Reports

    Starlit, Duane is correct about the options. You might find multiple subreports the easiest to work with, but if you have a lot of complex queries backing up the recordsources, it might run a bit slow in opening, so some testing might be necessary. Though I hate storing calculated data, if...
  12. HFloyd

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

    Hey, Thanks for the Star!:-X Heather [yinyang] Floyd Innovations http://www.floydinnovations.com [yinyang]
  13. HFloyd

    DLookUp() for Reports

    Starlit, Where do your "summaries" come from? Are they stored in a table, or calculated on the report (aka, Sum()s, Count()s, etc.). I think Grande is on the right track... If you can access that summary data separate from the reports, you will be able to pull it onto your MEGA report...
  14. HFloyd

    DLookUp() for Reports

    Starlit, Do you mean that you want a "MEGA Report" that encompasses all the data, charts, etc from all your "Regular" reports, or are you tring to make a report that lists the reports you have in your database? Heather [yinyang] Floyd Innovations http://www.floydinnovations.com [yinyang]
  15. HFloyd

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

    Sure, Well, you see, I create a lot of different Access databases for different clients, so I have been in the mind set to make any functions and code I develop to be as easily resuable between projects as possible. One of the things I've developed is a flexible reporting system. There is a...
  16. HFloyd

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

    Thanks, Duane, That did occur to me, and since I was desperate to finish the report I ended up writing a custom function: Function GetLastSection(Rpt As Report, Optional PrintToImmediate As Boolean = False) ' Created 3/22/2005 www.floydinnovations.com On Error GoTo ErrorCode Dim lngCount As...
  17. 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...
  18. HFloyd

    Consistently having to repair a database &gt;:&lt; Thoughts?

    NY, An easy way to figure out who is using which databases would be to create a userlog table in each DB. It can be really simple: UserName (string) Timestamp (date) Action (string) You can then run code or an append query when the DB is opened that adds this info to the table: UserName...
  19. HFloyd

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

    Ah ha! I figured out that the problem was in SQL Server, the stored procedure was not marked as "ASPNET" with "EXEC" permission. Unfortunately, whereas if you go through the motions of cmd.executereader, you get an error message about permissions in SQL SERVER, but if you are using the MS...
  20. HFloyd

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

    BoulderBum, Thanks for the try. Getting rid of "dbCnn.Open()" doesn't change anything. I'm sure the columns "SectionName" and "SecLongDescript" exist, and even if they didn't, the error is appearing before they are referenced. Heather [yinyang] Floyd Innovations...

Part and Inventory Search

Back
Top