Search results

  1. X

    Open Report with not null condition

    How to open report with two condition like this DoCmd.OpenReport ReportName:="Test4", WhereCondition:="ID = " & !ID And Me.[SEK_1] Is Not Null, View:=acViewPreview, WindowMode:=acHidden First condition ="ID = " & !ID is ok but when I put second condition And Me.[SEK_1] Is Not Null the return...
  2. X

    MSAccess, Print each Report as pdf with different file name and email

    I have a code for email the whole report to the one recipient. How to print the report separately by customer id with pdf format and email them to related customer? Private Sub Command0_Click() On Error GoTo Err_Handler Dim oApp As New Outlook.Application Dim oEmail As Outlook.MailItem Dim...
  3. X

    Insert INTO SQL with File Dialog

    Hi there, how to choose a Table from difference ms access file to append data with File Dialog? This is my current APPEND QUIRIES INSERT INTO F15 ( SERVICE, YEAR, DUTY) IN 'D:\NS\Labv1.accdb' SELECT F13.SERVICE, F13.YEAR, F13.DUTY FROM F13;
  4. X

    Display data base on query criteria

    I have query base on one table. I want to hide / display row in query base on year (2014). If any Club don't have year 2014, will be hide (in this case, Yellow Club will be hide) other wise any Club have year 2014 will be display (Red and Blue) with all years (2014,2013,2012) in query. Please...
  5. X

    Skip record if match criteria

    Hi, I have 2 forms that refer to 1 table. Both forms share the "brand" field and another field "Continental" for Conti form and Field "Oth" for "Others" Form. What I want is, when I click next record from Conti's Form, only related record are display (the record that related to "others" form is...
  6. X

    Calculate Query

    guys, i need your help. i want to calculate the company expenses and income by months according to variant department in the company. Every data will be recorded based on the respective department. however, i dont have any idea how to calculate the BALANCE field (auto calculate, I prefer query)...
  7. X

    Combine Subquery

    I have a Query "MPFinal" like this, How to combine this statement in to one query, Thks.
  8. X

    Query criteria base on checkbox

    I'm trying to run the following as criteria in an MS access query. Basically what I want to do is: If checkbox (Check0) = True and (Check2) = False, then only records that match the value "HighSc" in Field "ScType" are shown. or otherwise value "Town" in Field "Location" are shown. If...
Top Bottom