Recent content by iknowkungfu

  1. I

    Using ASP(.NET) with MySQL Migrating to MS SQL

    Gizmo, Thanks for that, I've looked through a couple of the slides on that page, even if it's not what you hoped it was! I'm not too worried about MySQL / MS SQL, what I'm more concerned about now is programming in ASP. Can I do that on an ASP.NET server? I know it means writing more/complex...
  2. I

    Using ASP(.NET) with MySQL Migrating to MS SQL

    Apologies if this is a really dumb question but: I need to build a website in ASP/ASP.NET. I'm not sure which my client has It will be connected to a database, either MS SQL or MySQL, again I don't know which. For development I want to get a webhost and it's much easier to get ones with...
  3. I

    Opening a form to a specific record without filtering the other records out

    Props to AnnPhil for a dead simple solution for something that, frankly, a huge number of people ask for.
  4. I

    Error Handler Always Runs

    Ah, the perils of being self-taught and not really understanding (from a Java p.o.v.) the haphazard error handling! Thanks nam
  5. I

    Error Handler Always Runs

    My code is currently running the error handler even if I comment out every single line (apart from strErrMsg and On Error GoTo) in the code, which seems to run perfectly anyway! Function fDeleteXtabs() 'deletes xtab(n) queries 1-9 On Error GoTo fDeleteXtabs_Err Dim strErrMsg As String Dim...
  6. I

    Check whether a query has "No Current Record"

    Sorry, that would work if it was an ordinary query, but because it is a crosstab query and I am using the Nz function to include records where there is no data, it is still returning a value even when there are "No current records". The only solution I can see is to get it to load the query as...
  7. I

    Check whether a query has "No Current Record"

    Excellent, thanks Smart, that worked.
  8. I

    Check whether a query has "No Current Record"

    How can I check from VBA whether a query I have created has no current record? I'm trying to prevent my code from opening a form based on this (crosstab) query if it is empty like this. I have tried using the Report_Error event and also GoTo Err technique inside the report (On NoData event...
  9. I

    Variable In-line Substitution

    Incrementing the counter... old Java habits die hard. 4 lines of code, 1 was redundant, 2 are fine and the other was TRYING to demonstrate what I was trying to do. That's hardly "completely erroneous". Thanks for your help.
  10. I

    Variable In-line Substitution

    I think the title describes what I want to do, but: For example, I want to create multiple recordsets with names created dynamically. For intX = 0 to 5 Dim objRST(intX) As Recordset intX = intX + 1 Next Creating 6 recordsets named objRST0 ... objRST5 I'd then want to process these...
  11. I

    Code stops working despite correct References

    Ah.... ambiguous code. Thanks Bat. WHY ON EARTH doesn't VB/VBA pick up on this? I'm really beginning to hate the loose, silent-error-handling, "RAD" environment! Apparently VB.NET/VB7 is different...
  12. I

    dynamic crosstab report - updated to ADO, works, but needs tuning, plz help

    Thanks Sam, really appreciate that. It worked, up to a point... as with your first posting I had to fiddle with the Header.Caption to get it to work, however, this time it didn't. I've put this on the back burner now in favour of an export-to-excel, but I may return to this as it will likely be...
  13. I

    Code stops working despite correct References

    I'm on the work network machines. We have Office 10 and nothing else. I have just tried Compact and Repair. Specifically, the error is: "Run-time error '13' type mismatch" Private Sub Export_Test_Crosstab_Click() Dim xlApp As Excel.Application Dim xlSheet As Excel.Worksheet Dim...
  14. I

    Code stops working despite correct References

    When I import all of the objects in a sample database, the code that worked before no longer works. I have been through and checked the References in the editor, and they are identical. I am working in Access 2002, and I think the sample database was made in 2003. They are both in Access 2000...
  15. I

    dynamic crosstab report - updated to ADO, works, but needs tuning, plz help

    Thanks for coming back Sam, I well understand the principle (and getting to that point has taught me a lot). I think I even understand how Access prints the rows in the detail section. I have already purchased two Access books (Access 2003 Bible and Access 2003 VBA - Programmer's Reference)...
See more
Back
Top Bottom