Search results

  1. A

    Help Required to calculate Hours and Minutes in a Query

    Dear Sir, I want to calculate time ( Based on Start Time and End Time) in a query (Sample db is attached) I tried couple of methods to achieve the required result. By setting up field to "Number" in Mehtod1 Table calculates as number but can't set as HH:NN. Method 2Table can't restrict input...
  2. A

    Restrict Duplicate Record

    If DCount("*", "[HistoryCM]", "[Local_ID] = '" & Me.Local_ID & "' AND [Noun] = '" & Me.Noun & "'") And Nz(Me.Status, 0) = 0 Or Nz(Me.Status, 0) <> "Open" > 0 Then MsgBox "The Corrective Maintenance of this Equipment is already Open. Open CM of An Equipment cannot be duplicated"...
  3. A

    Form Lock Before Status

    I need a help. (db Attached) Thanks for some friends especially “thedbguy” who shared codes to lock a form by a combobox. I disabled/ Locked a form by a combobox, it works but I want to check some fields, which should be populated before form lock as following; After selecting CLOSED from...
  4. A

    Solved Date Range Error

    I Need a Help. Im trying to filter my form by placing two Unbound boxes ( DateFrom and DateTo) I applied following VBA codes on a Button (CmdSearch) but it did not work. it show a Yellow Highlight on my last line (DoCmd.AppllyFilter task ) Private Sub CmdSearch_Click() Call search End Sub Sub...
  5. A

    Combo Box Not Working

    Dear friends ! I need your help. ( db Attached) Im new to MS Access, I have 3 forms having combo boxes, each form is working perfectly. I created a Navigation Form (Main Form) , by attaching these (sub) forms to navigation Form, Combo Boxes on all forms(Sub) are not working. Thanks
  6. A

    Help to popuplate a dashboard using combo

    Hi.Friends database file is hereby attached for easy reference. plz guide me Im new and having a basic level knowledge of VB. I am facing a problem to make a dashboard. I used a command button. "After click" event following coding were used Private Sub Command2_Click() Me.FormValue.Value = 1...
  7. A

    Search Two dates Range

    I have a query " request" having a field "date". I inserted 2 text boxes on a form and a command button to search record of a date range from query and print a report of search results. Any one plz help my in this regard
  8. A

    Navigation Form in Access 2007

    Navigation Form is a wonderful feature of access 2010 and 2013, however if I create a database in 2013 using this feature, will this database work fine in access 2007 ?
  9. A

    Access on A 64Bit OS

    I am using 64 Bit Windows 8, I have downloaded some sample old version databases for my guidance, but when I try to open the database Same Error Message on all old databases appears. Error is:- " The Code in this project must be updated for use with 64-bit System.Please review and update...
  10. A

    Table fields not showing

    My main table is not showing 02,fields besides that fields are available in all queries and forms. Plz help
  11. A

    Database crashed

    I an using Access2007, while working on a database my saved Database file deleted and an error msg shown that original file deleted and a database.mdb file saved on current location . But I failed to find the new database.mdb file. Plz help
  12. A

    current date

    i want to add current date to my table field through a form, plz help
  13. A

    Forms design

    I am new in Access, I am working on a database. Access-Forum has guided me too much for creating this database and i have learned much more from Access-forum. Today I want to learn a new feature of access 2007; and that is to standardize my all form to full screen and same pixle. my database...
  14. A

    Prevent duplicates in multiple fields

    Dear Friend I need your help. I have a database "Student" having only one table "Registration" which has "ID, Studentname, FatherName, Class and Group" Fileds, and A Form "frm_reg" I want to prevent duplication of records, while entering data into "frm_reg" form in multiple field. Sample...
  15. A

    Export a report into ms excel

    Hi Friends I am new in MS Access, I created a database and want to export my reports in MS Excel Format, but MS Access 2007 is providing xml, rich text document,html and xps format, MS Excel is not listed here, kindly help me
Top Bottom