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

    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...
  3. 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...
  4. 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