Search results

  1. S

    Pls help me with the VBA code to refresh all Linked tables in DB

    Hi Sir, How to refresh all tables.
  2. S

    What is wrong in the Code

    Cnt = DCount("Mob", "QOCCUPATION", "DepartureDate = Me!sfrRoomOccupations.Form!DepartureDate")
  3. S

    sending PDF in watsup:

    Can any one help me with the vba code ,if any to send PDF file through watsup, and what are the requirements.
  4. S

    GENERATION OF REPORT

    Is it possible to generate a report, in which first all address will be shown and then the all Name and other details from a single table for exampel it should be like this To add1 add 2 add3 ad4 The details are as follws 1. mr david, team leader 2. mr Robin, head reader etc etc
  5. S

    Solved Is it possible to fetch a pic of signature in a report. And can be changed through a table/query or any other means.

    Actually I want tp print a report under the signature of some officials. But if the officer get transfered to other section of duty, other officer will take charge.
  6. S

    Solved Please rectify me

    Code is Cnt = Nz(DCount("*", "[INDIVIDUAL_DATA]", "[TXTGROUP] = GROUP_PRACTICAL And [TXTCODE] = COURSE_CODE")) both GROUP_PRACTICAL and COURSE_CODE are text field
  7. S

    Solved Deleting blank space

    Is it possible to delete blank space in a Text Box. For example, I am fetching data using Dlookup Function LC = Nz(DLookup("OFFICE", "OFFICE_CODE", "OF_CODE = 1 AND CHK=TRUE")) MC = Nz(DLookup("OFFICE", "OFFICE_CODE", "OF_CODE = 2 AND CHK=TRUE")) NC = Nz(DLookup("OFFICE", "OFFICE_CODE"...
  8. S

    Solved How to Extract and append in another table

    Hi Sir I habe a table MASTER in which four fields are there Course_Code, Ind_ID, Date_from and Date_To: I want to run a query to append the recorde in table SESSION in which four field s are there: Course Code, Ind_ID and DOT (Date of Training) How can I append recorde for each day of training...
  9. S

    Solved UPDATE QUERY

    I want to update all records in a tbl of a numeric field AC_NO with AC_NO preceeded by 9 for example if Account No is 8337453 it should be updated to 98337453. What will be the vba code for query
  10. S

    Solved Dcoount

    I want to count the no of records in QPENSIONER_NEW TBL WHERE YR IS YEAR AND MN IN NAME OF MONTH BUT I AM GETTING ERROR Me.TXTCASE.value = DCount("REC_ID", "QPENSIONER_NEW", "YR = Forms!SERVICE_FORM!CYEAR " And MN = Forms!SERVICE_FORM!CMONTH)
  11. S

    UPDATE QUERY

    My qudate query is not running showing error : key violation. Although when i tries to run the query directly is doesnot show any error and it is updating the records. But when i am trying to run it from the form, due to LOCK violation table not updated. my SQL is UPDATE MEMBERS SET...
  12. S

    Records Not getting updated

    Hi Sir/Madam I am usimg the forlloing SQL, but the records are not updating. UPDATE MEMBERS SET MEMBERS.EL = [EL]+(DateDiff("d",[FORMS]![EMPLOYEE_LEAVE_MASTER]![TXTFROM],[FORMS]![EMPLOYEE_LEAVE_MASTER]![TXTTO])+1) WHERE ((([FORMS]![EMPLOYEE_LEAVE_MASTER]![TXLV])="EL") AND...
  13. S

    Solved To Check if the data is alreday there?

    Hello Sir/Madam Is there any method to check if the same value is already taken in the Data base. I mean suppose a person have taken leave from 12-09-23 to 25-09-23. (two Date fields). If some body tries to enter the value for leave from 13-09-23 to 14-09-23 for the same person, it should flash...
  14. S

    Record are being added double the total records, is there any mistake in SQL

    INSERT INTO CREDIT_MASTER ( LEAVE_TYPE, CREDIT_DT ) SELECT [FORMS]![LEAVE_CREDIT]![TEL] AS Expr1, [FORMS]![LEAVE_CREDIT]![TDT] AS Expr2 FROM CREDIT_MASTER;
  15. S

    Comparision of Two Fields:

    If TXTLV.value = "CML" And txtfrom.value >= TXTDSAN.value Then MsgBox "Commuted Leave can't be presanctioned, Please check!!!!", vbOKOnly + vbCritical, "Hello !! Information incomplete" Me.TXTDSAN.SetFocus Exit Sub End If is there any mistake in code, any value i am putting it flases the...
  16. S

    I want to check for duplicate date before upadating the table. In the Update Button Click Event I have used the follwoing code forcchecking duplicate

    the code is not working , even no error is there, records gets updated with duplicate date?- Please Help anyone Dim NewDt As Date Dim stLinkCriteria As String NewDt = Me.txtfrom.value stLinkCriteria = "[FROM] = " & NewID If Me.txtfrom = DLookup("[FROM]", "[REPORT_LEAVE]", stLinkCriteria) Then...
  17. S

    Date difference Month wise

    Hi Sir/madam I want to get the no of days for each Month between two dates , for eg From 23-Sep-23 to 03-Oct-23. Result I want month wise i.e. Sept -8 Days Oct-3 days (Both days are inclusive) is there any method , in query Can any body help
  18. S

    Room Reservation App

    Please help me to solve the issue of Double Booking. Two consecutive booking cannot be done, even there is no booking. I am tired of trying all aspects. I am attaching the link of My app https://drive.google.com/drive/folders/1M_bXj4hHkMJrsEaxc7jDx8ef7GNHr7f8?usp=drive_link
  19. S

    hi

    hi every one, how to upload a acces application in the forum for your help
  20. S

    I wh=ant to delete a record using this code but error is coming

    Private Sub CMDEL_Click() 'On Error GoTo ErrorHandler Dim sql As String Dim rs As DAO.Recordset Dim ActID As Long ActID = Me.OccupantID.value sql = "SELECT * FROM RoomOccupations WHERE ([OccupantID] = " & ActID & "" Set rs = CurrentDb.OpenRecordset(sql) With rs If Not .BOF And Not .EOF...
Top Bottom