Search results

  1. R

    Opening form move to upper left automatically

    I have created a ms access database for my friend. The login form when I open in my system opens with center position but when I open the same DB in my friends pc the login form opens upper left position. Even it is set auto center. I tried much to solve this problem but I don't succeed. Please...
  2. R

    Subforms in navigation form

    How to refer any field of a subform in a navigation form. Like MynavigationF, MySubform, (Field:StudentID).
  3. R

    pie chart issue

    Here Total Points Are 5 gained points are 2 i want to show this through pie chart on dashbaord but i am not succeed what mistake i am making ????
  4. R

    Don't able to filter subforms

    In ms access DB there is a navigation from with subforms I don't able to use "apply filter" in subforms. I am using where criteria as "Forms! NavigationF! Subforms! ItemId" What mistake I am doing
  5. R

    Pie chart on form

    I have a query with two fields "TotalTasks", "Completed Tasks" I am trying to create a pie chart on dashboard form of my ms access DB. I am not getting the accurate result what is the way to display above data on pie Chart please direct step by step process. I am using ms access 2013. Thanks
  6. R

    DB taking too much time to close

    Please any body help me. this ms access db taking long time to close what is the reason and how to solve this problem ? i am trying to attach the db but it is of 100 mb and not uploading. i compressed to rar and try to attach but rar file is not accepting by the forum so please solve this...
  7. R

    Allowedit property not working

    In my ms access DB in a form i have a button with code me. Allowedit=False But the form is editable after the clicking button. What is the solution.
  8. R

    Loop for a action

    BookingDate Date/Time Field D1 D2 D3 ... ... D31 Here I need when user select a date in booking date field the corresponding field in below text fields change to Booked.these fields are in one table.i have a query with a field Day=date part("d"[booking...
  9. R

    dynamic menu creation

    Public WithEvents menubtn As MSForms.Label Public WithEvents LblBtn As MSForms.Label Dim BtnEve() As New Class1 Private Sub LblBtn_Click() UserForm1.Frame1.Visible = False MyAdd = LblBtn.Name RowNo = Val(Split(MyAdd, ",")(1)) ColNo = Val(Split(MyAdd, ",")(2)) CodeRun =...
  10. R

    Solved Finding specific Record index

    RecID(autoNo) StuID StuName Data 1 1 a Dr 2 2 b Cr 3 1 a Cr 4 1 a Cr 5 2 b Dr In a Continuous Form I Need when I select recid4; a textbox (unbound) Show me “This is 3rd Transaction of this student” So what code will be applied in unbound tex
  11. R

    Solved Find the specific record index

    In a DB There are many transactions of many students with unique student ID I need a VBA code by which I can get the transaction number (Index) of a selected Record of selected student from his all transactions.
  12. R

    Data not appear in printpreview

    when i open report in print preview the details section not appear in ms access
  13. R

    Solved Automating a function

    I want to send a message to students parent on a specific date automatically by setting a date. How can this done by VBA in ms access db
  14. R

    Refering a column

    i have a ms db with employee info when i click a button a message sent to first employee of the table.but i want to send for all employees in the field so how can i refer a hole column by using recordset
  15. R

    Query for filter

    Ok sir I have created a laundry software I want a query in which i can trace (sort) orders which are to be deliverd after 3 Days So i can prepare them before expected Date.
  16. R

    report

    Respected sir, in my db there is a form "order entry" there Qty & unit charge fields are set to default value of "0", So automatic calculation done properly. but when i get report of this record there i also find "0" values. but the client want that in invoice report the empty fields must be...
  17. R

    Name

    I have a database. In a Table "Orders" i have create two fields general customer & Regular customer. If a new customer comes i enter name manually in general customer field .when a registered regular customer comes i select from regular customer field which is a combo box whose rowsource is...
Top Bottom