Search results

  1. R

    Not displaying blanks in Query with Not Like Criteria

    Dear All, I was trying to filter a word using Not Like "word" in my query cirteria, some data is blank also, From this record i want to retrieve the result. But when i use Not Like Criteria, filter is working but blanks columns are also filtered. I want to display all records (including blanks)...
  2. R

    Layout problems as per screen resolution

    Hi, i want to place a text box at the right bottom corner of a form. I tried but its position is changing as per moinitor sizes. can anyone help...
  3. R

    Draw Thick Border in Report

    Private Sub Report_Page() Me.Line (0, 0)-(0, 14000) Me.Line (600, 3500)-Step(0, 8600) Me.Line (2170, 3500)-Step(0, 8600) Me.Line (3285, 3500)-Step(0, 8600) Me.Line (7435, 3500)-Step(0, 8600) Me.Line (8400, 3500)-Step(0, 8600) Me.Line (9360, 3500)-Step(0, 8600) Me.Line (Me.Width, 0)-(Me.Width...
  4. R

    Data type mismatch in criterial expression

    Hi Everybody:), I am trying to prepare one ageing report, and its almost completed but i cannot make sum() in query as well as report because its coming "Data type mismatch in criterial expression", I tried several times but fed up with this, help me please in this issue. 1. In table i made...
  5. R

    Msgbox for overwrite existing file

    When exporting to pdf format in access 2010, i am not receiving the "do you want to overwrite existing file" message. my Code is like this DoCmd.OutputTo acOutputReport, "LPO", acFormatPDF, "C:\users\touchmate\desktop\lpo.pdf" Anyone can help...?:confused:
Back
Top Bottom