Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. I

    Dynamic Data Source for Crosstab Queries in a Report

    I need to generate reports that are based on crosstab queries. In total, if they were manually created, I would need 180 crosstabs. This is impractical, inflexible and bad design. And insane. There will be approx 18 different reports with 10 different crosstabs in each. The crosstabs have the...
Back
Top Bottom