Search results

  1. R

    Not displaying blanks in Query with Not Like Criteria

    Thanks namliam, I tried your 1st option and it works......
  2. 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)...
  3. 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...
  4. R

    Draw Thick Border in Report

    This is for my company purpose. I am trying to make a similar format in Access what i am doing now in MS Excel. In Excel format it is thick border i want the same in my access report also that's why i ask for help....?? Otherwise may be the company will not accept.:o
  5. 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...
  6. R

    Data type mismatch in criterial expression

    Thanks...It is working...I was thinking since 2 days for a solution...
  7. 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...
  8. R

    Msgbox for overwrite existing file

    Thankyou for your reply, i can see my file because it is in desktop, that's why i posted this, and also when i create export using macro to the same location it is asking for overwrite...and also i convert that macro to vba, at that time that message is not coming....??:confused:
  9. 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