Search results

  1. B

    Access Projects

    I'm trying to set up an Access Projects database against an existing MS SQL 7.0 Database in France. I have the logon, password and IP address of the database but I can't seem to get a connection. Is this enough information to set up the connection or do I need more. Thanks in advance.
  2. B

    Printing Reports

    Does anyone know if the "Fit To Page" option used in printing Excel documents can be invoked when printing Access reports, or is there another way ?
  3. B

    Comparing Dates

    I'm trying to compare two Date/Time fields which are both long dates. Each field in a different table. The comparison takes the time into concideration and makes the query run time unnacceptable; the tables are large. I've tried using the Format() function to translate the Date/Time to a text...
  4. B

    Auto Table Attach

    I have an application that has a number of tables attached from a remote database. Periodically the attachement is lost and the application fails. I would like to drop & attach the tables every time the application is started. Does anyone know what functions or code that can do this ?
  5. B

    Clearing A ComboBox

    I'm checking the input to a ComboBox within a form for validity and if not valid I want to clear the box and flash up a message. What code do I use to clear the input box ?
  6. B

    Crosstab Criteria

    I've set up a Crosstab query with one Row one Heading and One Value field. I've added another field against which I want to add a criteria that looks at the value in a Combo box on a form, which is active. As suggested in Help for this field I have the Total section set to "Where" and nothing...
  7. B

    Excel Dump Of Report

    I'm saving the output of a Report to Excel but the order of the columns bears no relation to the report or the query behind the report. How do I set the order of the columns ?
  8. B

    Multiple Items From A List Box

    Help ! Can anyone tell me how to get the multiple items selected from a list box, which has Multiselect set to Extended, into a query which is used by a report.
  9. B

    Automation error

    I'm getting the following error "The object doesn't contain the Automation object 'strLoggedOn'" when running the VB line "DoCmd.RunSQL "INSERT INTO Time_Log (Name) VALUES (strLoggedOn)"". Does anyone know what the problem is ?
Top Bottom