Search results

  1. A

    Alias in left Join

    Okay, thanks a lot nice people. I'll give a try. Have a nice weekend
  2. A

    Alias in left Join

    I haven't done the SQL, I got it from a college who left the work. He used to work with Postgres, but I mainly use Access rather than Postgres. Therefore I ask, whether it is possible to convert this PosstgresSQL to AccessSQL. He used a lot of shortcuts of the same table and I never used that...
  3. A

    Alias in left Join

    Here is the whole SQL: SELECT b.bewnr, b.bewsem, a.abschl, a.stg, b.vorname, b.nachname, b.geschl, b.gebdat, b.gebort, staat2.ltxt AS "citizen of", b.pozusatz AS "c/o", b.postrasse, b.zusastrasse, b.poplz...
  4. A

    Alias in left Join

    Hello, does Access use alias in the Left Join? I got this part from Postgre SQL, and I would like to convert it to Access. Select ...., ....., ....... FROM antr a, email e, bew b LEFT JOIN k_akfz staat3 ON (b.staukfz1 = staat3.refakfz AND staat3.sprache='E') LEFT JOIN k_akfz staat1 ON...
  5. A

    How cab we add date selection on the report

    OR put a Lable whose Caption would be: [Forms]![frmReportselection]![txtstDate] & " to " & [forms]![frmReportselection]![txtEndate] yourLable.Caption = [Forms]![frmReportselection]![txtstDate] & " to " & [forms]![frmReportselection]![txtEndate]
  6. A

    Export report to PDF with filename and filepath

    It is not allowed to use the Backslash [/] and the colon [:] in the file name try to replace them with the underscore [_] Filepath = "S_Invoicing_" & Filename & ".pdf"
  7. A

    DataGrid

    Thanks a lot, I'll give it a try.
  8. A

    Close form after open it

    Or try to copy all your Objects (tables, queries, Forms, .....) to a new DB, and check the behavior of your Button. Greetings ....
  9. A

    DataGrid

    Hello EveryOne, in the earlier versions of Access, I could use DataGrid object to show my results. Since Office 2013 it is not possible to use it anymore. Is there a trick to manage these objects (DataGrids, ListViews, ....) Thanks a lot and have nice time.
Back
Top Bottom