Search results

  1. sundaram

    Not working in window 7

    Dear Friends, Revious I was using windows XP, and now i am using windows 7, Since then my data base is not working, even query, form are not working. Only table is opening. Can any one help me how to operate in windows 7. Regards, RAJAMALL
  2. sundaram

    Query - TotalSalesAmt - TotalPurchaseAmt = Profit/Loss

    Dear Sirs, SELECT TblTran.ItCode, TblTran.Item, TblTran.TUnit, Sum(TblTran.TQty) AS SumOfTQty, Avg(TblTran.TRate) AS AvgOfTRate, [sumofTqty]*[AvgofTrate] AS TotalAmt, TblTran.TTranscatType FROM TblTran GROUP BY TblTran.ItCode, TblTran.Item, TblTran.TUnit, TblTran.TTranscatType; I have the...
  3. sundaram

    Report - Profit / Loss

    I have two tables 1. Purchase - a. Date, Code, Item, Qty, Unit, Rate, Total Amt 2. Sales - a. Date, Code, Item, Qty, Unit, Rate, Total Amt I need a report comprehsive, showing the updated qty and sales - Purcase. Thanks in advance. Regards, RAJAMALLU R
  4. sundaram

    Form - Count Number of days

    Dear Friends, I have table which has: TblResult fields are Fields Date Type Docmentdt as date Description as Text Submitteddt as date Replydt as date NoofDays as Number Now, I want see in Noofdays column that total days if the submitted date...
  5. sundaram

    Primary key

    I have 2 tables: 1 tblEmp, 2tblTime tblEmp consist of empid empname where empid is primary key tblTime consist of empid, empdte, empHours Here When I am entering data tblTime it should be in on particular date empid and empdate should be allowed and it should not be dublicate date of the...
  6. sundaram

    Form - Visible in Read only

    I have created a form, which is consist of "Submitteddate, Accepteddate and Respondate" Text boxes and etc. When ever this form is opend or moves the records by pressing first, next, previous and last. The displayed in the form should be read only. Please adivse me.
  7. sundaram

    Form - Find Date

    The following code is showing only "Not Found", what is error in the code. please advise me. Dim Strsql As String Dim DtCri As Date Dim X As String X = rst.Fields("SUBMITTALDATE").Value DtCri = InputBox("Enter the SUBMITTALDATE", "Enter the Date/", "Question/") If Len(DtCri) = 0 Then MsgBox...
  8. sundaram

    Form Find Date

    Dear, I have tried several ways but it is not pulling the record. "Not Fund" Msg is displaying. I have tried entering date as dd/mm/yyy, mm/dd/yy and dd/mm/yyyy. I table "SubittalDate" is date type and Medium date in display so Please heop me. Dim Strsql As String Dim DtCri As Date Dim X...
  9. sundaram

    Search in a Form - Vb code

    Dim StrSql As String *Dim lngCri As Long* Dim X As String X = rst.Fields("Sr#").Value *lngCri* = InputBox("Enter the Serial NO", "Enter number/", "Question/") If Len(*lngCri*) = 0 Then MsgBox Prompt:="No Criteria Specified", Title:="Search tblEmp.MDB" Exit Sub End If StrSql = "SlNo=*" & lngCri...
  10. sundaram

    Query in a Form

    Dear Frinds, I am very freshner Iam trying to find Serial No of Employee register. SlNo is Long Integer (Data Type) Dim IntSql as integer Dim StrCri as String I am trying, it is showing error Run time ‘3464’: Data type mismatch in criteria expression. I tried SlNo to Text (DATA Type) As...
Top Bottom