Search results

  1. E

    Question Microsoft Query do not connect DB Access with password

    Hi, I'm trying to connect in a excel spreadsheet an Access Query using MS-Query. It works fine but only if the Database is not password protected. In the menu Data in Excel I choose : From other Sources > From Microsoft Query, select the database and then prompts a dialog box to input login...
  2. E

    Remote Query from DB with Password

    Many many Thanks lagbolt!!! You saved my day! :D
  3. E

    Remote Query from DB with Password

    Dear all, I'm trying to retrieve some information from an external database to setup a report. It works fine when the database does not have a password. Below you find an example: Private Sub Report_Open(Cancel As Integer) Me.RecordSource = "SELECT * FROM tblName IN...
  4. E

    Generate report with data from another Access Database

    Hi sxschech, Thanks for the tip. It works fine but I have now a problem. This database is protected with password. How can I inform the password in the SQL Statement? Many Thanks!
  5. E

    Generate report with data from another Access Database

    Hello, I have a database divided in Back-end and Front-end. I'm trying to generate a report in front-end using the data from Back-end as below: Set db = DAO.OpenDatabase(DatabasePath) Set rst = db.OpenRecordset("tblEmployee", dbOpenDynaset) Me.RecordSource = rst.Name When I try to open the...
  6. E

    Adding controls

    Hi Stopher, you gave me a good idea! Thank you.
  7. E

    Adding controls

    First of all, thank you everybody for the answers. As missinglinq mentioned, I think that it will be a very bad idea. My intention was to create a form where the users can see the values of a table. But it will not work properly creating objects in running time. I think that the better...
  8. E

    Adding controls

    Hello, I am using Access 2010 and I'm trying to create some labels dynamically: Dim myLabel as Label Set myLabel = frmMyForm.Controls.Add ("Forms.Label.1", "lblPrompt") But Access does not recognize the property 'Add'. Do I need to add some library? Thank you in anticipation. :-)
Back
Top Bottom